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

484 S Washington Street
Elmhurst, IL 60126

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,575,000
Beds: 4
Baths: 6
Status: Pending
SqFt: 6065
Agency: LW Reedy Real estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2011
Notes: This meticulously crafted and maintained custom home, built by Island Construction, exudes elegance and timeless sophistication. From the all stone exterior and custom front door, the quality construction and attention to detail is evident throughout. Step inside to discover gleaming white crown molding and trim, oak hardwood flooring, and stunning solid mahogany doors that enhance the warmth and richness of the home. The first floor, with soaring 10-foot ceilings, provides the perfect flow for hosting gatherings to include an intimate sitting room with gorgeous arched French doors and coffered ceiling. The dramatic dining room connects seamlessly to the eat-in chef's kitchen through the butler's pantry. The kitchen, featuring a gorgeous granite island with a prep sink, custom cabinetry and high-end appliances, provides the perfect setting for culinary adventures and family dinners. Truly the heart of the home, the spacious family room features a coffered ceiling, built-ins, a stone fireplace and abundant natural light. Upstairs, the primary suite beckons with a gorgeous fireplace, spacious spa-like en suite bath including a heated floor, steam shower and champagne bubble soaking tub, as well as an expansive walk-in closet. A large guest room with an en suite bath ensures comfort and hospitality. Two additional large bedrooms connect with a Jack and Jill bath, sharing only a shower. The carpeted third-floor bonus room offers versatility as an office, playroom or hang-out space. The finished basement, exuding warmth, relaxation and sophistication, features 10-foot ceilings, generous theatre room with 5.1 surround sound. projector/screen, a second family room with a stone fireplace, a full custom wet bar, plus a walk-in 360 bottle wine cellar. The fifth bedroom can double as a home office or work-out room and a convenient full bath adds to the functionality of this versatile space. The heated garage boasts a gorgeous hardwood garage door and a third car tandem garage space, provides ample room to house another car or store all your outdoor gear. Outside, a professionally landscaped yard and bluestone patio create a serene retreat, complete with a wood-burning fireplace and privacy fence. Extras like a Generac backup generator, Central Vacuum system, zoned in-wall speakers and inground sprinkler system add convenience and efficiency to daily life. Amazing location, with ease in accessing the City Centre, Spring Road and the Vallette Business Districts. Steps to the Illinois Prairie Path. Home is agent owned.
MlsNumber: 11985526


Listing Provided By: LW Reedy Real estate, original listing
Name: LW Reedy Real estate
Phone: (630) 833-1700
Office Name: L.W. Reedy Real Estate
Office Phone: (630) 833-1700
Agent Name: Anne Zimmer
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 = 3435 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