Seller's Agent in 2024
Anthony Lombardo
Lombardo Realty
(586) 781-2400
93 in this area
626 Total Sales
57814 Mcqueen Ct South Lyon, MI 48178
Estimated Value: $310,000 - $1,075,000
4
Beds
3.5
Baths
4,578
Sq Ft
$138/Sq Ft
Est. Value
Highlights
- New Construction
- Colonial Architecture
- Stainless Steel Appliances
- Sharon J. Hardy Elementary School Rated A
- Wooded Lot
- 3 Car Direct Access Garage
About This Home
As of March 2024New Crystal Creek South Community located off 11 Mile & Milford Road. Stunning Prairie colonial with 4,578 sf. This 4 bedroom 3 1/2 bath, 3 car side entry with gardenview basement home has beautiful Black Anderson windows. This stunning Sequoia floorplan has been appointed with all high end finishes with a stunning open kitchen- great room concept, butlers pantry, wine room, pocket office, dining room and den. Upstairs you'll be delighted with a 387 sf step up Loft, 4 full bedrooms, 3 full bathrooms including a stunning luxury master bathroom with stand alone tub, 6' tiled shower with bench and separate vanities. Hardwood floors throughout the 1st and 2nd floors. All this and a large laundry room with built-in laundry tub and cabinet. This homesite backs to serene woods in a cul-de-sac and total privacy to enjoy all 4 seasons.
Last Agent to Sell the Property
Lombardo Realty License #6502107185 Listed on: 11/01/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $1,609
Year Built
- Built in 2024 | New Construction
Lot Details
- 0.43 Acre Lot
- Lot Dimensions are 95 x198
- Property fronts a private road
- Level Lot
- Wooded Lot
HOA Fees
- $77 Monthly HOA Fees
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
- Passive Radon Mitigation
Interior Spaces
- 4,578 Sq Ft Home
- 2-Story Property
- Gas Fireplace
- Great Room with Fireplace
Kitchen
- Built-In Electric Oven
- Gas Cooktop
- Range Hood
- Microwave
- Plumbed For Ice Maker
- ENERGY STAR Qualified Dishwasher
- Stainless Steel Appliances
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
Unfinished Basement
- Sump Pump
- Basement Window Egress
Parking
- 3 Car Direct Access Garage
- Garage Door Opener
Location
- Ground Level
Utilities
- Forced Air Heating and Cooling System
- Vented Exhaust Fan
- Heating System Uses Natural Gas
- Programmable Thermostat
- Natural Gas Water Heater
- Cable TV Available
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 2121201018
Community Details
Overview
- 734 973 5500 Association, Phone Number (734) 973-5500
- Crystal Creek South Occpn 2210 Subdivision
Amenities
- Laundry Facilities
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Sep 7, 2023
Sold by
Se Michigan Land Holding Llc
Bought by
Lombardo Homes Of Michigan Llc
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$726,200
Interest Rate
6.96%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 9, 2023
Sold by
Lombardo Homes Of Michigan Llc
Bought by
Abrahim Mohamad and Ibrahim Loumana
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$726,200
Interest Rate
6.96%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 13, 2018
Sold by
Mica Resources Llc
Bought by
S E Michigan Land Holdings Llc
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Lombardo Homes Of Michigan Llc | -- | Greater Macomb Title Agency | |
| Abrahim Mohamad | $175,000 | None Listed On Document | |
| Abrahim Mohamad | $175,000 | None Listed On Document | |
| Abrahim Mohamad | $175,000 | None Listed On Document | |
| S E Michigan Land Holdings Llc | -- | None Available |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Abrahim Mohamad | $726,200 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 03/22/2024 03/22/24 | Sold | $987,215 | 0.0% | $216 / Sq Ft |
| 11/02/2023 11/02/23 | Pending | -- | -- | -- |
| 11/01/2023 11/01/23 | For Sale | $987,216 | -- | $216 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
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 | $1,609 | $40,650 | $0 | $0 |
| 2023 | $200 | $35,650 | $0 | $0 |
| 2022 | $236 | $15,370 | $0 | $0 |
| 2021 | $220 | $15,370 | $0 | $0 |
| 2020 | $183 | $13,100 | $0 | $0 |
| 2019 | $218 | $13,100 | $0 | $0 |
| 2018 | $215 | $13,100 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Anthony Lombardo
-
Jonathan Rivera
Buyer's Agent in 2024
Jonathan Rivera
KW Professionals Brighton
(312) 919-1249
3 in this area
133 Total Sales
Map
Source: Realcomp
MLS Number: 20230093362
APN: 21-21-201-018
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 25592 Crystal Creek W
- The Huntington Plan at Crystal Creek South
- The Berkeley Plan at Crystal Creek South
- The Hampton Plan at Crystal Creek South
- The Fullerton Plan at Crystal Creek South
- The Sequoia Plan at Crystal Creek South
- The Charleston Plan at Crystal Creek South
- The Princeton Plan at Crystal Creek South
- 25000 Carriage Ln
- 58423 Winnowing Cir N
- The Berkeley Plan at Hickory Creek - Artisan Series
- The Fullerton Plan at Hickory Creek
- The Charleston Plan at Hickory Creek
- The Biscayne Plan at Hickory Creek
- The Hampton Plan at Hickory Creek - Artisan Series
- The Huntington Plan at Hickory Creek
- The Princeton Plan at Hickory Creek - Artisan Series
- The Sequoia Plan at Hickory Creek
- 25700 Milford Rd
- 26574 Blackwood Ct Unit 56
- 25589 Crystalcreek W
- 57538 Hidden Timbers Dr
- 57527 Hidden Timbers Dr
- 57550 Hidden Timbers Dr
- 57515 Hidden Timbers Dr
- 25580 Crystal Creek W
- 57562 Hidden Timbers Dr
- 25500 Belladonna
- 25600 Belladonna
- 57491 Hidden Timbers Dr
- 25650 Belladonna
- 57586 Hidden Timbers Dr
- 25876 Crystal Creek Dr W
- 25100 Belladonna
- 57479 Hidden Timbers Dr
- 25571 Crystal Creek W
- 25673 Crystalcreek E
- 57647 Belfield Ct
- 57467 Hidden Timbers Dr
- 25700 Belladonna