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

Jenn Smart

| SEO pages, v2 chat

Agent profile image in message

14257 Mandarin , Shelby Twp, MI 48315
$599,900
Est. Payment: $3,126.16/mo
3 Bed
3 Bath
2972 Sqft
Status: active with contingency | Days on site: 49
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

Welcome to your dream home! Situated on a corner lot, this 3 Bed/2.1 Bath Split-Level offers nearly 3,000 SF of thoughtfully designed living space and stunning curb appeal! Impressive upgrades flow seamlessly throughout this home offering a modern touch from the moment you step in. The entry level features an enclosed study and formal dining room, both featuring hardwood flooring, custom wood trim accent walls and modern fixtures. Vaulted ceilings, sky lights and floor to ceiling windows offer tons of natural light to your spacious living room in addition to a towering double sided gas fireplace with modern upgrades and hardwood floors. The master bedroom is also conveniently located on the entry level and features separate his/her walk-in closets and a large master ensuite. The kitchen underwent a complete transformation in 2023 that is sure to impress with top-of-the-line finishes including custom cabinetry, a massive island, quartz countertops, new appliances, contemporary fixtures and a walk-in pantry. A separate dining nook surrounded by windows and the dual fireplace makes this space extra cozy & the perfect gathering place! A beautifully updated laundry/mudroom and half bath complete the entry level. Make your way to the second level where you'll find a spacious loft that can be easily converted to a 4th bedroom! The hardwood floors carry through to a full bath and two more generous size bedrooms featuring walk-in closets. The exterior offers a 3-car garage, picturesque landscaping, under-eave lighting, paved walkways and a large brick patio. Award winning UCS and close to shopping, restaurants and entertainment. Don't miss your opportunity to own this beautiful home within a highly desired neighborhood! *HOA allows fencing*

Highlights

Listed by Sarah Monzo , 586-292-1077 and Erick Monzo , 586-808-6436 Keller Williams Realty-Great Lakes , 586-541-4000. MiRealSource, Inc. mls logo

Property Type

Residential

Lot/Acreage
0.3

HOA Fee

395 Yearly

Year Built

2001

County

Macomb

Area

Shelby Twp (50007)

Neighborhood

Raven's Pointe Ii Condo #679

School District

Utica Community Schools

Listing ID

61009473

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:3
  • Bathrooms:3
  • Full Bathrooms:2
  • 1/2 Bathrooms:1
Appliances:Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
Air Cond:Ceiling Fan(s),Central A/C
Fireplaces:Gas Fireplace
Above Ground Sq Ft:2972
Basement:Unfinished
Water:Public Water

Exterior Features

Lot Dimensions:102x130
Others:
  • Additional:Patio
Parking Features:Attached Garage
Principal Interest
$3,126
Taxes
$567
HOA
$395

Home Price

$599,900

Loan Details

30 yrs
6.792%

Down Payment

20%
$119,980
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,126.16

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $3,126.16 $567.08 $395.00 $4,088.25
Yearly $37,513.95 $6,805.00 $4,740.00 $49,058.95
Total $1,125,418.44 $204,150.00 $142,200.00 $1,471,768.44
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 (Shelby Twp, 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-02T03:11:55.100Z

© 2026 MiRealSource, Inc.

MLS Logo - MiRealSource, Inc.