NEW CONSTRUCTION Escape to peaceful country living in this stunning custom built 2,000 square foot Ranch on 2 acres. 3 bedrooms and 2 1/2 baths. Large den/office with french doors and large closet. 3 car attached garage. Open concept kitchen and large living room. Quartz countertops in kitchen and bathrooms. Custom lighting package in kitchen. Stainless steel appliances. First floor laundry. Open staircase to basement with finished treads. 9 Ft ceilings on main floor and 9 Ft ceilings in basement. One week away from getting Certificate of Occupancy
Single-familyProperty Type
2025Year Built
2.06 acresLot Size
$260Price/Sq.Ft.
3 car garageParking
Listed by Amy Badke• Spirit Realty Inc
Bought with Raphael Roufail• Signature Sotheby's International Realty Bham
Est. $3,052 per month, based on comparable rentals
Sale and tax history for 23401 29 Mile Rd
Sale History
Tax History
Date
Event
Price
REALCOMP #58050190363
Apr 13, 2026
Sold
$520,000
$260/sq ft
Mar 31, 2026
Pending
—
Mar 27, 2026
Listing Removed
—
Mar 23, 2026
Pending
—
Mar 5, 2026
Relisted
—
Mar 4, 2026
Listing Removed
—
Feb 18, 2026
Price Changed
$525,900
$263/sq ft
Oct 3, 2025
Listed
$540,000
$270/sq ft
MiRealSource-MiMLS #50190363
Apr 13, 2026
Sold
$520,000
$260/sq ft
Apr 13, 2026
Sold
$520,000
$260/sq ft
Mar 23, 2026
Pending
—
Mar 5, 2026
Relisted
—
Mar 3, 2026
Listing Removed
—
Feb 18, 2026
Price Changed
$525,900
$263/sq ft
Oct 3, 2025
Listed
$540,000
$270/sq ft
Oct 3, 2025
Listed
$525,900
$263/sq ft
NEW CONSTRUCTION Escape to peaceful country living in this stunning custom built 2,000 square foot Ranch on 2 acres. 3 bedrooms and 2 1/2 baths. Large den/office with french doors and large closet. 3 car attached garage. Open concept kitchen and large living room. Quartz countertops in kitchen and bathrooms. Custom lighting package in kitchen. Stainless steel appliances. First floor laundry. Open staircase to basement with finished treads. 9 Ft ceilings on main floor and 9 Ft ceilings in basement. One week away from getting Certificate of Occupancy
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Macomb County
APN
21-05-13-351-017
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jan 14, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached
Interior
Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Appliances: Gas Water Heater, Dishwasher, Disposal, Oven, Refrigerator, Range
Room Information
# of Rooms Total: 7
Has Basement
Basement Details: Block, Full
Exterior
Pool Information
Pool Features: None
Building Information
Above Grade Finished Area: 2,000
Above Grade Finished Area Units: Square Feet
Levels: One
Construction Materials: Brick
Foundation Details: Block
Property Features
New Construction
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: SingleFamilyResidence
Property Condition: New Construction
Lot Information
Lot Size Dimensions: 200 x 450
Lot Size Acres: 2.06
Financial
Tax Information
Tax Annual Amount: $420
Utilities
Utility Information
Water Source: Private, Well
Sewer: Septic Tank
Location
HOA Information
Has Homeowners Association
Schools Information
High School District: NewHaven
Location Information
Subdivision Name: METS AND BOUNDS
Cross Street: North Avenue / New Haven Road
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Macomb County
APN: 21-05-13-351-017
Home facts updated by county records on Jan 14, 2026
Other
Listing Information
List AOR: MiRealSource
Around this home
Schools
New Haven Elementary School
Public K-4 • Assigned • 5.4mi
4/10
New Haven High School
Public 9-12 • Assigned • 5.1mi
7/10
Provided by GreatSchools
Historical weather
Ray, MI • 48096
Average low and high temperatures (°F)
28
15
34
18
51
30
60
39
67
46
80
58
83
64
80
60
77
54
66
43
49
36
36
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 2.3 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
2.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$537,000 – $650,000
Reach more buyers when you sell with Redfin. Plus, you'll save $5,647 in fees.