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

505 Fox Hollow
Dekalb, IL 60115

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $344,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 2844
Agency: RE/MAX Experience

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1996
Notes: Prepare to be Impressed with This Stunning 4 Bedroom, 2844 Sq. Ft. Two Story Home on .39 Acres with Private and Secluded Backyard Retreat! Freshly Painted Front Porch Welcomes You Inside the Two Story Hardwood Foyer Which Opens Beautifully to 2nd Floor with Abundant Natural Light. Wonderful Floor Plan Features Elegant Living and Dining Rooms with Hardwood Floors & Window Cornices, Gourmet Kitchen with Abundance of Schrock Tiered Cabinetry with Crown Molding and Under-Lighting, Large Quartz Island with Amazing Counter-space, Stainless Steel Appliances, Hardwood Floors, Tile Backsplash, Butlers Pantry, Wet Bar, Breakfast Bar, and Charming Eating Area with Brick Wood-burning Fireplace! Spacious Sunken Living Room with Gleaming Hardwood Floors, Gas Stone Fireplace w/Hearth and Sliding Glass Doors to Brick Paver Patio. Conveniently Located Mud Room Off of Garage with Half Bath, Cabinets, and Large Closet. Generous 2nd Floor Landing with Hardwood Leads to Primary Bedroom with Double Doors, Hardwood Floors, Walk-In Closet and Luxury En-suite Bath with Jacuzzi Tub, Separate Shower, Vanity and Tile Floor. Full Hall Bath and Large Laundry Room with Closet, Cabinetry, & Tile Floor. Bedrooms have Freshly Cleaned Carpets and Ceiling Fans and 2nd & 3rd Bedrooms with Walk-In Closets. White Solid Six Panel Doors & Trim Throughout. Nest Thermostat System, Reverse Osmosis system, and Ring Doorbell stay. Private and Secluded Backyard Retreat is Maturely Landscaped & Fully Fenced with Freshly Painted Pergola, Brick Paver Patio, Swing-set & Play Set! Unfinished Basement with Crawlspace Has Room for Even More Expansion. This is A Truly Lovely Home with Convenient Proximity to NIU & the Interstate! Priced to Sell at $121 Per Square Foot! This is the One You Have Been Waiting For!
MlsNumber: 12012550


Listing Provided By: RE/MAX Experience, original listing
Name: RE/MAX Experience
Phone: (815) 751-4631
Office Name: RE/MAX Experience
Office Phone: (815) 895-8900
Agent Name: Dorothy Baumgartner
Disclaimer: Copyright © 2024 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