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 = 646 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 646 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 646 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

7500 Us Highway 34
Oswego, IL 60543
Jeanne DeLaFuente Gamage with Keller Williams Infinity, original listing - (815) 267-1158

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3184 Square Feet
Agency: Keller Williams Infinity
Agency Phone: (815) 267-1158

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: STUNNING!!! REMODELED HOME WITH WATER VIEWS!!! This One of a Kind Property has been Updated and is Move-In Ready. This home sits on 1.86 acres of land with 42' of Fox River frontage and has magnificent mature oak trees! What a Remarkable Kitchen with Tons of Counter Space, Custom Cabinets, Quartz Countertops, Farmhouse Sink, Island with Seating, Canned and Pendant Lighting, Stainless Steel Appliances, Hardwood Floors and Pantry Closets. The first floor Laundry Closet has Custom Barn Doors and utility sink. The large Living Room has an Updated Fireplace Mantel and Hearth, Updated Lighting and Hardwood Floors. The Dining Room includes a Decorative Beam in the Ceiling, with Sliding Glass doors to the Expansive (20'x30') Deck. Perfect for Entertaining!!! The first floor also includes an Office Space with a Cedar Mantel and Trim and Expansive Sun Room. The Sun Room is an Amazing Space to hold Family Gatherings and has Luxury Vinyl Flooring, Bar Area and PTAC unit. The Master Bedroom Suite was Re-Designed to include a Custom Built Walk-In Closet and Master Bathroom with Dual Vanity, Soaking Tub, Large Glass Walk-In Shower with Ceramic Tile. The Second Floor has an Updated Guest Bathroom and Two Nice Sized Bedrooms. The Hardwood Floors in the stairway, hallway and two bedrooms have been refinished. The Basement has a finished Recreation Room with a Franklin Stove that conveys and a huge Storage Area. The Outdoor Space is Something Special: There is a total of Four and a Half Car Garage spaces which includes: an Attached Two Car garage, plus a Detached Heated Two and a Half Car Garage. In addition a Shed is located in the back yard that is perfect storing all of your lawn equipment. Extensive Landscaping has been completed including a Firepit plus and an additional Brick Paver Patio Sitting Area by the River. The Roof was Replaced in 2024. All Kitchen Appliances were replaced in 2020. Hot Water Heater 2021. Water Treatment System 2020. Water Softener 2023. The Central A/C was replaced by the previous owner in 2019 and the furnace in 2012. Driveway has been repaved.
MlsNumber: --
ListingId: 12364078


Listing Provided By: Keller Williams Infinity, original listing
Phone: (630) 542-3652
Office Phone: (815) 267-1158
Agent Name: Jeanne DeLaFuente Gamage
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