- 3 beds
- 3 baths
- 1,836 sqft
- 14,375 sqft lot
- $201 per sqft
- 2025 build
- – on site
Brilliantly Built New Construction on a Premier Corner Lot Welcome to an exceptional opportunity: a brilliantly built new construction home perfectly positioned on a desirable corner lot. This residence offers the ultimate in modern design and thoughtful craftsmanship, ready to welcome its first owners. Step inside and be immediately impressed by the expansive open-concept layout, meticulously designed for seamless living and perfect for entertaining. The generous flow between living, dining, and kitchen areas creates a bright and inviting atmosphere, ideal for hosting gatherings of any size or simply enjoying everyday comfort. This stunning home features three spacious bedrooms and two full, exquisitely finished bathrooms, providing ample comfort and privacy for everyone.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jul 10, 2025
•
MLS# 25033923 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2025
-
New Construction:true
-
Construction Materials:Vinyl Siding
-
Building Features:None
-
Building Area Total:1836.0
-
Architectural Style:Colonial
-
Roof:Shingle
-
Foundation Details:None
-
Stories:2
-
Basement:No
-
Basement:Full
-
Basement:Yes
-
Common Walls:None
-
Window Features:Insulated Windows
-
Accessibility Features:36 Inch Entrance Door
-
Accessibility Features:Yes
-
Direction Faces:None
-
Exterior Material -Vinyl Siding:true
-
Roofing -Shingle:true
Interior
-
Rooms Total:10
-
Fireplace:false
-
Furnished:None
Room Dimensions
-
Living Area:1836.0
-
Main Level SqFt:918.0
-
Upper Level SqFt:918.0
-
Basement SqFt:918.0
Financial & Terms
-
Ownership:Private Owned
-
Listing Terms:Cash, FHA, Conventional, Assumable
Location
-
Directions:use google or apple maps
-
Cross Street:Thimbleberry Eastlund
-
Latitude:42.628141
-
Longitude:-84.528668
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:No
-
Current Use:None
-
Parcel Number:33-25-05-22-452-026
-
Zoning:None
-
Lot Features:Corner Lot
-
Lot Size SqFt:14375.0
-
Lot Size Acres:0.33
-
Lot Size Area:0.33
-
Lot Size Units:Acres
-
Topography:None
-
Waterfront:false
-
View:None
-
View:No
-
Corner Lot:true
-
Inclusions:None
-
Possible Use:None
-
Frontage Type:None
-
Waterfront:No
-
Road Frontage:242.0
Listing Agent
- Contact info:
- Agent phone:
- (734) 536-1265
- Office phone:
- (248) 255-3259
Taxes
-
Tax Year:2024
-
Tax Year:2024.0
-
Tax Legal Description:UNIT 26 BERRY FARMS CONDOMINIUM INGHAM CO CONDO SUB PLAN NO 301 SPLIT/COMBINED ON 08/19/2021 FROM 33-25-05-22-451-004; SPLIT/COMBINED ON 09/28/2021 FROM 33-25-05-22-451-005;
-
Tax Annual Amount:3500.0
-
Annual Property Taxes:3500.0
-
Tax Assessed Value:23205
-
Taxable Value:23205.0
Beds
-
Bedrooms Total:3
Baths
-
Total Baths:3
-
Total Baths:2.5
-
Partial Baths:None
-
Full Baths:2
-
Full Baths:2
-
Half Baths:1
-
Three Quarter Baths:None
-
Half Baths:1
-
Quarter Baths:None
The Listing
-
Virtual Tour URL Branded:None
Heating & Cooling
-
Cooling:No
-
Heating:true
-
Heating:Forced Air
-
Heat Type -Forced Air:true
-
Heat Source -Natural Gas:true
Utilities
-
Sewer:Public
-
Sewer -Publictrue
-
Water Source:Public
-
Water Public:true
Appliances
-
Laundry Features:Main Level
Schools
-
Elementary School District:None
-
Middle Or Junior School District:None
-
High School District:Holt
The Community
-
Association:No
-
Pool Private:No
-
Senior Community:No
Parking
-
Parking Total:None
-
Parking Features:Attached
-
Garage:true
-
Garage Spaces:2.0
-
Attached Garage:true
-
Carport Spaces:None
Monthly cost estimate

Asking price
$370,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$1,981
|
Taxes | $291 |
Insurance | $101 |
Utilities | $145 See report |
Total | $2,518/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.