NOT LISTED FOR SALE

Estimated Value: $535,000 - $587,000

5 Beds
3.5 Baths
5,282 Sq Ft
$106/Sq Ft Est. Value

Last Sold August 25, 2020

Last sale price $400,000 $76 Per Sq Ft

Est. 41% increase in value since last sale

Current estimated payment $3,516/month

158 Days on Market

Highlights

  • Traditional Architecture
  • 1 Fireplace
  • 3 Car Attached Garage
  • Hoosier Road Elementary School Rated A
  • Breakfast Room
  • Forced Air Heating and Cooling System

About This Home

As of August 2020

Checkout this remodeled home with a beautiful 2 story entry foyer. NEW Paint inside and outside, NEW Level II granite (named Black Pearl) in Kitchen countertops, EXTRA WIDE kitchen Island, HARDWOOD floors in Kitchen and Dining area, NEW SS Fridge and Newer SS appliances, NEW Carpet throughout house, NEW water heater, professionally cleaned home. Spacious office / den at the main, also bedroom with attached bath (can be used as in-law suite) on main. Beautiful sun room and custom windows throughout for that extra daylight. WIC with each room. Huge loft upstairs. Full sized basement with the house. One of the bigger houses in this much desired Somerset subdivision. Exercise equipment and recreation table (pool / pingpong) stay with house.

Last Agent to Sell the Property

Manzil Kohli

Vylla Home License #RB16001946 Listed on: 02/17/2020

Last Buyer's Agent

Judy Koehler

Carpenter, REALTORS® License #RB14011113

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,676

Year Built

  • Built in 2008

Lot Details

  • 10,454 Sq Ft Lot

Parking

  • 3 Car Attached Garage

Home Design

  • Traditional Architecture
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • 1 Fireplace
  • Breakfast Room
  • Unfinished Basement

Bedrooms and Bathrooms

  • 5 Bedrooms

Utilities

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

Community Details

  • Association fees include clubhouse entrance common insurance maintenance pool snow removal
  • Somerset Subdivision
  • Property managed by Community Management Service

Listing and Financial Details

  • Assessor Parcel Number 291133020021000020

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,676

Year Built

Built in 2008

Lot Details

0

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: TraditonalAmerican
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2013
  • Year Built: 2008
  • Garage Y N: Yes
  • Lot Size Acres: 0.24
  • Subdivision Name: SOMERSET
  • Inspection Warranties: Not Applicable
  • Property Description: Checkout this remodeled home with a beautiful 2 story entry foyer. NEW Paint inside and outside, NEW Level II granite (named Black Pearl) in Kitchen countertops, EXTRA WIDE kitchen Island, HARDWOOD floors in Kitchen and Dining area, NEW SS Fridge and Newer SS appliances, NEW Carpet throughout house, NEW water heater, professionally cleaned home. Spacious office / den at the main, also bedroom with attached bath (can be used as in-law suite) on main. Beautiful sun room and custom windows throughout for that extra daylight. WIC with each room. Huge loft upstairs. Full sized basement with the house. One of the bigger houses in this much desired Somerset subdivision. Exercise equipment and recreation table (pool / pingpong) stay with house.
  • Transaction Type: Sale
  • Open House Count: 0
  • Open House Public Count: 0
  • Special Features: None

Interior Features

  • Basement: Yes
  • Basement Type: Unfinished
  • Appliances: Dishwasher,Disposal,Electric Oven,Refrigerator
  • Levels: Two
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Total Bedrooms: 5
  • Fireplace Features: Gas Starter,Great Room
  • Fireplaces: 1
  • Interior Amenities: Attic Access,Ceiling Raised,Ceiling Tray,Ceiling Vaulted,Walk-in Closet(s)
  • Living Area: 5282
  • Other Equipment: Security Alarm Paid,Smoke Detector,Sump Pump,Water-Softener Owned
  • Room Count: 13
  • Areas Interior: In-Law Quarters,Laundry Room Upstairs
  • Eating Area: Breakfast Room
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 1
  • Sq Ft Main Upper: 3438
  • Main Level Sq Ft: 1844
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Master Bedroom Description: Closet Walk in,Sinks Double,Sitting Room,Tub Full with Separate Shower,Tub Garden
  • Total Sq Ft: 5282
  • Kitchen Features: Center Island,Pantry
  • Below Grade Sq Ft: 1844
  • Upper Level Sq Ft: 1594
  • Pct Optional Level Finished: 0-25%

Exterior Features

  • Construction Materials: Brick,Vinyl Siding
  • Disclosures: Not Applicable
  • Exterior Features: Driveway Concrete,Pool Community
  • Foundation Details: Concrete Perimeter
  • List Price: 414000
  • Association Maintained Building Exterior: 0
  • Porch: Open Patio,Covered Porch

Garage/Parking

  • Garage Spaces: 3
  • Fuel: Gas
  • Garage Parking Description: Attached
  • Garage Parking Other: Garage Door Opener,Finished Garage,Keyless Entry

