NOT LISTED FOR SALE

5042 Sandstone Ct Unit 17 Dexter, MI 48130

Estimated Value: $1,091,404 - $1,280,000

5 Beds
4.5 Baths
4,942 Sq Ft
$245/Sq Ft Est. Value

Last Sold April 17, 2015

Last sale price $747,000 $151 Per Sq Ft

Est. 62% increase in value since last sale

Current estimated payment $7,200/month

36 Days on Market

Highlights

  • Private Waterfront
  • Spa
  • Vaulted Ceiling
  • Creekside Intermediate School Rated A-
  • Deck
  • Wood Flooring

About This Home

As of April 2015

Rare opportunity to own a wonderful custom home with spectacular waterfront setting overlooking Crystal Lake. This warm and inviting home, located in The Preserve of Dexter, was built by David Prentice as his own home with great attention to detail. The gourmet kitchen features granite counters & center island, cherry cabinets & hardwood floors. The Great Room features a soaring 2-story ceiling with stone fireplace. Enjoy the convenience of a 1st floor master suite, spacious office with built-ins, breakfast nook and formal dining. Three huge 2nd floor bedrooms, including one with spectacular lake views, provide all the space you need. The finished walkout lower level provides media room, 5th bedroom and 4th full bath. The large deck & patio provide terrific outdoor living areas. Benefit fr from a new water filtration & reverse osmosis system, dual heating & a/c systems and recently seal coated driveway. Just minutes from Ann Arbor, Dexter & freeway access. A great place to call home!, Primary Bath, Rec Room: Finished

Last Listed By

Howard Watts

Coldwell Banker Professionals License #6501308142 Listed on: 02/18/2015

Coldwell Banker Professionals

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,645

Year Built

  • Built in 2002

Lot Details

  • 1.15 Acre Lot
  • Private Waterfront
  • Property fronts a private road
  • Sprinkler System
  • Property is zoned PUD, PUD

HOA Fees

  • $81 Monthly HOA Fees

Home Design

  • Brick Exterior Construction
  • Wood Siding
  • Stone

Interior Spaces

  • 2-Story Property
  • Central Vacuum
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Window Treatments

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Double Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 1 Main Level Bedroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Parking

  • Attached Garage
  • Garage Door Opener

Outdoor Features

  • Spa
  • No Wake Zone
  • Deck
  • Patio
  • Porch

Schools

  • Dexter Elementary And Middle School
  • Dexter High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Well
  • Septic System
  • Cable TV Available

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,645

Year Built

Built in 2002

Lot Details

0

HOA Fees

$81 per month

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • Stories: 2
  • Year Built: 2002
  • ResoPropertyType: Residential
  • Garage Type Attached: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Appliances Microwave: Yes
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dryer, Washer, Disposal, Dishwasher, Microwave, Oven, Range, Refrigerator
  • Interior Amenities: Ceiling Fans, Central Vacuum, Ceramic Floor, Garage Door Opener, Hot Tub Spa, Wood Floor, Eat-in Kitchen
  • Fireplace Features: Gas Log
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 5
  • Main Level Bedrooms: 1
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Basement: Walk Out, Full
  • LivingArea: 4942.0
  • Window Features: Window Treatments
  • Basement Rooms:Basement Finished SQFT: 973.0
  • Kitchen Features:Eating Area: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features:Breakfast Nook: Yes
  • Fireplace:Gas Log: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: Yes
  • Below Grade Sq Ft: 973.0

Exterior Features

  • Construction Materials: Wood Siding, Stone, Brick
  • Exterior Features: Porch(es), Patio, Deck(s)
  • List Price: 750000.0
  • Lot Features: Site Condo
  • Road Frontage Type: Private Road
  • Water Body Name: Crystal
  • Waterfront Features: No Wake, Private Frontage
  • Waterfront: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Deck(s): Yes
  • Exterior Features:Porch(es): Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage: Yes
  • Parking Features: Attached
  • Garage:Garage2: Yes
  • Additional Items:Garage Door Opener: Yes

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air, Natural Gas
  • Heating: Yes
  • Laundry Features: Main Level
  • Sewer: Septic System
  • Utilities: Natural Gas Connected, Cable Connected
  • Water Source: Well
  • Water Well: Yes

Condo/Co-op/Association

  • Association Fee: 975.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Info:Approx Assoc Fee2: 975.0
  • Water Fea Amenities:Private Frontage: Yes
  • Association Info:Assoc Fee Payable: Annually
  • Water Fea Amenities:No Wake: Yes

Schools

  • Elementary School: Dexter
  • High School: Dexter
  • Middle/Junior School: Dexter

Lot Info

  • Lot Size Acres: 1.15
  • Lot Size Area: 1.15
  • Lot Size Sq Ft: 50094.0
  • Zoning Description: PUD
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 9645.0
  • Tax Year: 2015

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 18, 2015
Closed on
Apr 7, 2015
Sold by
Ebrahimifard Badi and Ford Bita
Bought by
Hodgeson William P and Hodgeson Erica L
Seller's Agent
Howard Watts
Coldwell Banker Professionals
Buyer's Agent
No Member
Non Member Sales
List Price
$750,000
Sold Price
$747,000
Premium/Discount to List
-$3,000
-0.4%
Total Days on Market
36
Current Estimated Value
$1,211,601

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$464,601
Avg. Annual Appreciation
4.90%
Original Mortgage
$180,600
Interest Rate
3.77%
Mortgage Type
Credit Line Revolving

Purchase Details

