$530,915
PENDING $1K PRICE INCREASE

18037 Player Dr Macomb, MI 48042

Estimated payment $3,383/month

Total Views 43,011
4 Beds
2.5 Baths
2,432 Sq Ft
$218 Price per Sq Ft

Highlights

  • New Construction
  • Colonial Architecture
  • Entrance Foyer
  • Beacon Tree Elementary School Rated A-
  • 2 Car Attached Garage
  • Programmable Thermostat

About This Home

PENDING! This home is SOLD, but we can build you one just like it! Build time is approx. 8-10 mths. New Homes in Utica Schools. This Columbia floorplan has an open concept Kitchen, Nook & Great Room that would be perfect to spend time with loved ones. A cozy loft to watch your favorite show or read your favorite book. Unwind in your Master Bedroom w/ beautiful En-Suite. When you’re away from home, take advantage of everything that is nearby. Close to Partridge Creek mall for eating, shopping, and much more! We include 10 Year Structural & Basement Waterproofing Warranties! Photos are of a decorated model or previously built home.

Listing Agent

Anthony Lombardo

Lombardo Realty License #6502107185 Listed on: 03/20/2025

Lombardo Realty

Home Details

Home Type

  • Single Family

Year Built

  • New Construction

Lot Details

  • 8,276 Sq Ft Lot
  • Lot Dimensions are 72x120

HOA Fees

  • $23 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 2,432 Sq Ft Home
  • 2-Story Property
  • Entrance Foyer
  • Unfinished Basement
  • Basement Window Egress
  • Carbon Monoxide Detectors

Kitchen

  • Free-Standing Electric Oven
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Parking

  • 2 Car Attached Garage
  • Front Facing Garage

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Natural Gas Water Heater

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 200805330149

Community Details

Overview

  • Terry Stricker / In Rhodes Association, Phone Number (248) 652-8221

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Year Built

New Construction

Lot Details

0

HOA Fees

$23 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Warranty: Yes
  • Year Built: 2026
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Cats OK, Dogs OK
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Smoke Alarm, Carbon Monoxide Alarm(s), Egress Window(s), Entrance Foyer, Programmable Thermostat
  • Room Count: 14
  • Total Bedrooms: 4
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished
  • Kitchen Appliances: Dishwasher, Free-Standing Electric Oven, Microwave
  • Sq Ft Combined: 2432
  • Total Sq Ft: 2432
  • Sq Ft Total Bsmt: 1017

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl
  • Construction Features: Const. Start Upon Sale, New Construction
  • Foundation Materials: Poured
  • Frontage Feet: 72
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Garage Faces Front
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: 248-652-8221 / terry@inrhodes.com
  • Association Fee: 270
  • Association Contact: Terry Stricker / In Rhodes
  • Association Fee: Yes

Schools

  • School District: Utica

Lot Info

  • Lot Size Area: 0.19
  • Lot Dimensions: 72X120
  • Parcel Number: 200805330149

MLS Schools

  • School District: Utica

Map

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/26/2025 08/26/25 Pending -- -- --
08/26/2025 08/26/25 Price Changed $530,915 -1.0% $218 / Sq Ft
05/20/2025 05/20/25 Price Changed $536,490 +1.3% $221 / Sq Ft
03/20/2025 03/20/25 For Sale $529,490 -- $218 / Sq Ft
Source: Realcomp

Source: Realcomp

MLS Number: 20250018847

Realcomp