NOT LISTED FOR SALE

2045 Squirewood Ct NE Unit 12 Comstock Park, MI 49321

Estimated Value: $435,000 - $690,000

4 Beds
3.5 Baths
2,900 Sq Ft
$198/Sq Ft Est. Value

Last Sold June 15, 2015

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

Est. 101% increase in value since last sale

Current estimated payment $3,509/month

51 Days on Market

Highlights

  • Above Ground Pool
  • Deck
  • Wood Flooring
  • Belmont Elementary School Rated A-
  • Wooded Lot
  • Cul-De-Sac

About This Home

As of June 2015

Wonderful walkout ranch on a one acre cul-de-sac lot in award winning Rockford schools. This former parade home has 4 bedrooms, 3 1/2 baths. The open floor plan is perfect for entertaining and large family gatherings. Kitchen with snack bar to dining area; great room with fireplace; master with private bath; 2 additional bedrooms; full bath; powder room; mud room and laundry on the main level. Walkout lower level features 4th bedroom; full bath; a huge rec room with wet bar. The private yard is park like. You will totally enjoy the heated pool with slide (new liner in 2013) and wrap around deck. Whole house and exterior sound system. The attached garage is 2 1/2 stalls and there is a detached 24 x 24 garage with 220 electrical service and hot/cold water. Easy access to shopping and 131.

Last Listed By

Laura Featherston

Greenridge Realty (Summit) License #6506046903 Listed on: 03/18/2015

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,700

Year Built

  • Built in 2001

Lot Details

  • 1.06 Acre Lot
  • Lot Dimensions are 84x197x200x252
  • Property fronts a private road
  • Cul-De-Sac
  • Shrub
  • Sprinkler System
  • Wooded Lot

HOA Fees

  • $18 Monthly HOA Fees

Parking

  • 4 Car Garage
  • Garage Door Opener

Home Design

  • Composition Roof
  • Vinyl Siding

Interior Spaces

  • 2,900 Sq Ft Home
  • 1-Story Property
  • Ceiling Fan
  • Gas Log Fireplace
  • Low Emissivity Windows
  • Window Treatments
  • Family Room with Fireplace
  • Wood Flooring
  • Walk-Out Basement

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms | 3 Main Level Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Outdoor Features

  • Above Ground Pool
  • Deck

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Well
  • Natural Gas Water Heater
  • Septic System
  • Cable TV Available

Community Details

  • Association fees include snow removal

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,700

Year Built

Built in 2001

Lot Details

0

HOA Fees

$18 per month

Parking

4

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • Stories: 1
  • Year Built: 2001
  • ResoPropertyType: Residential
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Appliances Microwave: Yes
  • Architectural Style:Ranch: Yes
  • Special Features Pool - above ground: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer
  • Flooring: Wood
  • Interior Amenities: Ceiling Fan(s), Garage Door Opener, Humidifier, Pantry
  • Fireplace Features: Family Room, Gas Log
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 4
  • Main Level Bedrooms: 3
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Basement: Walk-Out Access
  • LivingArea: 2900.0
  • Window Features: Low-Emissivity Windows, Window Treatments
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Gas Log: Yes
  • Appliances Dishwasher: Yes
  • Fireplace:Family: Yes

Exterior Features

  • Construction Materials: Vinyl Siding
  • List Price: 299900.0
  • Lot Features: Wooded, Cul-De-Sac
  • Patio and Porch Features: Deck
  • Pool Features: Above Ground, Outdoor/Above
  • Road Frontage Type: Private Road
  • Road Surface Type: Paved
  • Roof: Composition
  • Waterfront: No
  • Access Feat:Accessibility Features2: No
  • Driveway Paved: Yes

Garage/Parking

  • Garage Spaces: 4.0
  • Garage: Yes
  • Additional Items:Garage Door Opener: Yes
  • General Property Info:Garage Spaces: 4.0

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air
  • Heating: Yes
  • Sewer: Septic Tank
  • Utilities: Cable Available, Natural Gas Connected
  • Water Source: Well
  • Water Well: Yes

Condo/Co-op/Association

  • Association Fee: 220.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Info:Approx Assoc Fee2: 220.0
  • Association Info:Assoc Fee Payable: Annually

Fee Information

  • Association Fee Includes: Snow Removal

Lot Info

  • Lot Size Acres: 1.06
  • Lot Size Area: 1.06
  • Lot Dimensions: 84x197x200x252
  • Lot Size Sq Ft: 46173.0
  • Zoning Description: Res
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 3700.0
  • Tax Year: 2014

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 18, 2015
Closed on
Jun 15, 2015
Sold by
Claerhout Scott and Claerhout Cathryn
Bought by
Ruser Rachel and Ruser Brenden
Seller's Agent
Laura Featherston
Greenridge Realty (Summit)
Buyer's Agent
Wayne Thompson
RE/MAX River Valley
List Price
$299,900
Sold Price
$285,000
Premium/Discount to List
-$14,900
-4.97%
Total Days on Market
51
Current Estimated Value
$573,635

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$288,635
Avg. Annual Appreciation
6.75%
Original Mortgage
$228,000
Interest Rate
0.78%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 1, 2007
Sold by
Fisher H Dennis and Fisher Janet
Bought by
Claerhout Scott and Claerhout Cathryn

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 15, 2004
Sold by
Michael E Raisch Trust
Bought by
Fisher H Dennis and Fisher Janet

