Title Page Background
DEBUG FN args: Array ( [0] => 607 [1] => [2] => [3] => agent ) BEFORE: Site: 607 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 607 Igate: njhud LocID: 607 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 607 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 607 [1] => [2] => [3] => lender ) BEFORE: Site: 607 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 607 Igate: njhud LocID: 607 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 607 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 607 [1] => [2] => [3] => other ) BEFORE: Site: 607 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 607 Igate: njhud LocID: 607 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 607 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

28-23 Southview
Lake Carroll, IL 61046
JULIE WENZEL with RE/MAX TOWN LAKE & COUNTRY, original listing - (815) 493-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 3105 Square Feet
Agency: RE/MAX TOWN LAKE & COUNTRY
Agency Phone: (815) 493-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: WATERFRONT HOME WITH 118 feet of shoreline and a paved cart path! Completely renovated in 2025. Contemporary Lake house offers 5 bedrooms, 2 additional extra rooms, 4 full baths and so much room for weekend guests. 2 fully finished levels. Main floor has Vaulted ceilings and a gas log fireplace in the living room. The fully equipped kitchen is flanked by 2 dining areas. There are 2 bedrooms with and a full bath on one side of the house and a private primary Bedroom Suite on the other. The primary bedroom has a patio door toward the waterfront, walk-in closet, soaker tub, separate shower and double sink vanity. A NEW maintenance free deck runs the length of the home with patio doors from the dining area and the primary bedroom. There is a main level laundry and an attached two car garage. The completely finished lower level has sliding doors to a full patio and leads to the gentle slope to the water. The walk out LL has 2 generous living areas, a fireplace and bar. There are 2 bedrooms, 2 full baths and an extra room. A paved cart path leads to the waterfront. The waterfront has a sea wall and a stamped stone concrete patio and fire pit. Dock will stay. Renovations include: 2025 Upgrades, New windows, New roof, New furnace, New water heater, New kitchen cabinets and countertops, New bathroom vanities and countertops, New deck built with composite low-maintenance materials, New LVP, tile and carpet flooring and completely painted inside, New interior doors and trim, New lighting New bathroom fixtures and updated plumbing, Natural gas and fiber internet run to home
MlsNumber: --
ListingId: 202502667


Listing Provided By: RE/MAX TOWN LAKE & COUNTRY, original listing
Phone: (815) 541-1001
Office Phone: (815) 493-7653
Agent Name: JULIE WENZEL
Disclaimer: Copyright © 2025 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