Title Page Background
DEBUG FN args: Array ( [0] => 671 [1] => [2] => [3] => agent ) BEFORE: Site: 671 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 671 Igate: njhud LocID: 671 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 = 671 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 671 [1] => [2] => [3] => lender ) BEFORE: Site: 671 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 671 Igate: njhud LocID: 671 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 = 671 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 671 [1] => [2] => [3] => other ) BEFORE: Site: 671 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 671 Igate: njhud LocID: 671 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 = 671 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3816 W Hearthwood Drive
Dunlap, IL 61525

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $474,900
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 3732 Square Feet
Agency: Jim Maloof/REALTOR

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer, Water - Softener
Architectural Style: Other
Construction Materials: Brick, Vinyl Siding, Frame
Heating: Central Furnace, Forced Air, Fireplace
Interior Features: High Speed Internet, Wet Bar, Vaulted Ceiling(s), Ceiling Fan(s), Cable Available, Blinds, Jetted Tub, Bar, Solid Surface Counter, Garage Door Opener(s), Foyer - 2 Story
Rooms: Office, Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Den, Dining Room, Kitchen, Laundry, Great Room, Family Room
Utilities: Cable Available

Window Features

Exterior Features: Level, Porch, Patio, Irrigation System
Parking Features: Garage
Patio and Porch Features: Patio, Porch
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Wilder Waite
Middle/Junior High School/District:
High School/District: Dunlap
Subvidision Name: Trail View Estates

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: COMING SOON-Showings start Friday, May 3rd, at 5:00pm .Simply stated, there isn't another home like this on the market in Dunlap, or throughout central Illinois. This north facing 6 bedroom (4 on the 2nd level, 1 on the main and 1 in the lower level) , 4 full bath home (2 up, 1 main, 1 below), complete with a main level office, two story great room and a covered rear patio, is as updated as it is immaculate. New in the last few years-tankless water heater, kitchen fridge, washing machine, dishwasher, garbage disposal, fireplace surround, sump pump, front and back re-stained porch, and upgraded alarm system. That's not to mention the updated primary and guest bathrooms, garage fridge, roof, completely remodeled kitchen and 1st floor full bath! The yard is fully irrigated and there's a whole house vacuum, to round out just a portion of the extras! All appliances remain-that means all kitchen appliances, as well as the washer, dryer and garage fridge! Just a short stroll from the Rock Island Trail, schools, parks, interstate access, shopping and dining! This is, without a doubt, the nicest home on the market in Dunlap under $750K. There is even a whole house water filter and reverse osmosis system for the water/ice on the fridge! Honestly-there is absolutely nothing left to do or upgrade with this amazing home! Just move in, unpack and enjoy the good life! Mid July Closing Preferred
MlsNumber: --


Listing Provided By: Jim Maloof/REALTOR, original listing
Phone: (309) 692-3900
Office Phone: (309) 692-3900
Agent Name: Mark Monge
Disclaimer: Copyright © 2024 RMLS Alliance. 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