$1,525,000 - $8,500,000
RENTED MAR 28, 2025

1700 Great Fosters Ct Rochester, MI 48306

6 Beds
14 Baths
20,064 Sq Ft
$297 Price per Sq Ft

About This Home

Welcome to an exceptional estate set on nearly 8 acres, encompassing over 30,000 square feet of luxury living. Step into the grand foyer leading to a stunning main level featuring a great room adorned with unparalleled woodwork. The adjacent dining area showcases ceiling and floor woodwork that beautifully harmonize.
Indulge in entertainment with a first-floor theater and retreat to a private indoor oasis featuring a cascading waterfall, hot tub, full kitchen, two full baths, and a changing room all in the indoor pool area. The primary suite is a lavish escape with an enormous bath and expansive closets. Additionally there are 5 other bedroom suites that will certainly impress. Discover hidden luxuries like a private game room with a full bar. The property also boasts a unique garage with an elevator lift capable of accommodating over 15 cars. An in home elevator services all levels, including the custom walkout lower level.
This home epitomizes luxury and sophistication—it's a true masterpiece of design and comfort, complete with exceptional amenities for the discerning homeowner.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Dec 18, 2006
Sold by
Beacon Centre Llc
Bought by
Mars John W and Mars Lisa K
Current Estimated Value
$5,962,631

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Mars John W $400,000 William T Sheahan Title Co
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/28/2025 03/28/25 Rented $41,667 0.0% --
03/28/2025 03/28/25 For Rent $41,667 -- --

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $73,855 $5,109,380 $0 $0
2023 $71,017 $4,485,710 $0 $0
2022 $105,156 $4,166,020 $0 $0
2021 $98,879 $4,103,030 $0 $0
2020 $69,196 $4,109,200 $0 $0
2019 $104,386 $3,963,970 $0 $0
2018 $104,775 $3,931,090 $0 $0
2017 $103,166 $3,818,690 $0 $0
2016 $79,916 $2,985,370 $0 $0
2015 -- $2,363,350 $0 $0
2014 -- $1,712,290 $0 $0
2011 -- $270,090 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map