NOT LISTED FOR SALE

2240 Beechnut Trail Holt, MI 48842

Estimated Value: $386,000 - $447,000

4 Beds
4.5 Baths
3,600 Sq Ft
$117/Sq Ft Est. Value

Last Sold July 14, 2014

Last sale price $255,150 $71 Per Sq Ft

Est. 65% increase in value since last sale

Current estimated payment $2,868/month

19 Days on Market

Highlights

  • Ranch Style House
  • Whirlpool Bathtub
  • Covered Patio or Porch
  • Cathedral Ceiling
  • Great Room
  • 3 Car Attached Garage

About This Home

As of July 2014

Newer Custom built by Keith Caron, 1 owner Ranch home situated at the end of a cul-de-sac within Walking distance to Horizon School! This Well Maintained home offers 3,600 SF with 4 Bedrooms, 4.5 Baths including an In-Law Suite & 1,700 SF finished in the Lower Level. A Large Foyer w/Hardwood Flrs opens into your Great Rm with Cathedral Ceilings & a Gas Fireplace flanked by Windows. Kitchen provides Plenty of White Raised Paneled Cabinets, Counter Space, Gas Stove, Wood floors, Pantry & a large Eat-in Area offering Great Views of the Back Yard through a Bay Window/Slider. A Private In-law Suite with a Full Bath & Walk-in Closet is located off the Kitchen. This Split Floor Plan with a Master Suite includes Dbl Vanities, Walk-in Shower, Deep Jacuzzi Tub & a Walk-in Closet. 2 additional Bdrms share a Full Bath w/ceramic flrs. 1st Flr Laundry offers lots of space, built-in cabinets/laundry sink & is located off the garage entrance. 3 Car Garage is Finished & provides Plenty of Storage & Full Size Garage Dr leading to your back yard. The Lower Level is Amazing! A 50 ft Family Rm lends itself to a Game Area with Built-in Bookcases, TV/Entertaining area as well as a Wet Bar & informal Eating Area & provides lots of Natural Light from Egress Windows. Home Office with a 4th Full Bath is located off the Family Rm The home is decorated in a soothing Costal Decor with White Trim/Cabinets throughout & is Light, Bright & Airy! Spacious Back Yard offers a Putting Green & Stamped Concrete Patio perfect for entertaining family & friends.

Last Agent to Sell the Property

Katie Spyke

Berkshire Hathaway HomeServices Listed on: 05/28/2014

Last Buyer's Agent

Alicia Banks

Good Company Realty License #6506047106

Good Company Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,183

Year Built

  • Built in 2003

Lot Details

  • 0.39 Acre Lot
  • Lot Dimensions are 102 x 165
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • Bar
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Entrance Foyer
  • Great Room
  • Living Room
  • Dining Room
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • In-Law or Guest Suite
  • Whirlpool Bathtub

Outdoor Features

  • Covered Patio or Porch

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Vented Exhaust Fan
  • Gas Water Heater
  • Cable TV Available

Community Details

  • Moorwood Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,183

Year Built

Built in 2003

Lot Details

0

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Dining Room Level: First
  • Living Room Level: First
  • Tax Year: 13
  • Levels: One
  • Parking Features Garage Spaces: 3.0
  • Year Built: 2003
  • Lot Size Acres: 0.39
  • Lot Size: 102 X 165
  • Subdivision Name: Moorwood
  • Above Grade Finished Sq Ft: 1900.0
  • Architectural Style: Ranch
  • Living Area: 3600.0
  • General Property Info:Lot Size Dimensions: 102 X 165
  • General Property Info:Above Grade Finished Area: 1900.0
  • General Property Info:Total Livable Area: 3600.0
  • Baths:_pound_Full Baths 1: 3
  • Baths:_pound_Full Baths B: 1
  • Baths:_pound_Half Baths B: 1
  • Rooms:Dining Room2: Yes
  • Rooms:Living Room2: Yes
  • Primary Bedroom Level: First
  • Laundry Features:Main Level: Yes
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Security Features:Smoke Detector(s): Yes
  • Levels:One: Yes
  • Cooling:Central Air: Yes
  • General Property Info:ECO Friendly Features: No
  • Exterior:Vinyl Siding: Yes
  • Improvements:Great Room: Yes
  • Improvements:Whirlpool Bathtub: Yes
  • Architectural Style:Ranch: Yes
  • Lot Features:Underground Sprinklers: Yes
  • Exterior:Brick: Yes
  • Cooling:Exhaust Fan: Yes
  • General Property Info:Building Area Total SqFt: 3800.0
  • Fireplace Features:Gas5: Yes
  • Special Features: VirtualTour

