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 = 621 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 = 621 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 = 621 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;

3 Arcadia Court
Burr Ridge, IL 60527

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2008
Notes: Sought after Cul-de-sac location in Falling Waters Gated Community. Meticulously, Custom Built Walkout Ranch. This home encapsulates the epitome of luxury, such as, the 6-Car Garage for car collectors, with Garage Doors on both ends of the Garage. This is so owner and guest can drive thru and never have to back your car out of the garage. This home offers everything you could desire. 6 Bedrooms, 5.2 bathrooms. Double Washer and Dryers on Main Floor so you never have to wait while doing laundry. Views in the Main bedroom gives you a feeling you are in a Forest. Walk in closet is 19 x 11 with 3 rack system for seasonal clothes all tucked behind glass wardrobes. Main Bath has double sink, walk in shower for 2, with European body spray system. Jacuzzi Tub with relaxing homeopathic jets. The heart of this home is the huge entertaining Kitchen. It's a CHEF delight boosting top of the line stainless steel appliances and a massive Island to prep food and entertain! 2 skylights over Island brings in morning sunshine. Caterers' kitchen tucked off of dining room, so guest never have to see your dirty dishes while entertaining. Dining room and Family room have a beautiful fireplace separating the 2 seating areas. Mosaic tiles adorn the fireplace and give a sparkling affect when lit. Wrap around bar from kitchen to Great room with sink and Artwork, Is the perfect area to do your Mixology. A cozy sitting area included so guest can Munch while Host Prepares your drinks. Dining room ceiling is barrel shape with indirect lighting. Electronic shades in Family room and Main Bedroom, which helps filter out damaging rays while enjoying the southern exposures. Hardwood and granite flooring. Three-bedroom suites on the first floor. Wonderful in- law arrangement on 1st floor with bathroom and bedroom connected. Includes sitting area off of the kitchen which creates a Welcoming space for Daily Living and makes entertaining Easy and Relaxing! From the first floor you have the ability to walk out to the garden area. First floor has 10 ft ceilings and Lower level has 9 ft ceilings. Full finish Walk-out lower level with access to gardens. Includes 2nd Kitchen, bar, family room and formal living room, 2 bedrooms and work out area, 3 Furnaces, Floor heater (Boiler system), TWO 75-gallon hot water heater. In storage area, you are able to see where it's dugged out for future Elevator Shaft. If you have been searching for ONE LEVEL living this home will accomodate your needs. Schedule a viewing today and let this be your Dream Home.
MlsNumber: 12042724


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: Rebecca Singh
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.


Local Real Estate Expert

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 = 621 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;
Real Estate Expert Photo for Larry Lazar
Larry Lazar
ASCIICharles Rutenberg Realty
Mobile: (312) 933-7822

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App