Listed on
Mar 22, 2013
Closed on
Jun 3, 2013
Sold by
Koppin John C and Koppin Michelle
Bought by
Ebrahimifard Badi and Ford Bita
Seller's Agent
Lisa Stelter
The Charles Reinhart Company
Buyer's Agent
Dana Mckie
Howard Hanna RE Services
List Price
$725,000
Sold Price
$650,000
Premium/Discount to List
-$75,000
-10.34%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.72%
Original Mortgage
$520,000
Interest Rate
2.75%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Apr 27, 2007
Sold by
National Residential Nominee Svcs Inc
Bought by
Koppin John C and Tachouet Michelle A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
5.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 21, 2007
Sold by
Hemmingway Charles L and Hemmingway Jennifer D
Bought by
National Residential Nominee Svcs Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
5.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 10, 2005
Sold by
Prentice David and Prentice Linda
Bought by
Hemmingway Charles L and Hemmingway Jennifer D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$560,000
Interest Rate
5.83%
Mortgage Type
Fannie Mae Freddie Mac

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

Similar Homes in Dexter, MI

  • 4034 Glacier Lake Ct, Dexter, MI 48130

    $1,399,999

    • 5 Beds
    • 4.5 Baths
    • 5,227 Sq Ft
    • 4034 Glacier Lake Ct
    • Dexter, MI

    Meticulous custom home on private 1.18 acres in the Preserve Subdivision. Grand 2 story stone/brick home with 5 bedrooms/ 4.5 baths with direct access to the park and Glacier Lake. Enter into an open floor plan with beautiful wood floors, stone surround gas fireplace and natural light throughout. The chef's kitchen features SS Wolf/Electrolux/SubZero appliances. Main floor primary oasis with

    Hope Herron Determined Realty LLC

    Section Image
  • 7136 N Meadows Trail Unit 6, Dexter, MI 48130

    $1,299,000

    • 4 Beds
    • 5 Baths
    • 3,546 Sq Ft
    • 7136 N Meadows Trail
    • Unit 6
    • Dexter, MI

    Welcome home to your new home, a warm and welcoming haven designed for comfort, relaxation, and entertaining! Completely renovated in 2024, this gorgeous property features over 5,500 square feet of fresh, modern living space nestled on a lush 1.5 acre lot.As soon as you step inside, you're greeted by bright, open spaces and inviting rooms filled with natural light. Kick back in the cozy family

    Ali Fayz Real Estate One-Dbn Hts

    Section Image
  • 1131 Beacon Hill Dr, Dexter, MI 48130

    $1,499,000

    • 7 Beds
    • 4 Baths
    • 5,924 Sq Ft
    • 1131 Beacon Hill Dr
    • Dexter, MI

    One of a kind executive retreat located on over 15 acres just moments west of the charming city of Dexter. Walk or bike out your front door to the Border to Border Trail boasting over 30 miles of paved adventure trails, including multiple Metro Parks, the town center of Dexter (soon the City of A2), and other worthy destinations. When you return, don your favorite swimsuit and take a dip in the

    Rob Ewing Real Estate One

    Section Image
  • 2122 Walnut Way, Dexter, MI 48130

    $1,195,000

    • 4 Beds
    • 4 Baths
    • 4,032 Sq Ft
    • 2122 Walnut Way
    • Dexter, MI

    Looking for that rare mix of luxury, land, and lifestyle? This stunning custom-built retreat on 6.49 private acres checks every box—and then some. With over 4,000 finished square feet, 4 spacious bedrooms, and 4 full baths, you'll find room for everyone and everything. Imagine hosting summer pool parties with your own in-ground pool and pool house, or sipping your morning coffee on the heated

    Matthew McKernan The Charles Reinhart Company

    Section Image

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
Hodgeson William P $747,000 Stewart Title Agency
Ebrahimifard Badi $650,000 Liberty Title
Koppin John C $630,000 Fidelity National Title
National Residential Nominee Svcs Inc $775,000 Fidelity National Title
Hemmingway Charles L $854,000 Ab
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hodgbson William P $354,000
Closed Hodgeson William P $169,000
Closed Hodgeson William $169,000
Closed Hodgeson William P $180,600
Closed Hodgeson William P $417,000
Previous Owner Ebrahimifard Badi $520,000
Previous Owner Koppin John C $390,000
Previous Owner Koppin John C $413,000
Previous Owner Koppin John C $413,200
Previous Owner Koppin John C $417,000
Previous Owner Hemmingway Charles L $162,000
Previous Owner Hemmingway Charles L $560,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/17/2015 04/17/15 Sold $747,000 -0.4% $151 / Sq Ft
03/26/2015 03/26/15 Pending -- -- --
02/18/2015 02/18/15 For Sale $750,000 +15.4% $152 / Sq Ft
06/04/2013 06/04/13 Sold $650,000 -10.3% $132 / Sq Ft
06/03/2013 06/03/13 Pending -- -- --
03/22/2013 03/22/13 For Sale $725,000 -- $147 / Sq Ft
Source: Southwestern Michigan Association of REALTORS®

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 $4,439 $477,800 $0 $0
2023 $4,227 $413,600 $0 $0
2022 $14,056 $400,800 $0 $0
2021 $13,282 $407,600 $0 $0
2020 $13,316 $399,500 $0 $0
2019 $12,729 $396,400 $396,400 $0
2018 $12,315 $359,700 $0 $0
2017 $11,770 $363,200 $0 $0
2016 $3,634 $342,000 $0 $0
2015 -- $299,110 $0 $0
2014 -- $278,800 $0 $0
2013 -- $278,800 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 23060358

Southwestern Michigan Association of REALTORS®

APN: 08-03-350-017