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

957 Breckenboro
Lake Summerset, IL 61019

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $244,900
Beds: 4
Baths: 2
Status: Active
SqFt: 936
Agency: Best Realty, L.L.C.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: CHARMING HOME NESTLED IN THE VACATION-LIKE COMMUNITY OF LAKE SUMMERSET! This recently updated home is situated perfectly to offer stunning views of the lake! The welcoming kitchen boasts new cabinetry, Corian countertops, an island, upgraded flooring, and SS appliances, including a trash compactor. Perfect for cooking enthusiasts! The open-concept living areas flow from the kitchen and dining room into the spacious living room with a gorgeous plank vaulted ceiling, new sliding doors and windows with more beautiful lake views! With over 1870 sq ft of comfortable living space, this fully exposed ranch home with a full-walkout lower level, offers 4 generously sized bedrooms, 2 updated full bathrooms, a large family room, ample sized laundry room, upgraded flooring throughout, and egress windows. Relax and enjoy the outdoors and lake views in any weather in the screened-in porch or cozy 3-season room or on the large deck great for entertaining! This pet-friendly home has an underground fence, dog-run, doggie door and a “catio” door for your furry friends. There is also a large yard, 2-Car Garage , and Active Radon Mitigation System- Located close to Duck Park for easy kayak launching, and fishing this gated, golf-cart friendly community has 2 beaches, pool, fishing, boating, a dog park, pickle ball, archery range, and a campground. Don’t miss your chance to live the lake life!
MlsNumber: 202402717


Listing Provided By: Best Realty, L.L.C., original listing
Name: Best Realty, L.L.C.
Phone: (815) 248-3408
Office Name: Best Realty
Office Phone: (815) 248-3408
Agent Name: Tammy DeMus
Disclaimer: Copyright © 2024 Rockford Area MLS. 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