NOT LISTED FOR SALE

5905 Coleman Rd Unit 40 East Lansing, MI 48823

Estimated Value: $395,360 - $504,000

3 Beds
2.5 Baths
2,024 Sq Ft
$212/Sq Ft Est. Value

Last Sold April 25, 2024

Last sale price $396,000 $196 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $2,728/month

3 Days on Market

Highlights

  • Humidifier
  • Living Room
  • Forced Air Heating and Cooling System
  • Haslett High School Rated A-
  • Laundry Room
  • Dining Room

About This Home

As of April 2024

**We are in receipt of an offer and calling for highest and best by Wednesday, 4/3/24 9pm.** Beautiful 3 bedroom 2 1/2 bath home. Formal living room features 2 story cathedral ceiling that flows into the family room with gas fireplace. The dining and kitchen have gleaming hardwood floors, desirable pantry, and slider to deck and back yard. The spacious laundry room off the kitchen with cabinets and wash tub round out the first floor. The open staircase to the second floor leads you to a primary suite with large walk-in closet and bath with double sinks, soaking tub and separate shower. Bedroom 2 and 3 are a Jack and Jill with a shared full bath between them. The unfinished lower level with egress window has tons of potential for additional living space.

Last Agent to Sell the Property

Kim Lundberg

Keller Williams Realty Lansing License #6506040813 Listed on: 04/01/2024

Keller Williams Realty Lansing

Last Buyer's Agent

Tara Fatteh

1 World Realty, LLC License #6502341528

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,335

Year Built

  • Built in 2003

Lot Details

  • 6,534 Sq Ft Lot
  • Lot Dimensions are 58 x 110

HOA Fees

  • $16 Monthly HOA Fees

Parking

  • 2 Car Garage

Home Design

  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • 2,024 Sq Ft Home
  • 2-Story Property
  • Gas Fireplace
  • Family Room
  • Living Room
  • Dining Room

Kitchen

  • Free-Standing Gas Oven
  • Free-Standing Gas Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry Room
  • Laundry on main level
  • Washer and Dryer

Basement

  • Basement Fills Entire Space Under The House
  • Natural lighting in basement

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Gas Water Heater

Community Details

  • Chateau In The Pines Ii Association
  • Chateau Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,335

Year Built

Built in 2003

Lot Details

0

HOA Fees

$16 per month

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Bedroom 2 Level: Second
  • Dining Room Level: First
  • Living Room Level: First
  • Current Use: Primary
  • Tax Year: 2024
  • Levels: Two
  • Parking Features Garage Spaces: 2.0
  • Year Built: 2003
  • Fireplaces: 1
  • Lot Size Acres: 0.15
  • Lot Size: 58 x 110
  • Subdivision Name: Chateau
  • Above Grade Finished Sq Ft: 2024.0
  • Living Area: 2024.0
  • General Property Info:Lot Size Dimensions: 58 x 110
  • General Property Info:Above Grade Finished Area: 2024.0
  • General Property Info:Total Livable Area: 2024.0
  • Baths:_pound_Full Baths 2: 2
  • Baths:_pound_Half Baths 1: 1
  • Rooms:Dining Room2: Yes
  • Rooms:Living Room2: Yes
  • Primary Bedroom Level: Second
  • Laundry Features:Main Level: Yes
  • Levels:Two2: Yes
  • Location Legal Info:Real Estate Owned: No
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Rooms:Family Room2: Yes
  • Sewer:Public Sewer: Yes
  • Cooling:Central Air: Yes
  • Exterior:Vinyl Siding: Yes
  • Exterior:Brick: Yes
  • Rooms:Laundry2: Yes
  • Electric:_two_00 Amp Service: Yes
  • Tax Info:Zoning3: Residential
  • General Property Info:Building Area Total SqFt: 3234.0
  • Fireplace Features:Gas5: Yes
  • Special Features: None

Interior Features

  • Basement: Daylight, Full
  • Heating: Forced Air, Natural Gas
  • Total Bedrooms: 3
  • Room: 7
  • Property Type: Residential
  • Bedroom 3 Level: Second
  • Family Room Level: First
  • Laundry Level: First
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Appliances:Gas Water Heater: Yes
  • Full Basement: Yes
  • Basement:Daylight: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Humidifier: Yes
  • Appliances:WasherDryer: Yes
  • Appliances:Free-Standing Gas Oven: Yes
  • Appliances:Free-Standing Gas Range: Yes

Exterior Features

  • Home Warranty: No
  • Construction Type: Brick, Vinyl Siding

Garage/Parking

  • Parking Features: Garage
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Parking Features:Garage2: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Free-Standing Gas Oven, Gas Water Heater, Microwave, Washer/Dryer, Refrigerator, Humidifier, Free-Standing Gas Range, Dishwasher
  • Cooling: Central Air
  • Electric: 200+ Amp Service
  • LaundryFeatures: Main Level
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association Fee: 190.0
  • Association Fee Frequency: Annually
  • Association Name: Chateau in the Pines II
  • Association: Yes

