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

69308 Pine River Drive
Romeo, MI 48065

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 5
Baths: 6
Status: Active
SqFt: 4602
Agency: Ascendent Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1996
Notes: An Incredible setting for this magnificent executive home in the Pine River Estates neighborhood of Bruce Township. Featuring 400 feet of Stony Creek meandering around a beautiful pond, and a wooded rear yard, this property may be your own oasis. The beautifully appointed one and a half story Neo-traditional home features over 7,400 square feet of finished living space and includes five bedrooms, four full bathrooms, two half bathrooms and a finished walkout lower level. With over $380,000 of updates, and upgrades over the past 3 years, this property will surely impress. Key features include: An entry level primary suite with separate sitting room w/fireplace. Nana folding glass walls that open from the Primary bedroom to the four-season room w/heated ceramic floor. The finished walk-out LL includes a wet bar, wine cellar, 5th bedroom, full bathroom, a family room w/ fireplace, a large rec room and more. The LL paver patio includes a built-in infrared grill and deck rain protection above. The 2nd level offers 3 bedrooms, two full bathrooms, a bonus room and a loft. The three-car garage is heated, the floor is epoxy coated and metal storage cabinets are included. The barn is 24'x24' w conc. floor and upper level accessed from driveway and lower level from walk-out area. Updates include a completely remodeled kitchen w/ Amish built cabinetry, Sub-zero, Wolf and Cove appliances. The great room bar w/new cabinets, Sub-zero & Scottsman appliances. Butler pantry with new full height cabinetry. All windows and glass doors were replaced w/ Andersen Eagle custom windows. A new 24kw standby generator. Attic insulation was increase to R-60. A Quiet Cool whole house fan was added, all fireplace gas logs were updated, the irrigation system was updated with new 5 horse pump, all hardwood floors refinished, and the whole house reverse osmosis system was refurbished. Earlier updates include driveway 2018, roof 2019, one furnace 2015, one furnace 2020, well pump in 2020, one A/C unit 2018. Ask for full list of features.
MlsNumber: 20240014329


Listing Provided By: Ascendent Realty, LLC, original listing
Name: Ascendent Realty, LLC
Phone: (248) 475-4600
Office Name: Ascendent Realty, LLC
Office Phone: (248) 475-4600
Agent Name: Anthony Scaccia
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 = 3329 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;
Dominic Shaba
ASCIIeXp Realty
Call Today!: (619) 246-7525

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App