RENTED JAN 29, 2026

51174 Johns Dr Chesterfield, MI 48047

Estimated Value: $90,000 - $103,000

1 Bed
1 Bath
682 Sq Ft
2,047 Sq Ft Lot Lot

Sale Details

Date Sold: October 3, 2023

Last sale price $67,000 $98 Per Sq Ft

Est. 42% increase in value since last sale

Current estimated payment $580 / mo

Highlights

  • Ranch Style House
  • Patio
  • Vinyl Flooring
  • Great Oaks Elementary School Rated A-
  • Forced Air Heating and Cooling System

About This Home

As of January 2026

Gorgeous 1-bedroom lower-level condo, furnished, and completely redone. New luxury vinyl flooring throughout. Remolded Kitchen with granite countertop along with white shaker, soft close cabinets. Tile back splash and large pantry cabinet. Eating areas with door wall that leads to back patio area. Bathroom with new vanity. Large bedroom with ceiling fan. Storage closet within the unit. Laundry facility steps away in the hallway. Absolutely no pets allowed. Seller pays HOA dues. All furniture in the unit stays for the lease.

Last Agent to Rent the Property

Jennifer and Joe Caira-Lauff

Real Estate One Chesterfield License #MISPE-6501305098 Listed on: 10/10/2025

Real Estate One Chesterfield

Co-Listed By

Joe Lauff

Real Estate One Chesterfield License #MISPE-6501392218

Last Renter's Agent

Jennifer and Joe Caira-Lauff

Real Estate One Chesterfield License #MISPE-6501305098 Listed on: 10/10/2025

Real Estate One Chesterfield

Condo Details

Home Type

  • Condominium

Year Built

  • Built in 1980

Lot Details

  • 2,047

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Slab Foundation

Interior Spaces

  • 682 Sq Ft Home
  • Vinyl Flooring

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 1 Bedroom
  • 1 Full Bathroom

Outdoor Features

  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • Association fees include ground maintenance, snow removal, trash removal, water
  • Salt River East Subdivision

Listing and Financial Details

  • Rent includes water
  • Assessor Parcel Number 15-09-14-352-025

Condo Details

Home Type

Condominium

Year Built

Built in 1980

Lot Details

2,047 Sq Ft Lot

Rental Info

  • Lease: Yes
  • Lease Incl: Water
  • LeaseInfo: Lease Required, No Pets Allowed, Security Deposit

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Condominium
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Total Tax Year: 2024
  • Year Built: 1980
  • Mail City: New Baltimore
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator
  • Bedrooms: 1
  • Bedroom 1: On 1st Floor, Dimensions: 10 x 12
  • Bedroom 1 Floor Covering: Vinyl
  • Full Bathrooms: 1
  • Total Bathrooms: 1
  • Bathroom 1: Dimensions: 9 x 9, On Level: First
  • Dining Room: On 1st Floor, Dimensions: 10 x 10
  • Kitchen: On 1st Floor, Dimensions: 10 x 9
  • Kitchen Floor Covering: Vinyl
  • Living Room: On 1st Floor, Dimensions: 15 x 17
  • Above Grade Finished Sq Ft: 682
  • Total Finished Sq Ft: 682

Exterior Features

  • Exterior: Brick
  • Exterior Features: Patio
  • Foundation: Slab

Garage/Parking

  • Garage: No

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Snow Removal, Trash Removal, Water

Lot Info

  • Assessor Parcel Number: 15-09-14-352-025
  • Zoning: Residential
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2024
  • Winter Tax: Year: 2024
  • Total Tax: Year: 2024

MLS Schools

  • School District: Anchor Bay School District

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 21, 2025
Sold by
Geck Tina
Bought by
Geck Revocable Living Trust and Geck
Current Estimated Value
$94,854

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$76,000
Outstanding Balance
$75,732
Interest Rate
5.71%
Mortgage Type
New Conventional
Estimated Equity
$19,122

Purchase Details

Closed on
Sep 11, 2025
Sold by
L & J Contractors Home Repair Llc
Bought by
Geck Tina

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$76,000
Outstanding Balance
$75,732
Interest Rate
5.71%
Mortgage Type
New Conventional
Estimated Equity
$19,122

Purchase Details

Listed on
Aug 19, 2023
Closed on
Oct 2, 2023
Sold by
Pino Susan K
Bought by
L & J Contractors Home Repair Llc
Seller's Agent
Thomas Ledbetter
USA Home Broker
Buyer's Agent
Nicole Jones
Utica Realty LLC
List Price
$85,000
Sold Price
$67,000
Premium/Discount to List
-$18,000
-21.18%
Views
141

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.37%

Purchase Details

Closed on
Jan 5, 2012
Sold by
Pino Joseph and Pino Susan K
Bought by
Pino Joseph and Pino Susan K
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Buyer Sale Price Title Company
Geck Revocable Living Trust -- None Listed On Document
Geck Tina $95,000 None Listed On Document
L & J Contractors Home Repair Llc $67,000 Greater Macomb Title Agency
Pino Joseph -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Geck Tina $76,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/29/2026 01/29/26 Rented $1,100 -7.6% --
01/28/2026 01/28/26 Under Contract -- -- --
11/24/2025 11/24/25 Price Changed $1,190 -7.8% $2 / Sq Ft
10/10/2025 10/10/25 For Rent $1,290 0.0% --
10/03/2023 10/03/23 Sold $67,000 -16.3% $98 / Sq Ft View Prior Sale
09/12/2023 09/12/23 Pending -- -- --
09/01/2023 09/01/23 Price Changed $80,000 -5.9% $117 / Sq Ft
08/19/2023 08/19/23 For Sale $85,000 -- $125 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $928 $31,200 $0 $0
2024 $646 $29,600 $0 $0
2023 $355 $25,100 $0 $0
2022 $614 $22,000 $0 $0
2021 $596 $20,000 $0 $0
2020 $325 $19,900 $0 $0
2019 $534 $19,900 $0 $0
2018 $543 $17,000 $2,500 $14,500
2017 $537 $14,400 $2,500 $11,900
2016 $534 $14,400 $0 $0
2015 $254 $13,050 $0 $0
2014 $254 $10,050 $2,500 $7,550
2012 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50191137

Michigan Multiple Listing Service

APN: 15-09-14-352-025

Your Personal Tour Guide

Ask me questions while you tour the home.