Association/Amenities

  • Location Legal Info:Association Fee: 190.0
  • Location Legal Info:Association Name: Chateau in the Pines II
  • Location Legal Info:Association Fee Frequency: Annually

Schools

  • Junior High Dist: Haslett

Lot Info

  • Lot Size Sq Ft: 6534.0
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Carrier Route: 9218
  • Tax Annual Amount: 5335.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 1, 2024
Closed on
Apr 25, 2024
Sold by
Sheffer Revocable Trust
Bought by
Singh Satyendra Kumar and Sharma Swati
Seller's Agent
Kim Lundberg
Keller Williams Realty Lansing
Buyer's Agent
Tara Fatteh
1 World Realty, LLC
List Price
$389,900
Sold Price
$396,000
Premium/Discount to List
$6,100
1.56%
Total Days on Market
3
Views
86
Current Estimated Value
$430,090

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$34,090
Avg. Annual Appreciation
7.65%
Original Mortgage
$356,400
Outstanding Balance
$353,007
Interest Rate
6.87%
Mortgage Type
New Conventional
Estimated Equity
$77,083

Purchase Details

Closed on
Jan 14, 2015
Sold by
Sheffer William G and Sheffer Patricia F
Bought by
Sheffer Revocable Trust

Purchase Details

Closed on
Apr 6, 2004
Sold by
Sheffer William G and Sheffer Patricia F
Bought by
Sheffer William G and Sheffer Patricia F

Purchase Details

Closed on
Oct 10, 2003
Sold by
Doll Rodrigo A
Bought by
Sheffer William G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$232,110
Interest Rate
4.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jul 14, 2003
Sold by
Sean Mccardel Construction Co Inc
Bought by
Doll Rodrigo A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$222,600
Interest Rate
3.75%
Mortgage Type
Construction

Purchase Details

Closed on
Jan 15, 2003
Sold by
George F Eyde Ltd Family Partnership
Bought by
Sean Mccardel Construction Co Inc
Source: Public Records

