Agent profile image in chat bubble
Agent profile image in chat header

Jenn Smart

| SEO pages, v2 chat

Agent profile image in message

55294 Hanford , Utica, MI 48316
$675,000
Est. Payment: $3,517.52/mo
3 Bed
4 Bath
2120 Sqft
Status: pending | Days on site: 2
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275
By proceeding you are providing Jenn Smart with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from Jenn Smart. Messages and data rates may apply. Message frequency varies. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms & Conditions and Privacy Policy.

House Description

Exceptional craftsmanship defines this meticulously maintained custom-built ranch in desirable Shelby Township. Designed for everyday living and entertaining, this home showcases premium finishes and custom upgrades throughout. A welcoming foyer with custom wainscoting and millwork leads to the great room featuring tray ceilings, expansive windows with motorized blinds, and a floor-to-ceiling stone gas fireplace. The chef's kitchen features ceiling-height cabinetry with crown molding, an oversized custom quartz island, quartz countertops, designer tile backsplash, premium Café appliances, built-in Wi-Fi-enabled wall oven and microwave, five-burner gas range, walk-in pantry, and coffee bar. The first-floor primary suite features a spa-inspired bath with custom vanity, oversized Euro glass shower with floor-to-ceiling designer tile, built-in shower niche, premium plumbing fixtures, and a generous walk-in closet. The first-floor laundry includes premium Speed Queen washer and dryer. The professionally finished walkout lower level features 11-foot ceilings, a custom wet bar, beverage refrigerator, golf simulator, bonus room, electric fireplace, custom built-ins, and access to the outdoor living space. Outside, a Trex deck overlooks a peaceful natural backdrop with aggregate concrete, limestone retaining walls, premium black aluminum fencing, and meticulously maintained landscaping. Other features include an epoxy-coated garage floor, upgraded garage doors, whole-house generator, wide-plank hardwood flooring, designer lighting, and custom finishes throughout. Just steps from the Macomb Orchard Trail with miles of scenic walking and biking paths, and minutes from Stony Creek Metropark, shopping, dining, and expressways. Every detail has been thoughtfully designed to create an exceptional place to call home.

Highlights

Listed by Michelle Messina , 248-229-8909 Oak and Stone Real Estate , 248-266-0584. MiRealSource, Inc. mls logo

Property Type

Residential

Lot/Acreage
0.15

HOA Fee

800 Yearly

Year Built

2022

County

Macomb

Area

Shelby Twp (50007)

Neighborhood

Cedar Cove

School District

Utica Community Schools

Listing ID

61020772

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:3
  • Bathrooms:4
  • Full Bathrooms:3
  • 1/2 Bathrooms:1
Appliances:Dryer, Microwave, Range/Oven, Refrigerator, Washer
Air Cond:Ceiling Fan(s),Central A/C
Fireplaces:Basement Fireplace,Gas Fireplace,Grt Rm Fireplace,Electric Fireplace
Above Ground Sq Ft:2120
Below Ground Sq Ft:2082
Basement:Finished,Walk Out
Other:
  • Additional:Sound System, Wet Bar/Bar
Water:Public Water

Exterior Features

Lot Dimensions:60 X 130
Others:
  • Additional:Deck, Patio
Parking Features:Attached Garage
Principal Interest
$3,518
Taxes
$704
HOA
$800

Home Price

$675,000

Loan Details

30 yrs
6.792%

Down Payment

20%
$135,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$3,517.52

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $3,517.52 $704.08 $800.00 $5,021.60
Yearly $42,210.23 $8,449.00 $9,600.00 $60,259.23
Total $1,266,306.80 $253,470.00 $288,000.00 $1,807,776.80
Lender profile image
So-Crates Johnson
Dust, Wind, Dude
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Sep 2026

Average Price

All Price Ranges
N/A
Sep 2026

Average Days on Market

All Price Ranges
N/A
Sep 2026
Market insight data is pulled from the same city as the listing being viewed (Utica, MI).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.

IDX service by Blueroof 360

Data last updated: 2026-09-02T04:57:55.100Z

© 2026 MiRealSource, Inc.

MLS Logo - MiRealSource, Inc.