Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3438 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3438 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3438 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

7742 167th Street
Tinley Park, IL 60477

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,900
Beds: 4
Baths: 2
Status: Pending
SqFt: 2240
Agency: Century 21 Affiliated.com

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: RECENTLY REHABBED AND PERFECTLY MAINTAINED FOUR BEDROOM RAISED RANCH JUST STEPS AWAY FROM ALL THAT TINLEY PARK, ORLAND PARK, AND ORLAND HILLS HAVE TO OFFER. THIS BEAUTIFUL HOME IS JUST MINUTES AWAY FROM RETAIL, RESTAURANTS, SCHOOLS, AND MULTIPLE PARKS. THE MAIN LEVEL FEATURES AN OPEN FLOOR PLAN LIVING ROOM/DINING AREA COMPLETE WITH NEWER FLOORING, MASSIVE WINDOWS PROVIDING AMPLE NATURAL LIGHT, AND UPDATED FIXTURES. THE DINING ROOM IS ALSO OPEN TO THE KITCHEN WHICH INCLUDES ALL STAINLESS STEEL APPLIANCES, NEWER COUNTERTOPS, NEWER FIXTURES, NEWER BACK SPLASH, AND DOOR LEADING OUT TO THE BACK YARD! THE MAIN LEVEL OF THE HOME ALSO INCLUDES THREE SPACIOUS BEDROOMS WITH AMPLE CLOSET SPACE/STORAGE AND RECENTLY UPDATED FULL BATH. THE LOWER LEVEL OF THE HOME INCLUDES A MASSIVE DEN/ADDITIONAL LIVING SPACE COMPLETE WITH RECESSED LIGHTING THROUGHOUT, UPDATED FIXTURES, AND NEWER FLOORING. THE LOWER LEVEL ALSO INCLUDES AN ADDITIONAL SPACIOUS BEDROOM, UPDATED FULL BATH, AND MULTIPLE EXIT POINTS(SLIDING DOOR & SIDE DOOR) OUT TO THE FULLY FENCED IN BACK YARD!! THE EXTERIOR SPACE ALSO FEATURES MULTIPLE DECKS, PATIO SPACE, ABOVE GROUND POOL, HOT TUB, AND EVERYTHING NEEDED FOR OUTDOOR ENTERTAINING! OVERSIZED 2.5 CAR GARAGE IS ALSO PEFECT FOR YOUR HOME GYM OR ADDITIONAL STORAGE/WORK SPACE! THIS HOME IS A MUST SEE - SCHEDULE YOUR SHOWING TODAY!
MlsNumber: 12041576


Listing Provided By: Century 21 Affiliated.com, original listing
Name: Century 21 Affiliated.com
Phone: (708) 945-5501
Office Name: Century 21 Circle
Office Phone: (708) 945-5501
Agent Name: Jaclyn Gilbert
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App