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

3664 Edelweiss Road
Elgin, IL 60124

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $608,975
Beds: 4
Baths: 3
Status: Pending
SqFt: 2833
Agency: RE/MAX Ultimate Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: SOLD AT PRINT Modern designs and upscale finishes start with the dependable Brick and James Hardie siding exterior. This Home has been highly upgraded with the designer select package which includes, upgraded cabinets with crown, cabinet hardware, upgraded quartz subway tile backsplash, 5"wide engineered hardwood flooring in kitchen foyer and powder bath, upgraded bathroom cabinetry with hardware, ceramic tiled shower with frameless glass door, transom window in owners shower, 5 1/4" white painted trim, 5 1/4" crown molding in owners suite, and prairie style rails with black knuckle balusters. Also upgraded to include hardwood floors running the entire first floor, a full lookout basement, including rough-in plumbing for a future bath, Direct vent fireplace, additional windows in the family and bedroom, craftsman door, humidifier and laundry tub. There are many other standout features you'll love in this 4 bedroom, 2.5 bath home. The private study, just off of the 2-story foyer looks out onto the covered front porch. The kitchen features GE stainless steel oven, dishwasher, and a large island designed with a sink, as well as an overhang for additional seating! The breakfast area connects the kitchen and family room and although separate, a formal dining room is also connected to the kitchen. The second floor is home to the owner's suite with a private bath (upgraded to the garden owner bath) and designer walk-in tiled shower and oversized walk-in closet. The three additional spacious bedrooms are centrally located around the second full bathroom and upstairs laundry room. Energy efficiency package with James Hardie Board siding, 13 seer air conditioner, 95% furnace, 40-gallon water heater, and Low-E vinyl double pane windows with grills. Situated in a country setting, yet minutes to Randall Road corridor with access to entertainment, restaurants, and shopping. This wonderful community offers a park, and splash pad and is part of the sought-after St. Charles Community School District 303 schools! Drive into the Ponds of Stony Creek and watch the magic being built at Homesite 314. Please note photos are not of the actual home, but of another similar model. Elevation pictures may vary. Pictures are of the onsite model home and the actual home exterior mimics the rendering and not the model. Incentives tied to using Lennar Mortgage. Ask the Associate for details.
MlsNumber: 11977219


Listing Provided By: RE/MAX Ultimate Professionals, original listing
Name: RE/MAX Ultimate Professionals
Phone: (815) 725-4545
Office Name: RE/MAX Ultimate Professionals
Office Phone: (815) 725-4545
Agent Name: Sarah Toso
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 = 644 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