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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

137 Singletree Road
Orland Park, IL 60467

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 6
Baths: 7
Status: Active
SqFt: 10486
Agency: HomeSmart Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Custom-designed & built on a double lot, sitting on nearly 1.3 Acres in the heart of Silo Ridge Estates, showing nothing but pride of homeownership. Features nearly 13,386 Sq Ft of pure luxury with resort-like amenities. Incredible design combined with exquisite finishes & master craftsmanship. Attention to detail with beautiful millwork & moldings, knotty alder doors, copper accents, walnut hardwood & slate floors, a commercial-grade elevator and so much more. Naturally lit with dramatic volume ceilings & large windows throughout. You're welcomed by a majestic entryway with a fairy-tale staircase overlooking an executive office and a gorgeous party-sized dining room. A stunning great room with multiple sitting areas, 20-foot ceilings, a limestone fireplace, and beautiful built-in cabinetry. A DREAM 'French-country' kitchen with high-end appliances, an expansive center island, a walk-in pantry, and a view of the pool area. The second level features 4 bedrooms and a wide view of the great room. A large master suite highlighted with 100+ year old reclaimed wood accents, access to a private balcony with a view of your professionally landscaped yard. Gorgeous master bath with a double-sided fireplace, soaker tub, separate shower & custom vanities. Spacious bedrooms offer custom-built bunk beds with lighting, cozy window seats, and custom shelving in each walk-in closet. Two of the bedrooms on the second level share an en-suite bathroom with separate closets, a shower room, a soaking tub, and dual vanity. An additional royal-themed bathroom in the hallway next to the 4th bedroom. A unique second-level laundry room offers 2 sets of washers & dryers, a massive center island, and tons of storage. The 3rd level features 2 additional bedrooms with 2 comfortable-sized sitting areas. Looking for more room? A full, finished lookout basement is waiting for you with 2 rooms, a wide open game room a full bath, a fitness center, and storage rooms. A One-of-a-kind year-round entertaining area with a large indoor pool & spa, waterfall accent, slide, and a large indoor grilling space with multiple sitting areas with access to a wraparound stamped concrete patio. One of the biggest backyards in Silo-Ridge, private & professionally landscaped and includes a sprinkler system. 3-car heated garage with a heated driveway. This unique property has been meticulously kept with many updates including a brand new 2023 $140K roof, new garage doors, professional exterior lighting, a new pool electronic filtration system, a complete surveillance system, and much more. Top-rated schools. A truly special property. Must see in person to appreciate.
MlsNumber: 11999361


Listing Provided By: HomeSmart Realty Group, original listing
Name: HomeSmart Realty Group
Phone: (708) 320-0002
Office Name: HomeSmart Realty Group
Office Phone: (708) 320-0002
Agent Name: Dia Azra
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