query
RESULTSET
query
  CITYNAME REGIONID SHORTNAME
1 Joliet 1 Romeoville and Joliet
CACHED false
EXECUTIONTIME 0
SQL SELECT c.cityname, c.shortname, s.regionid FROM CITY c, csp s WHERE c.cityid = ? AND c.cspid = s.cspid
SQLPARAMETERS
array
1 1392
query
RESULTSET
query
  HOUSINGNAME
1 TownePlace Suites by Marriott - Joliet
2 Fairfield Inn & Suites by Marriott - Joliet North/Plainfield
3 Comfort Inn - Romeoville
4 Quality Inn & Suites - Joliet South
5 Comfort Inn - Joliet North
6 Best Western Inn & Suites - Joliet
7 Country Inn & Suites - Romeoville
8 Fairfield Inn by Marriott - Joliet South
9 RX Housing
10 Oakwood - Furnished Apartments in Romeoville IL
11 Lexington Inn & Suites - Joliet/Plainfield
12 Wingate by Wyndham - Joliet
13 Extended Stay America - Romeoville
14 Hampton Inn & Suites - Minooka
CACHED false
EXECUTIONTIME 0
SQL SELECT housingname FROM housing h WHERE h.cityid = ?
SQLPARAMETERS
array
1 1392
Joliet Extended Stay Hotels and Corporate Housing - Biz-stay.com Joliet Corporate Housing and Extended Stay Hotels - Biz-stay.com
 Visitor center
Useful Joliet info:
Joliet Dining

Joliet Extended Stay
Discounted online reservations


Joliet:

Share |

Extended Stay Hotels (Economy)

Extended Stay America - Romeoville


North of Joliet. Renovated in 2013. Designed for long-term travelers. Studios feature full kitchens, ample workspace, free WiFi, cable TV and on-site laundry. Book online for guaranteed lowest rate. Weekly and monthly discounts available.
Map   

Extended Stay Hotels (Midpriced)

TownePlace Suites by Marriott - Joliet


Joliet southwest, near I-80. Built in 2008; Renovated in 2015. 100% nonsmoking. Extended-stay studios, 1 & 2-bedroom suites, all with fully-equipped kitchen & free WiFi. Free breakfast. Weekly/monthly discount rates online. Pets allowed.
Map