NOT LISTED FOR SALE

49139 Squirewood Ct Unit 207 Macomb Township, MI 48042

2 Beds
2.5 Baths
2,008 Sq Ft
$225/mo HOA Fee

Last Sold February 24, 2020

Last sale price $367,575 $183 Per Sq Ft

1 Day on Market

Highlights

  • New Construction
  • Clubhouse
  • Covered Patio or Porch
  • Outdoor Pool
  • Ranch Style House
  • 2 Car Attached Garage

About This Home

As of February 2020

TO BE BUILT Lombardo Homes proudly presents Featherstone at the Retreat. The Olivia is a 2 bed, 2.5 bath with a den or additional bedroom home that offers, 2,008 sq. ft. All on one floor!! A very open concept that is ideal for entertaining. This home includes: Catherdral Ceiling in Great Room, 3 pc plumbing prep in basement for future bath, arch package ,Granite in kitchen with applainces including: gas range, double oven,microwave, dishwasher. Tray ceiling in master bedroom, 9' ceilings, Gas fireplace. Covered patio off kitchen. Large Master Bathroom with tile shower and private water closet with privacy door. This home is to be built. Please contact to view the furnished model *Pictures are a representation and not of actual home*

Last Agent to Sell the Property

Anthony Lombardo

Lombardo Realty License #6502107185 Listed on: 06/20/2019

Lombardo Realty

Last Buyer's Agent

Anthony Lombardo

Lombardo Realty License #6502107185 Listed on: 06/20/2019

Lombardo Realty

Property Details

Home Type

  • Condominium

Year Built

  • Built in 2019 | New Construction

HOA Fees

  • $225 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Vinyl Construction Material

Interior Spaces

  • 2,008 Sq Ft Home
  • Gas Fireplace
  • Great Room with Fireplace
  • Unfinished Basement
  • Sump Pump

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 2 Bedrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Eco-Friendly Details

  • ENERGY STAR/Reflective Roof

Outdoor Features

  • Outdoor Pool
  • Covered Patio or Porch

Utilities

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

Listing and Financial Details

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

Community Details

Overview

  • On-Site Maintenance

Amenities

  • Clubhouse

Recreation

  • Community Pool

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Year Built

Built in 2019 | New Construction

Lot Details

0

HOA Fees

$225 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Warranty: Yes
  • Year Built: 2019
  • Foundation Features: Sump Pump
  • Pets Allowed: Yes
  • Special Features: NewHome
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room
  • Room Count: 10
  • Total Bedrooms: 2
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Range/Stove
  • Sq Ft Combined: 2008
  • Total Sq Ft: 2008
  • Sq Ft Total Bsmt: 1750

Exterior Features

  • Roof Material: ENERGY STAR® Shingles
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl
  • Construction Features: New Construction
  • Exterior Features: Club House, Grounds Maintenance, Pool – Community
  • Foundation Materials: Poured
  • Porch Type: Porch - Covered
  • Road Frontage Type: Paved, Pub. Sidewalk
  • Sideof Street: W

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Door Opener, Electricity
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee Frequency: Monthly
  • Association Fee: 225
  • Association Fee: Yes

Schools

  • School District: New Haven

Lot Info

  • Parcel Number: 0824351207

MLS Schools

  • School District: New Haven

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 List to Sale Price per Sq Ft
02/24/2020 02/24/20 Sold $367,575 +2.4% $183 / Sq Ft
06/21/2019 06/21/19 Pending -- -- --
06/20/2019 06/20/19 For Sale $358,975 -- $179 / Sq Ft
Source: Realcomp

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 219060320

Realcomp