Utilities

  • Sewer: Sewer Connected
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Solid Waste: 0
  • Utility Options: Cable Available,High Speed Internet Avail
  • Water Heater: Gas

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Management Company Name: Community Management Service
  • Management Company Phone: 317-542-3355

Fee Information

  • Association Fee Includes: Clubhouse,Entrance Common,Insurance,Maintenance,Pool,Snow Removal
  • Mandatory Fee: 632

Lot Info

  • Property Attached Yn: No
  • Parcel Number: 291133020021000020
  • Acres: <1/4 Acre
  • Lot Information: Sidewalks,Storm Sewer,Street Lights
  • Lot Number: 85
  • Lot Size: .24

Green Features

  • Green Certification Y N: 0

Tax Info

  • Tax Annual Amount: 3676
  • Semi Annual Property Tax Amt: 1838
  • Tax Exemption: HomesteadTaxExemption,MortageTaxExemption

MLS Schools

  • School District: Hamilton Southeastern

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 5, 2023
Sold by
Hpa Ii Borrower 2020-2 Llc
Bought by
Vanwey Robert Louis
Current Estimated Value
$564,800

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$450,980
Outstanding Balance
$441,914
Interest Rate
6.75%
Mortgage Type
FHA
Estimated Equity
$113,242

Purchase Details

Listed on
Feb 17, 2020
Closed on
Aug 24, 2020
Sold by
Zheng Xiu Mei and Zheng Gui You
Bought by
Hpa Usi Llc
Seller's Agent
Manzil Kohli
Vylla Home
Buyer's Agent
Judy Koehler
Carpenter, REALTORS®
List Price
$425,000
Sold Price
$400,000
Premium/Discount to List
-$25,000
-5.88%

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 23, 2017
Sold by
Zheng Xiu Mei
Bought by
Zheng Xiu Mei and Zheng Gui You

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$288,000
Interest Rate
4.02%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 12, 2015
Closed on
May 8, 2015
Sold by
Rafferty Randy D and Rafferty Lisa A
Bought by
Zheng Xiu Mei
Seller's Agent
Julianne Deely
Berkshire Hathaway Home
Buyer's Agent
Linda Yi Zhang
F.C. Tucker Company
List Price
$359,000
Sold Price
$359,000

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 24, 2008
Sold by
Drees Premier Homes Inc
Bought by
Rafferty Randy D and Rafferty Lisa A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$310,000
Interest Rate
6.39%
Mortgage Type
Purchase Money Mortgage
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
Vanwey Robert Louis $459,300 None Listed On Document
Hpa Usi Llc -- Realtech Title Llc
Zheng Xiu Mei -- None Available
Zheng Xiu Mei -- None Available
Rafferty Randy D -- Fat
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Vanwey Robert Louis $450,980
Previous Owner Hpa Ii Borrower 2020-2 Llc $235,537,159
Previous Owner Zheng Xiu Mei $288,000
Previous Owner Rafferty Randy D $301,100
Previous Owner Rafferty Randy D $307,300
Previous Owner Rafferty Randy D $310,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/25/2020 08/25/20 Sold $400,000 -3.4% $76 / Sq Ft
07/25/2020 07/25/20 Pending -- -- --
07/09/2020 07/09/20 Price Changed $414,000 -1.2% $78 / Sq Ft
06/27/2020 06/27/20 Price Changed $419,000 -1.4% $79 / Sq Ft
06/16/2020 06/16/20 For Sale $425,000 0.0% $80 / Sq Ft
06/10/2020 06/10/20 Pending -- -- --
05/29/2020 05/29/20 Price Changed $425,000 -0.9% $80 / Sq Ft
04/21/2020 04/21/20 Price Changed $429,000 -1.4% $81 / Sq Ft
03/28/2020 03/28/20 Price Changed $434,900 -1.1% $82 / Sq Ft
02/17/2020 02/17/20 For Sale $439,900 +22.5% $83 / Sq Ft
05/08/2015 05/08/15 Sold $359,000 -4.3% $68 / Sq Ft
04/21/2015 04/21/15 Price Changed $375,000 +4.5% $71 / Sq Ft
04/10/2015 04/10/15 For Sale $359,000 0.0% $68 / Sq Ft
03/03/2015 03/03/15 Pending -- -- --
02/12/2015 02/12/15 For Sale $359,000 -- $68 / Sq Ft
Source: MIBOR Broker Listing Cooperative®

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 $5,251 $458,900 $93,000 $365,900
2023 $5,251 $454,200 $93,000 $361,200
2022 $9,549 $428,400 $93,000 $335,400
2021 $8,757 $384,200 $93,000 $291,200
2020 $8,920 $387,500 $93,000 $294,500
2019 $8,622 $372,700 $75,000 $297,700
2018 $8,308 $359,000 $75,000 $284,000
2017 $4,291 $358,000 $75,000 $283,000
2016 $4,363 $364,100 $75,000 $289,100
2014 $3,689 $339,700 $75,000 $264,700
2013 $3,689 $342,500 $75,000 $267,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: MBR21695478

MIBOR Broker Listing Cooperative®

APN: 29-11-33-020-021.000-020