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;

1835 Butterfield Lane
Flossmoor, IL 60422

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1790
Agency: Better Homes and Gardens Real Estate Connections

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1956
Notes: "THIS IS A ONCE IN A LIFETIME OPPORTUNITY"!!!!!! $299,900 WITH AN APPRAISED VALUE AT $335,000.....INSTANT EQUITY! !!!!! SELLERS ARE RELOCATING DUE TO WORK AND MUST SELL. . . . This is a must-see dream home in Flossmoor, Illinois, where the perfect blend of family living and comfort awaits you! This charming 3-bedroom, 2-bathroom home plus additional bonus room offers 1,790 square feet of beautifully designed living space. Uniquely designed and sits gracefully as the ideal viewing entrance to a low traffic family-oriented cul-de-sac on over half-acre lot, presenting a picturesque setting that feels like your private sanctuary. Step inside and be greeted by an inviting interior that exudes warmth and charm creating a harmonious space for everyday living and entertaining. Large windows bathe the home in natural light, casting a cheerful ambiance throughout. The eat in galley modern kitchen has ample counter and cabinetry space, wall oven, and newer cook top stove, designed for functionality and style. A huge unfinished basement (plenty of space to be creative) attached 2 car garage, full circle driveway for additional guest parking. Step outside to the expansive backyard, where you'll find a brand-new large deck, an abundance of space for outdoor activities, parties and gardening. The master bedroom is on the lower level and a peaceful retreat with an en-suite bathroom for your comfort and convenience. The two additional bedrooms on the upper level are extremely spacious and versatile. A few extra features.... HVAC systems with smart operation technology, new water and sump pump. Nestled in the highly sought-after community of Flossmoor, this home boasts a prime location. Enjoy the tranquility of suburban living while still having easy access to top-rated schools (Homewood Flossmoor High School), suburban eats and shopping areas, local biking and walk paths, local parks, and a variety of amenities. Commuting to nearby areas is a breeze and minutes away with convenient access to major highways. Don't miss the chance to make this your forever home in one of the most prestigious suburban areas. Schedule a showing today while it last.
MlsNumber: 11930565


Listing Provided By: Better Homes and Gardens Real Estate Connections, original listing
Name: Better Homes and Gardens Real Estate Connections
Phone: (219) 999-8990
Office Name: Better Homes and Gardens Real Estate Connecti
Office Phone: (219) 999-8990
Agent Name: Christina King
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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