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

18170 Parkshore Drive
Northville, MI 48168

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 4
Baths: 6
Status: Pending
SqFt: 4001
Agency: Curtis-Botsford Real Estate LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2000
Notes: Elegance & luxury abound in 4000 sq ft Moceri built home w/57’ of shoreline on beautiful crystal clear Teal-Stoneridge Lake. Stunning lake views from all levels of East facing lake side of home. Luxurious 2 story 20’ entry foyer w/stone flooring at the base of stylish grand staircase. Solid oak flooring & 9’ ceilings throughout the main level that seem endless. A formal Living Room & sitting parlor w/gas fireplace total 28’. The formal Dining Room sits 12 or more w/ease. The truly great 2 story Great Room is 24’ long w/ beautiful custom built ins & fireplace chase w/ornate custom woodwork & floor to ceiling windows that bathe w/morning sun & offer stunning lake views. The breakfast area & dream Kitchen offer panoramic views of Teal Lake & an 8’ high doorwall opens to a elevated composite protrusion deck affording 180 degree lake views. Main floor Laundry & Mud Room lead to 3+ car garage w/9’ ceiling. The 1,750 sq ft custom finished Lower Level features fully equipped Second Kitchen, Wet Bar, huge Family Room w/hand scrapped hardwood floors, 2 gas fireplaces, Theatre/Media Room w/surround sound, Fitness Center, 2 Bathrooms & 14’x10’ Bonus Room (potential Bedroom). Lower Level walks out to18’x18’ paver patio w/paver walkway direct access to the lakeshore beach & your own boat dock. With a few adjustments the Lower Level can easily be an ultra private & comfortable Multigenerational Living Space. Two staircases lead to the Second Level & overlook bridge above the Great Room. The large Primary Suite windows face Teal Lake w/breathtaking lake views from the Primary Bedroom & sitting area & includes a 14’x15’ walk in closet/dressing room w/custom built ins. Bedrooms 2 & 3 are spacious w/walk in closets & flank a large Jack & Jill Full Bathroom w/2 custom vanity spaces. Spacious Bedroom 4 is bright and sunny & includes a walk in closet & an adjoining Full Bath. New roof, two hi-eff zoned furnace/AC systems (one is newer), newer 75 gal hi-eff water heater & fresh interior paint in 2019, very well maintained home.
MlsNumber: 20240013013


Listing Provided By: Curtis-Botsford Real Estate LLC, original listing
Name: Curtis-Botsford Real Estate LLC
Phone: (248) 539-7321
Office Name: Keller Williams Home
Office Phone: (248) 626-2100
Agent Name: Roy S Callan
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.


Local Real Estate Expert

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 = 3459 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;
Real Estate Expert Photo for Melissa Beebe
Melissa Beebe
ASCIIeXp Realty, LLC.
Call Today!: (734) 347-8542

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App