NOT LISTED FOR SALE

4074 Squire Hill Dr Unit 32 Flushing, MI 48433

Estimated Value: $224,677 - $240,000

2 Beds
3 Baths
1,168 Sq Ft
$250/mo HOA Fee

Last Sold August 19, 2024

Last sale price $223,500 $191 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $1,571/month

63 Days on Market

Highlights

  • Deck
  • 2 Car Attached Garage
  • Private Entrance
  • Ranch Style House
  • Forced Air Heating and Cooling System
  • Laundry Facilities

About This Home

As of August 2024

Experience luxury living in this beautiful end unit ranch condo nestled in the highly sought-after community of The Glenn's of Squire Lake. Boasting an expansive floor plan, this residence features two spacious bedrooms and three bathrooms, offering ample space for comfortable living. Step into the open-concept living area, adorned with cathedral ceilings and a neutral color scheme. The heart of the home is the fully equipped kitchen with island, allowing for extra prep space for cooking quiet meals or entertaining a crowd. A highlight of this property is the full finished basement, complete with a second kitchen, full bath, and daylight windows that flood the space with natural light. This additional living area provides endless possibilities, whether used as a cozy retreat, a guest suite, or a recreation room. The primary bedroom is a tranquil sanctuary featuring an en suite full bath and a generous walk-in closet, offering both comfort and convenience. Outside, a private deck extends your living space outdoors, providing a charming setting for alfresco dining, relaxation, or hosting BBQs with loved ones

Last Agent to Sell the Property

Marianne Tucker

The Brand Real Estate License #6501437379 Listed on: 05/29/2024

Last Buyer's Agent

Shane Adams

RE/MAX Select License #6501268702

RE/MAX Select

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 1999

Lot Details

  • 2,047

HOA Fees

  • $250 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 1,168 Sq Ft Home
  • Finished Basement
  • Sump Pump

Kitchen

  • Free-Standing Electric Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Utilities

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

Additional Features

  • Deck
  • Private Entrance
  • Ground Level

Listing and Financial Details

  • Assessor Parcel Number 1430676032

Community Details

Overview

  • Cummings Management Association, Phone Number (800) 965-5292
  • The Glenns Of Squire Lake Subdivision
  • On-Site Maintenance

Amenities

  • Laundry Facilities

Pet Policy

  • The building has rules on how big a pet can be within a unit

Property Details

Home Type

Condominium

Est. Annual Taxes

$2,593

Year Built

Built in 1999

Lot Details

0

HOA Fees

$250 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Assessment: 148.00
  • Year Built: 1999
  • State Equalized Value: 73100.0000
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Size Limit
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Interior Amenities: 100 Amp Service
  • Room Count: 11
  • Total Bedrooms: 2
  • Total Bathrooms: 3.00
  • Full Bathrooms: 3
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Free-Standing Electric Range, Free-Standing Refrigerator, Microwave, Washer
  • Sq Ft Combined: 2168
  • Sq Ft Lower Floor: 1000
  • Total Sq Ft: 1168
  • Sq Ft Total Bsmt: 1168

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exterior Features: Grounds Maintenance, Private Entry
  • Foundation Materials: Poured
  • Porch Type: Deck
  • Road Frontage Type: Paved
  • Sideof Street: E

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached
  • 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: Yes

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Maintenance Structure, Maintenance Grounds, Trash
  • Association Fee Frequency: Monthly
  • Phone: 800-965-5292
  • Association Fee: 250
  • Association Contact: Cummings Management
  • Association Fee: Yes

Schools

  • School District: Flushing

Lot Info

  • Homestead: Yes
  • Parcel Number: 1430676032

Tax Info

  • Tax Amount Summer: 1071.0000
  • Tax Amount Winter: 1522.0000
  • Total Tax: 2593.0000
  • Taxable Value: 55813.0000

MLS Schools

  • School District: Flushing

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 31, 2025
Sold by
Harrison Joseph Patrick
Bought by
Joseph P Harrison Living Trust and Harrison
Current Estimated Value
$232,419

Purchase Details

Listed on
May 29, 2024
Closed on
Aug 9, 2024
Sold by
Oglesby Ledora
Bought by
Harrison Joseph
Seller's Agent
Marianne Tucker
The Brand Real Estate
Buyer's Agent
Shane Adams
RE/MAX Select
List Price
$235,000
Sold Price
$223,500
Premium/Discount to List
-$11,500
-4.89%
Views
90

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 23, 2010
Sold by
Franz Martha E
Bought by
Oglesby Ledora

Purchase Details

Closed on
May 7, 2003
Sold by
Hunkin Clarence R and Hunkin Letitia A
Bought by
Hunkin Clarence R and Hunkin Letitia A

Purchase Details

Closed on
Aug 13, 2001
Sold by
Hunkin Letitia A
Bought by
Hunkin Clarence R and Hunkin Letitia A

Purchase Details

Closed on
Dec 14, 2000
Sold by
Squire Lake Hills Llc
Bought by
Hunkin Letitia A
Source: Public Records

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
Joseph P Harrison Living Trust -- None Listed On Document
Harrison Joseph $223,500 None Listed On Document
Oglesby Ledora $105,000 First American Title Ins Co
Hunkin Clarence R -- --
Hunkin Clarence R -- --
Hunkin Letitia A $133,591 Guaranty Title Company
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/19/2024 08/19/24 Sold $223,500 -2.8% $191 / Sq Ft
07/31/2024 07/31/24 Pending -- -- --
07/05/2024 07/05/24 Price Changed $230,000 -2.1% $197 / Sq Ft
05/29/2024 05/29/24 For Sale $235,000 -- $201 / Sq Ft
Source: Realcomp

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 $1,122 $72,600 $0 $0
2023 $1,071 $73,100 $0 $0
2022 $2,423 $66,200 $0 $0
2021 $2,403 $61,000 $0 $0
2020 $996 $56,200 $0 $0
2019 $986 $54,500 $0 $0
2018 $2,251 $58,300 $0 $0
2017 $2,106 $57,900 $0 $0
2016 $2,088 $57,300 $0 $0
2015 $1,950 $56,000 $0 $0
2014 $859 $49,600 $0 $0
2012 -- $50,700 $50,700 $0
Source: Public Records

Agents Affiliated with this Home

  • Marianne Tucker

    Seller's Agent in 2024

    Marianne Tucker

    The Brand Real Estate

    (810) 356-9400

    2 in this area

    176 Total Sales

    Marianne Tucker
    Section Image
  • Shane Adams

    Buyer's Agent in 2024

    Shane Adams

    RE/MAX Michigan

    (810) 577-1700

    11 in this area

    452 Total Sales

    Shane Adams
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20240032620

Realcomp

APN: 14-30-676-032

Michigan Genesee County Flushing 48433

4074 Squire Hill Dr Unit 32, Flushing, MI

This home is located at 4074 Squire Hill Dr Unit 32, Flushing, MI 48433 since 29 May 2024 and is currently estimated at $232,419, approximately $198 per square foot. This property was built in 1999. 4074 Squire Hill Dr Unit 32 is a home located in Genesee County with nearby schools including Springview Elementary School, Flushing Middle School, and Flushing High School.

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.

Realcomp 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