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

206 E Ravine Avenue
Willow Springs, IL 60480
Lucy Mierop with RE/MAX Market, original listing - (708) 839-8100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $659,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3253 Square Feet
Agency: RE/MAX Market
Agency Phone: (708) 839-8100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Sellers have upgraded this 4 bedroom 3 bath two car tandem garage. You will find a 3-stop ELEVATOR, business SAFE, MURPHY BED, HOT TUB and HEATED BATHROOM FLOORS. There are no steps to enter the home from the back patio. Anderson Eagle Windows are energy efficient with a 4E rating 2 AC units and 2 Furnaces with 3 temperature zones keep you comfortable in any season while keeping utility cost down. You will see only hardwood and natural stone floors in this home along with 9 + foot ceilings and crown molding throughout. The bookcase, stairway and catwalk railings were built using native oak wood. Imbedded art is evident when you enter this home. Lighted newel post have walnut hand-carved iris inserts. Spindles imitate graceful Swans. Antique pendant lights hang on either side of the skylights in the two-story great room. A 3rd pendant light is in the stairway. The home has a total of 7 skylights and 7 Solar tubes to bring in the light. The great room is separate from the kitchen by a peninsula gas FIREPLACE. The kitchen features ample soft-close underlit cabinets. An oversized granite island contains a prep sink and cooktop with downdraft ventilation. The work area has cork floors. There is a large WALK-IN PANTRY, stainless steel double dishwasher, double oven, wine refrigerator (2023) and drawer microwave. A freezer and second refrigerator are in the basement. Kitchen and bathrooms fixtures are kohler. Bathroom were custom design by Kohler. Master bathroom has a 2-person shower with 7 shower heads that is located between the two underlit ONYX SINKS. You will feel like you are at the spa in the guest bathroom that features a massaging bubble tub,rain showerhead and fiber optic lighting. Two bathrooms FLOOR ARE HEATED. In the generous bedrooms you fnd beveled and tray ceilings. All bedrooms have spacious WALK-IN CLOSETS. Enjoy watching the sunset from The Master bedroom balcony. Sellers are professionals and have utilized the 2 bedrooms for offices with one containing the Murphy bed. A teakwood-lined sunroom off the kitchen that is heated & cooled features a therapeutic Hot Tub. an aggregate floor is artfully decorated. Outdoors - relax in the 10 x10 gazebo (refurbished 2024) with a stream of water flowing beneath. This property offers so much it is a MUST SEE if you want outdoor water features and love GARDENING. A 1650 - gallon rainwater reservoir is used to flush toilets, for gardening and the stream. A smaller WATER FEATURE Greets you as you enter from the front. There is a full English basement with 9+ceilings and a walkout to the backyard. Water heater is new 2024. The insulated garage has a 14 ft. ceiling and a 2nd 8x 8 ft. garage door to the backyard. Come on by and see the upgrades and all this exceptional home has to offer.
MlsNumber: --
ListingId: 12265245


Listing Provided By: RE/MAX Market, original listing
Phone: (708) 558-8800
Office Phone: (708) 839-8100
Agent Name: Lucy Mierop
Disclaimer: Copyright © 2025 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