Similar Homes in East Lansing, MI

  • 16740 Printemp Dr Unit 10, East Lansing, MI 48823

    $414,000

    • 4 Beds
    • 3.5 Baths
    • 2,475 Sq Ft
    • 16740 Printemp Dr
    • Unit 10
    • East Lansing, MI

    Dream. Buy... and Live Here! 16740 E. Printemp, a 4-bedroom, 3.5 bath home, is your private sanctuary, where you can take in the beauty of the forest, trees, and seasonal pond from your home! Just picture it. You walk inside and are met with an expansive foyer and great voluminous room with a fireplace and sliding door to a large deck overlooking the amazing outdoors! The foyer offers a generous

    Lisa Fletcher Berkshire Hathaway HomeServices

    Section Image
  • 502 Gainsborough Dr, East Lansing, MI 48823

    $344,900

    • 4 Beds
    • 2 Baths
    • 1,920 Sq Ft
    • 502 Gainsborough Dr
    • East Lansing, MI

    Welcome to 502 Gainsborough Drive, an updated four-bedroom home located in the heart of East Lansing. This beautifully maintained property features a modern kitchen with newer appliances, countertops, flooring, cabinets, and a stylish tile backsplash. New blinds and carpeting throughout the home provide a fresh, inviting feel, while hardwired smoke detectors offer added safety. The cozy living

    Morgan Meredith Keller Williams Realty Lansing

    Section Image
  • 5195 E Brookfield Dr, East Lansing, MI 48823

    $399,900

    • 5 Beds
    • 4.5 Baths
    • 3,074 Sq Ft
    • 5195 E Brookfield Dr
    • East Lansing, MI

    Welcome to 5195 E Brookfield Drive in East Lansing, an extensively updated ranch home located in the award-winning Okemos School District and Meridian Township, with the added benefit of an East Lansing address and no city income tax! This spacious property features 5 bedrooms, 3 living rooms, 2 kitchens, and a fully finished basement, ideal for multi-generational living, rental income, or extra

    Morgan Meredith Keller Williams Realty Lansing

    Section Image
  • 5879 Chartres Way Unit 61, East Lansing, MI 48823

    $424,900

    • 4 Beds
    • 3.5 Baths
    • 2,756 Sq Ft
    • 5879 Chartres Way
    • Unit 61
    • East Lansing, MI

    Beautiful 4-Bedroom Home in Haslett Schools!This stunning 4 bedroom, 3.5 bath home offers an open floor plan perfect for modern living. Enjoy the convenience of a first-floor master suite and first-floor laundry. The spacious living area features cathedral ceilings, adding a bright and airy feel throughout. The finished lower level provides additional living space, perfect for entertaining or

    Jeffrey Thornton Coldwell Banker Professionals -Okemos

    Section Image
  • 5859 Printemp Dr Unit 9, East Lansing, MI 48823

    $369,000

    • 3 Beds
    • 2.5 Baths
    • 1,986 Sq Ft
    • 5859 Printemp Dr
    • Unit 9
    • East Lansing, MI

    Step inside to a spacious two-story foyer adorned with a hanging chandelier. To your left is the living room, which boasts a vaulted ceiling and a cozy gas fireplace with a ceramic tile surround and classic mantle. This space flows effortlessly into dining room, highlighted by its own chandelier and direct access to the kitchen.The kitchen is spacious and functional, featuring hardwood floors,

    Nicole Bristol Five Star Real Estate - Lansing

    Section Image
  • 15404 Park Lake Rd, East Lansing, MI 48823

    $349,000

    • 2 Beds
    • 2.5 Baths
    • 1,728 Sq Ft
    • 15404 Park Lake Rd
    • East Lansing, MI

    Experience lakeside living in this stunning custom-built home, perfectly positioned on Park Lake with 40 feet of pristine frontage. With 1,728 sq ft of thoughtfully designed living space and a new roof, this home is move-in ready. Enjoy breathtaking views through the floor-to-ceiling windows that bathe the living spaces in natural light. The interior features beautiful wood vaulted ceilings,

    Jonathan Minerick HomeCoin.com

    Section Image
  • 6108 Skyline Dr, East Lansing, MI 48823

    $525,000

    • 4 Beds
    • 2.5 Baths
    • 3,388 Sq Ft
    • 6108 Skyline Dr
    • East Lansing, MI

    *** Welcome to 6108 Skyline Drive *** A meticulously maintained home set in one of East Lansing's most serene and private settings. Nestled on what was once the renowned Walnut Hills Golf Course, this residence offers sweeping views of green grounds that stretch as far as the eye can see. The backyard feels like a private oasis. Inside, high-end finishes and thoughtful updates are found

    Ben Magsig EXP Realty - Haslett

    Section Image
  • 2924 Colony Dr, East Lansing, MI 48823

    $419,900

    • 4 Beds
    • 2.5 Baths
    • 2,509 Sq Ft
    • 2924 Colony Dr
    • East Lansing, MI

    Beautifully Maintained 4-Bedroom Home Near Donley Elementary. This spacious, well-cared-for 4-bedroom, 2.5-bathroom home offers a comfortable and functional layout in a desirable location. The kitchen features solid surface countertops, a central island, and a sliding glass door that opens to a beautifully landscaped backyard—perfect for entertaining or relaxing. The main floor includes a

    Kim Lundberg Keller Williams Realty Lansing

    Section Image
  • 2895 Colony Dr, East Lansing, MI 48823

    $427,500

    • 5 Beds
    • 2.5 Baths
    • 3,327 Sq Ft
    • 2895 Colony Dr
    • East Lansing, MI

    Here is your opportunity to live in a one of a kind, well-maintained 5 bedroom 2.5-bath two-story home nestled in the desirable Heritage Hills neighborhood. and located across the street from the path to the neighborhood elementary school. This home has so much to offer on the inside as well. You will love the space and flexibility this traditional layout offers. The first floor's open floor

    Elizabeth Russell Berkshire Hathaway HomeServices

    Section Image

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

Purchase History

Date Buyer Sale Price Title Company
Singh Satyendra Kumar $396,000 Ata National Title Group
Sheffer Revocable Trust -- None Available
Sheffer William G -- --
Sheffer William G $46,500 --
Doll Rodrigo A $46,500 Professional Title & Mtg Svc
Sean Mccardel Construction Co Inc $600,000 Fatic
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Singh Satyendra Kumar $356,400
Previous Owner Sheffer William G $232,110
Previous Owner Doll Rodrigo A $222,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/25/2024 04/25/24 Sold $396,000 +1.6% $196 / Sq Ft
04/05/2024 04/05/24 Pending -- -- --
04/01/2024 04/01/24 For Sale $389,900 -- $193 / Sq Ft
Source: Greater Lansing Association of Realtors®

Tax History Compared to Growth

Source: Public Records

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
2024 $3,677 $194,400 $19,000 $175,400
2023 $3,494 $179,600 $0 $0
2022 $5,067 $162,900 $18,000 $144,900
2021 $4,924 $151,200 $18,000 $133,200
2020 $4,797 $149,800 $17,700 $132,100
2019 $4,592 $144,200 $17,700 $126,500
2018 $4,452 $119,700 $17,700 $102,000
2017 $4,331 $120,300 $17,700 $102,600
2016 $4,306 $120,900 $18,800 $102,100
2015 -- $121,000 $0 $0
2011 -- $114,200 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 279355

Greater Lansing Association of Realtors®

APN: 010-146-000-040-00