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 ('gahud','usahud','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 = 'gahud', 0, 1), IF(i.igate = 'usahud', 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 ('gahud','usahud','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 = 'gahud', 0, 1), IF(i.igate = 'usahud', 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 ('gahud','usahud','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 = 'gahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4600 Riverview
Thomson, IL 61285
BRANDON BEYER with JIM SULLIVAN REALTY, original listing - (815) 947-9040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: --
Agency: JIM SULLIVAN REALTY
Agency Phone: (815) 947-9040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: What an opportunity to own this custom built ranch home situated on 3.47 acres with a front row seat to all of the sights and sounds that the Mississippi River has to offer. While sitting approximately only 150 feet from the waters edge, this 2 bedroom, 2 bathroom house also sits elevated approximately 50 ft above the waters surface to showcase a million dollar view of the Mighty Mississippi while ensuring the peace of mind of being well out of the flood plain. Over 2,000 Sq. Ft. can be found on the main floor including an open concept living area where the kitchen and great room flow perfectly together, and are of course arranged to maximize those river views. A large master bedroom features built in shelving, more river views, an impressive private bathroom with a massive step in shower and an even more massive walk in closet. In addition, the main floor features the second full bathroom with a sauna, the second bedroom, a full laundry room with additional counter space and sink. The basement is a blank canvas, and has plenty of wide open space to finish to your liking that could include an additional family room, a theater room, or a 3rd bedroom with an egress window plus a built in root cellar. A two car attached garage easily protects your vehicles, but perhaps serves as an even better entertaining space with another overhead door exiting to the rear of the garage right out into a stamped concrete patio for outdoor river views. Besides the attached garage is a 60 X 35 heated pole shed with two overhead doors and plenty of room to store all of the toys and equipment! The remaining acreage is a nice flat lawn area that could be used for gardening, wildflower plantings or additional tree plantings. There are only so many properties with a Mississippi River view like this and they rarely come available, so act quick to secure this one!
MlsNumber: --
ListingId: 202501981


Listing Provided By: JIM SULLIVAN REALTY, original listing
Phone: (815) 275-3612
Office Phone: (815) 947-9040
Agent Name: BRANDON BEYER
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