Interior Features

  • Basement: Full, Partially Finished
  • Heating: Forced Air, Natural Gas
  • Interior Amenities: Bar, Cathedral Ceiling(s), Ceiling Fan(s), Entrance Foyer, In-Law Floorplan, Pantry, Primary Bathroom, Primary Downstairs
  • Total Bedrooms: 4
  • Property Type: Residential
  • Bedroom 3 Level: First
  • Other Level: First
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Below Grade Sq Ft: 1700.0
  • Fireplaces: 1
  • Fireplace: Yes
  • Appliances:Gas Water Heater: Yes
  • Full Basement: Yes
  • Appliances Range: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Oven: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Pantry: Yes
  • Interior Features:Primary Downstairs: Yes
  • Basement:Partially Finished: Yes
  • Appliances:Humidifier: Yes
  • Interior Features:Entrance Foyer: Yes
  • Interior Features:Bar: Yes
  • Interior Features:In-Law Floorplan: Yes

Exterior Features

  • Lot Features: Underground Sprinklers
  • Patio And Porch Features: Covered, Patio, Porch
  • Home Warranty: No
  • Construction Type: Brick, Vinyl Siding
  • Patio Porch Features:Covered: Yes
  • Patio Porch Features:Porch: Yes
  • Patio Porch Features:Patio: Yes

Garage/Parking

  • Parking Features: Attached, Finished, Floor Drain, Garage Door Opener, Heated Garage, Water
  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Floor Drain: Yes
  • Parking Features:Water6: Yes
  • Parking Features:Finished2: Yes
  • Parking Features:Heated Garage: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Gas Water Heater, Microwave, Refrigerator, Range, Oven, Humidifier, Dishwasher
  • Cooling: Central Air, Exhaust Fan
  • LaundryFeatures: Main Level
  • Utilities: Cable Available
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Schools

  • Junior High Dist: Holt/Dimondale

Lot Info

  • Lot Size Sq Ft: 16988.4
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 5183.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 28, 2014
Closed on
Jul 11, 2014
Sold by
Edward Hay And Diane Garrison Trust
Bought by
Zatkin Matthew A
Seller's Agent
Katie Spyke
Berkshire Hathaway HomeServices
Buyer's Agent
Alicia Banks
Good Company Realty
List Price
$259,900
Sold Price
$255,150
Premium/Discount to List
-$4,750
-1.83%
Current Estimated Value
$420,095

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$164,945
Avg. Annual Appreciation
4.44%
Original Mortgage
$255,150
Outstanding Balance
$194,056
Interest Rate
4.12%
Mortgage Type
New Conventional
Estimated Equity
$226,039

Purchase Details

Closed on
Oct 20, 2004
Sold by
Hay Ed and Garrison Diane M
Bought by
Hay Edward L and Garrison Diane M

Purchase Details

Closed on
Oct 30, 2002
Sold by
Moorwood Office Associates Llp
Bought by
Hay Ed and Garrison Diane M
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Zatkin Matthew A $255,150 Tri Title Agency Llc
Hay Edward L -- --
Hay Ed $45,000 Midstate Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Zatkin Matthew A $255,150
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/14/2014 07/14/14 Sold $255,150 -1.8% $71 / Sq Ft
06/16/2014 06/16/14 Pending -- -- --
05/28/2014 05/28/14 For Sale $259,900 -- $72 / 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
2025 $8,082 $205,900 $35,900 $170,000
2024 $20 $198,900 $32,500 $166,400
2023 $7,651 $192,400 $27,300 $165,100
2022 $7,279 $173,200 $22,700 $150,500
2021 $7,088 $165,000 $16,100 $148,900
2020 $7,390 $163,500 $16,100 $147,400
2019 $7,045 $148,500 $18,700 $129,800
2018 $7,001 $131,100 $20,800 $110,300
2017 $6,271 $131,100 $20,800 $110,300
2016 $6,097 $128,000 $17,500 $110,500
2015 $5,318 $120,100 $35,000 $85,100
2014 $5,318 $109,200 $35,000 $74,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 59430

Greater Lansing Association of Realtors®

APN: 25-05-17-406-025