NOT LISTED FOR SALE

4167 Farmstead Ln West Lafayette, IN 47906

Estimated Value: $695,000 - $773,000

4 Beds
3.5 Baths
4,666 Sq Ft
$157/Sq Ft Est. Value

Last Sold July 08, 2022

Last sale price $625,000 $134 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $4,321/month

38 Days on Market

Highlights

  • Primary Bedroom Suite
  • Cathedral Ceiling
  • Cul-De-Sac
  • Klondike Middle School Rated A-
  • Solid Surface Countertops
  • 2 Car Attached Garage

About This Home

As of July 2022

A custom built home, fully-updated, in the exclusive Farmstead neighborhood. Situated on a generous lot bordered by farmland, this home is the best of both worlds -- country living near city conveniences. Just minutes to Park or shopping. Newly-updated kitchen with quartz counters, five burner gas cooktop and hood, double-oven, over-sized island and stunning LVT flooring. Gorgeous dark bamboo flooring outfits the large, open family room, dining room and foyer. Four spacious bedrooms (two on the main floor), all with walk-in closets -- the master's suite has two! In addition, there are two huge walk-in storage closets upstairs. A full-sized laundry room with built-ins and convenient folding counter with sink. The finished basement includes both a second family room and a workout room. Both roof and HVAC new in 2020. New carpet throughout. Situated at the rear of the lot, is a 64'x30' FBI pole barn with full-electric and gas-heat.

Last Buyer's Agent

Elizabeth Hobbs

Keller Williams Lafayette

Keller Williams Lafayette

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,186

Year Built

  • Built in 2000

Lot Details

  • 2.32 Acre Lot
  • Cul-De-Sac

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Exterior Construction
  • Wood Siding
  • Vinyl Construction Material

Interior Spaces

  • 1.5-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Screen For Fireplace
  • Gas Log Fireplace
  • Living Room with Fireplace

Kitchen

  • Breakfast Bar
  • Solid Surface Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Attic

  • Storage In Attic
  • Pull Down Stairs to Attic

Finished Basement

  • Basement Fills Entire Space Under The House
  • 1 Bathroom in Basement

Schools

  • Klondike Elementary And Middle School
  • William Henry Harrison High School

Utilities

  • Central Air
  • Heating System Uses Gas
  • Well
  • Septic System
  • Cable TV Available

Community Details

  • Farmstead Subdivision

Listing and Financial Details

  • Assessor Parcel Number 79-06-09-426-011.000-022

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,186

Year Built

Built in 2000

Lot Details

0

HOA Fees

$50 per month

Parking

2

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2000
  • Age: 22
  • Style: One and Half Story
  • Total Number of Rooms: 13
  • Total Number of Rooms Below Grade: 2
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 4
  • Total Bathrooms: 4
  • Total Full Bathrooms: 3
  • Total Number of Half Bathrooms: 1
  • Legal Description: PT E SE SEC 9 TWP 23 R5 2.318 A
  • Parcel Number ID: 79-06-09-426-011.000-022
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Attic Pull Down Stairs, Attic Storage, Breakfast Bar, Cable Available, Cable Ready, Ceiling-Cathedral, Ceiling Fan(s), Closet(s) Walk-in, Countertops-Solid Surf, Main Level Bedroom Suite
  • Sp Lp Percent: 100
  • Year Taxes Payable: 2020
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 4810
  • Total Finished Sq Ft: 4666
  • Above Grade Finished Sq Ft: 3612
  • Below Grade Finished Sq Ft: 1054
  • Below Grade Sq Ft: 144
  • Price Per Sq Ft: 173.03
  • Basement: Yes
  • Basement Foundation: Full Basement, Finished
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Fireplace Screen/Door, Gas Log, Vented
  • Fireplace: Yes
  • Kitchen: Dimensions: 20x14, On Level: Main
  • Bedroom 1: Dimensions: 16x15, On Level: Main
  • Bedroom 2: Dimensions: 15x11, On Level: Main
  • Bedroom 3: Dimensions: 16x13, On Level: Upper
  • Bedroom 4: Dimensions: 14x12, On Level: Upper
  • Number Below Grade Bathrooms: 1
  • Number of Main Level Full Bathrooms: 2
  • Number of Below Grade Half Bathrooms: 1
  • Total Below Grade Sq Ft: 1198

Exterior Features

  • Exterior: Brick, Vinyl, Wood
  • Outbuilding1: Pole/Post Building, Dimensions: 63x30

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 2
  • Garage Size: Dimensions: 23x20
  • Garage Sq Ft: 460
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas
  • Sewer: Septic
  • Water Utilities: Well
  • Laundry: Dimensions: Mainx10, On Level: 11
  • Well Type: Unknown

Condo/Co-op/Association

  • Association Fees: 600
  • Association Fees Frequency: Annually

Schools

  • School District: Tippecanoe School Corp.
  • Elementary School: Klondike
  • Middle School: Klondike
  • High School: William Henry Harrison
  • Elementary School: Klondike

Lot Info

  • Lot Description: Cul-De-Sac
  • Lot Dimensions: IRR
  • Estimated Lot Sq Ft: 100972
  • Estimated Lot Size Acres: 2.318
  • Lot Number: 1

Tax Info

  • Annual Taxes: 3186
  • Total Assessed Value: 407300

MLS Schools

  • High School: William Henry Harrison
  • Middle School: Klondike
  • School District: Tippecanoe School Corp.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 28, 2022
Closed on
Jul 7, 2022
Sold by
Stephens Brian E and Stephens Janet E
Bought by
Ulmer Zachary W and Ulmer Maria E
Buyer's Agent
Elizabeth Hobbs
Keller Williams Lafayette
List Price
$629,900
Sold Price
$625,000
Premium/Discount to List
-$4,900
-0.78%
Current Estimated Value
$730,760

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$105,760
Avg. Annual Appreciation
3.71%
Original Mortgage
$531,250
Outstanding Balance
$509,593
Interest Rate
5.23%
Mortgage Type
Balloon
Estimated Equity
$193,399

Purchase Details

Closed on
May 25, 2005
Sold by
Dunwoody Todd F and Dunwoody Jessica R
Bought by
Stephens Brian E and Stephens Janet E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$296,000
Interest Rate
6.07%
Mortgage Type
Fannie Mae Freddie Mac
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
Ulmer Zachary W $625,000 Klatch Louis
Stephens Brian E -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ulmer Zachary W $531,250
Previous Owner Stephens Brian E $296,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/08/2022 07/08/22 Sold $625,000 0.0% $134 / Sq Ft
06/05/2022 06/05/22 Pending -- -- --
05/17/2022 05/17/22 Price Changed $625,000 -0.8% $134 / Sq Ft
04/28/2022 04/28/22 For Sale $629,900 -- $135 / Sq Ft
Source: Indiana Regional MLS

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 $4,757 $603,100 $73,600 $529,500
2023 $4,399 $573,500 $73,600 $499,900
2022 $3,456 $427,500 $73,600 $353,900
2021 $3,174 $409,800 $73,600 $336,200
2020 $3,186 $407,300 $73,600 $333,700
2019 $2,964 $393,200 $73,600 $319,600
2018 $2,766 $376,400 $58,600 $317,800
2017 $2,748 $375,200 $58,600 $316,600
2016 $2,695 $371,100 $58,600 $312,500
2014 $2,381 $335,200 $58,600 $276,600
2013 $2,508 $335,200 $58,600 $276,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202215379

Indiana Regional MLS

APN: 79-06-09-426-011.000-022