Home Financials for this Owner

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

Purchase Details

Closed on
May 5, 2003
Sold by
Raisch Michael E and Raisch Rosemary G
Bought by
Michael E Raisch Trust and Rosemary G Raisch Trust

Purchase Details

Closed on
Dec 18, 2000
Bought by
Raisch Michael E and Claerhout Scott

Purchase Details

Closed on
Jun 15, 1999
Bought by
Mk Development Llc and Claerhout Scott

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

Similar Homes in Comstock Park, MI

  • 1475 10 Mile Rd NE, Comstock Park, MI 49321

    $540,000

    • 3 Beds
    • 3.5 Baths
    • 3,039 Sq Ft
    • 1475 10 Mile Rd NE
    • Comstock Park, MI

    This home has all that you have been looking for. Set off of 10 mile, this 5 acre parcel has 3 bedrooms (and with an egress added could be 4) and 3 full baths and 1 half bath. The laundry has an entrance off the garage. The garage is 2+ stalls. The kitchen has been updated and has stainless steel appliances and quartz countertops. There is also an indoor grill that is hooked up to natural gas so

    Danna Dykema Keller Williams GR North

    Section Image
  • 230 9 Mile Rd NW, Comstock Park, MI 49321

    $599,000

    • 3 Beds
    • 3 Baths
    • 1,566 Sq Ft
    • 230 9 Mile Rd NW
    • Comstock Park, MI

    Build your dream home and barn on a great 2.5 acre parcel in Sparta schools! The photos are of a previously built home...we can build one just like it with your perfect selections. OR if you want something bigger, basement finished, completely different we can build it. Use our plans or design a custom home. Current pricing includes quartz counters, tile backsplash, LVP flooring 3 stall

    Sara Suidinski Suburban Realty Group LLC

    Section Image
  • 5394 Riverlook Dr NE, Comstock Park, MI 49321

    $464,900

    • 4 Beds
    • 3.5 Baths
    • 3,031 Sq Ft
    • 5394 Riverlook Dr NE
    • Comstock Park, MI

    Tucked at the end of a quiet cul-de-sac, this beautifully updated home offers the best of both worlds: a true neighborhood setting AND a peaceful, wooded 1.5-acre lot with a creek! From the front, you're part of a friendly community - Out back, you're surrounded by nature, with room to entertain, play, & explore. Inside, enjoy a beautiful, spacious kitchen with a large island, new flooring,

    Brooke Krebill Five Star Real Estate (Grandv)

    Section Image
  • 550 Melissa Ct NE, Comstock Park, MI 49321

    $529,900

    • 5 Beds
    • 3.5 Baths
    • 3,220 Sq Ft
    • 550 Melissa Ct NE
    • Comstock Park, MI

    Large 2 story walkout on a quiet cul-de-sac yet close to downtown, LMCU Ballpark and freeway access. 4+ bdrm 3 1/2 bath, Rockford/Comstock Park school of choice, 2 stall garage w/220, .79acre, Gazebo (water/electric) w/fire pit, 14x16 shed, playhouse, 2 story entry , Living room w/FP Kitchen w/ dining area, solid surface counter tops and tile throughout, stainless steel appliances, 3 season porch

    John Schlundt-Bodien Greenridge Realty (Summit)

    Section Image

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
Ruser Rachel $285,000 None Available
Claerhout Scott $290,000 Chicago Title
Fisher H Dennis $287,800 Metropolitan Title Company
Michael E Raisch Trust -- Metropolitan Title Co
Raisch Michael E -- Metropolitan Title Co
Raisch Michael E $42,000 --
Mk Development Llc -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ruser Rachel $250,000
Closed Ruser Rachel $228,000
Previous Owner Claerhout Scott $220,000
Previous Owner Claerhout Scott $232,000
Previous Owner Claerhout Scott $58,000
Previous Owner Fisher H Dennis $287,800
Previous Owner Raisch Michael Edward $120,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/15/2015 06/15/15 Sold $285,000 -5.0% $98 / Sq Ft
05/08/2015 05/08/15 Pending -- -- --
03/18/2015 03/18/15 For Sale $299,900 -- $103 / Sq Ft
Source: Southwestern Michigan 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,716 $215,400 $0 $0
2023 $3,555 $213,500 $0 $0
2022 $5,210 $176,000 $0 $0
2021 $5,073 $152,600 $0 $0
2020 $3,468 $175,600 $0 $0
2019 $5,292 $180,200 $0 $0
2018 $5,292 $152,800 $0 $0
2017 $5,154 $148,300 $0 $0
2016 $4,982 $135,600 $0 $0
2015 $4,056 $135,600 $0 $0
2013 -- $120,300 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 15011188

Southwestern Michigan Association of REALTORS®

APN: 41-10-04-127-012