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

254 Foxford Drive
Cary, IL 60013
Katarzyna Kaminska with United Real Estate-Chicago, original listing - (630) 748-4660

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2499 Square Feet
Agency: United Real Estate-Chicago
Agency Phone: (630) 748-4660

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: EXPERIENCE THE ULTIMATE PEACEFUL LIVING IN THIS STUNNING, RARELY AVAILABLE TWO-STORY TRADITIONAL RESIDENCE, PERFECTLY SITUATED ON A FOXFORD HILLS GOLF COURSE WITHIN THE PRESTIGIOUS FOXFORD COMMUNITY, METICULOUSLY UPDATED IN 2018. THE FIRST FLOOR SHOWCASES A BRIGHT AND AIRY FOYER, COAT CLOSET, AND A BEAUTIFULLY APPOINTED KITCHEN EQUIPPED WITH GRANITE COUNTERTOPS, BACKSPLASH, PANTRY CLOSET, AND SLEEK GE STAINLESS-STEEL APPLIANCES. THE ADJACENT DINING AREA OVERLOOKS THE EXPANSIVE, BRAND-NEW DECK AND GOLF COURSE, PERFECT FOR YEAR-ROUND RELAXATION AND ENTERTAINMENT. UNWIND WITH LOVED ONES IN THE COZY FAMILY ROOM AND/OR LIVING ROOM, IDEAL FOR GATHERINGS AND SPECIAL OCCASIONS. THE SECOND LEVEL BOASTS A SERENE MAIN SUITE WITH A SPACIOUS 7X5 WALK-IN CLOSET, LARGE BATHROOM WITH SOAKING TUB, SEPARATE SHOWER, AND JACK-AND-JILL SINK. ADDITIONAL FEATURES INCLUDE TWO GENEROUSLY SIZED BEDROOMS, ONE WITH CUSTOM-MADE SHELVING IN THE CLOSET, AN EXTRA FULL BATH, AND CONVENIENT LAUNDRY FACILITIES. THE BASEMENT OFFERS AN ADDITIONAL BEDROOM, LARGE CLOSET, UTILITY/STORAGE ROOM, AND EXTRA STORAGE IN THE CRAWL SPACE. THIS EXCEPTIONAL PROPERTY BOASTS NEUTRAL COLORS, WHITE DOORS & TRIMS, GLEAMING HARDWOOD FLOORS ON THE FIRST FLOOR, LARGE WINDOWS ALLOWING FOR AN ABUNDANCE OF NATURAL SUNLIGHT, AND RECENT UPDATES INCLUDING A NEWLY PAINTED FRONT EXTERIOR, HIGH-EFFICIENCY HVAC AND A/C INSTALLED IN 2021, A WATER HEATER FROM 2018, A NEWLY PAVED DRIVEWAY FROM 2023, AND A METICULOUSLY MAINTAINED TWO-CAR GARAGE. THE PROFESSIONALLY LANDSCAPED AND MANICURED LAWN IS THE PERFECT FINISHING TOUCH. A TRANQUIL WALKING TRAIL PROVIDES ACCESS TO TOWN, FEATURING RESTAURANTS, COFFEE SHOPS, AND METRA. THE RESIDENCE IS WITHIN WALKING DISTANCE TO DEER PATH ELEMENTARY SCHOOL, CARY JUNIOR HIGH SCHOOL, AND FEL-PRO RRR CONSERVATION NATURE WALKING TRAILS. THIS HOME IS READY FOR IMMEDIATE OCCUPANCY AND ENJOYMENT.
MlsNumber: --
ListingId: 12306473


Listing Provided By: United Real Estate-Chicago, original listing
Phone: (708) 415-0408
Office Phone: (630) 748-4660
Agent Name: Katarzyna Kaminska
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.


Local Mortgage Pro

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 = 662 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;
Real Estate Expert Photo for Brian Bachtell NMLS#2580785
Brian Bachtell NMLS#2580785
ASCIIThe Money Store
Call Today!: (847) 571-6699
Office: (708) 730-2003

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App