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

59445 Foxpointe Lane
South Lyon, MI 48178
Robert Cuffe with Remerica Integrity II, original listing - (734) 637-7000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 3413 Square Feet
Agency: Remerica Integrity II
Agency Phone: (734) 637-7000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: I'm gorgeous inside and out! Hurry over to this Must-See custom-built full brick ranch, featuring 4 bedrooms all with their own ensuite baths. Windows galore throughout the whole house let in so much natural light. A chef's delight kitchen boasts a built in Viking gas cooktop, Viking refrigerator, a double oven, bar fridge, 42" shaker style cabinets offering an abundance of storage space. Large granite island with prep sink and bar style seating, plus large dining area and vaulted ceiling. Spacious great room features wood floors, vaulted ceiling, 4 sided gas fireplace and expansive views to the backyard oasis. Retreat to the Primary bedroom suite, also with vaulted ceiling, spacious walk-in closet, new carpet, and a sliding door leading to the deck. Primary bath has sunken jetted tub, large vanity and seperate walk in shower. All other bedrooms have 10ft ceilings, have brand new carpet, 2 of the ensuite baths are newly remodeled. Whole house is freshly painted. All interior doors are solid wood 8ft. Lofted area with skylights is a great extra space. You will be mesmerized by the newly remodeled, finished daylight basement with brand new carpet and paint, brand new granite kitchen area/wet bar. A Large stone hearth w/gas fireplace adds warmth and coziness to the TV/gathering area. And there's still so much storage space! Step outside to experience the ultimate in outdoor living, with multiple entertaining spaces, including an outdoor kitchen, covered gazebos, a sparkling inground saltwater pool w/slide. All this is surrounded by lush mature trees and stunning landscaping. Other recent updates include newer furnaces & A/C (approx 2019), This property has the perfect balance of relaxation and recreation.
MlsNumber: --
ListingId: 20240058618


Listing Provided By: Remerica Integrity II, original listing
Phone: (734) 637-7000
Office Phone: (734) 637-7000
Agent Name: Robert Cuffe
Disclaimer: Copyright © 2024 Realcomp Limited II. 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