NOT LISTED FOR SALE

4038 Farmington Dr N Lafayette, IN 47905

Estimated Value: $495,893 - $586,000

5 Beds
3.5 Baths
3,631 Sq Ft
$145/Sq Ft Est. Value

Last Sold March 26, 2024

Last sale price $480,000 $132 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $2,993/month

89 Days on Market

Highlights

  • Open Floorplan
  • Vaulted Ceiling
  • Backs to Open Ground
  • Hershey Elementary School Rated A-
  • Traditional Architecture
  • Formal Dining Room

About This Home

As of March 2024

This beautiful house is located in a quiet subdivision and sits on a large, .6 acre lot. Among the many updates, the Seller installed a new roof in 2020, and new HVAC in 2022. The house offers great living spaces that include an open floor plan featuring a large living room with vaulted ceiling, a terrific flex space that could be used for a living room, formal dining room or even a playroom. The main level also features a bedroom and full bath. Upstairs you will find a lovely primary suite with built-in bookcases and a luxurious bath that offers double vanities, a jetted tub, shower, and large walk-in closet. There are three additional bedrooms on the second level and a great loft/game/reading space. The lower level is a great activity space -- movies, exercise, or entertaining -- plus there is ample storage. The warmer weather will take you outdoors to the grand deck or the large yard and if you have a dog they will love to roam and stay on the property with a full yard invisible fence. Schedule a showing today.

Last Agent to Sell the Property

Amy Junius-Humbaugh

F.C. Tucker/Shook Listed on: 11/22/2023

F.C. Tucker/Shook

Last Buyer's Agent

Reagan Geswein

Lafayette Listing Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,664

Year Built

  • Built in 2000

Lot Details

  • 0.6 Acre Lot
  • Lot Dimensions are 132x200
  • Backs to Open Ground
  • Property has an invisible fence for dogs
  • Landscaped
  • Level Lot

HOA Fees

  • $6 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Built-in Bookshelves
  • Vaulted Ceiling
  • Self Contained Fireplace Unit Or Insert
  • Gas Log Fireplace
  • Double Pane Windows
  • Entrance Foyer
  • Living Room with Fireplace
  • Formal Dining Room
  • Partially Finished Basement
  • 1 Bathroom in Basement
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Electric Oven or Range
  • Laminate Countertops
  • Utility Sink
  • Disposal

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Bathtub With Separate Shower Stall
  • Garden Bath

Laundry

  • Laundry on main level
  • Electric Dryer Hookup

Location

  • Suburban Location

Schools

  • Hershey Elementary School
  • East Tippecanoe Middle School
  • William Henry Harrison High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Private Company Owned Well
  • Well
  • Septic System
  • Cable TV Available

Community Details

  • Farmington Subdivision

Listing and Financial Details

  • Assessor Parcel Number 79-07-12-302-014.000-003

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,664

Year Built

Built in 2000

Lot Details

0

HOA Fees

$6 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2000
  • Style: Two Story
  • Architectural Style: Traditional
  • Bedrooms: 5
  • Total Bathrooms: 4
  • Total Full Bathrooms: 3
  • Total Number of Half Bathrooms: 1
  • Legal Description: FARMINGTON SD PH 1E LOT 64
  • Parcel Number ID: 79-07-12-302-014.000-003
  • Platted: Yes
  • Amenities: Breakfast Bar, Built-In Bookcase, Cable Available, Cable Ready, Ceilings-Vaulted, Closet(s) Walk-in, Countertops-Laminate, Deck Open, Detector-Smoke, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Foyer Entry, Garage Door Opener, Jet/Garden Tub, Guest Quarters, Landscaped, Open Floor Plan, Range/Oven Hook Up Elec, Utility Sink, Stand Up Shower, Tub and Separate Shower, Tub/Shower Combination, Formal Dining Room, Main Floor Laundry
  • Location: City/Town/Suburb
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 3948
  • Total Finished Sq Ft: 3631
  • Above Grade Finished Sq Ft: 2698
  • Below Grade Finished Sq Ft: 933
  • Below Grade Sq Ft: 317
  • Basement: Yes
  • Basement Foundation: Partially Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log, One, Fireplace Insert
  • Fireplace: Yes
  • Flooring: Carpet, Ceramic Tile
  • Living Great Room: Dimensions: 19x17, On Level: Main
  • Kitchen: Dimensions: 14x12, On Level: Main
  • Breakfast Room: Dimensions: 14x12, On Level: Main
  • Dining Room: Dimensions: 14x12, On Level: Main
  • Family Room: Dimensions: 31x19, On Level: Basement
  • Bedroom 1: Dimensions: 15x13, On Level: Upper
  • Bedroom 2: Dimensions: 19x11, On Level: Upper
  • Bedroom 3: Dimensions: 13x12, On Level: Upper
  • Bedroom 4: Dimensions: 12x10, On Level: Upper
  • Bedroom 5: Dimensions: 12x11, On Level: Main
  • Other Room1: Storage, Dimensions: 17x10, On Level: Basement
  • Loft: Dimensions: 14x13, On Level: Upper
  • Number Below Grade Bathrooms: 1
  • Number of Main Level Full Bathrooms: 1
  • Number of Below Grade Half Bathrooms: 1
  • Total Below Grade Sq Ft: 1250

Exterior Features

  • Exterior: Brick, Vinyl
  • Roof Material: Asphalt, Shingle
  • Outbuilding1: None
  • Fence: Invisible, Pet Fence

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 24x29
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: Septic
  • Water Utilities: Well
  • Electric Company: Duke Energy Indiana
  • Laundry: Dimensions: Mainx5, On Level: 8
  • Well Type: Private

Condo/Co-op/Association

  • Association Fees: 75
  • Association Fees Frequency: Annually

Schools

  • Elementary School: Hershey

Lot Info

  • Lot Description: Level, 0-2.9999
  • Lot Dimensions: 132x200
  • Estimated Lot Sq Ft: 26136
  • Estimated Lot Size Acres: 0.6

Green Features

  • Energy Efficient Windows/Doors: Double Pane Windows

Tax Info

  • Annual Taxes: 2664
  • Exemptions: Homestead, Mortgage

MLS Schools

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

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 22, 2023
Closed on
Mar 25, 2024
Sold by
Schrandt Gregory M
Bought by
Baird Jacob and Baird Lesley
Seller's Agent
Amy Junius-Humbaugh
F.C. Tucker/Shook
Buyer's Agent
Reagan Geswein
Lafayette Listing Realty LLC
List Price
$499,000
Sold Price
$480,000
Premium/Discount to List
-$19,000
-3.81%
Views
301
Current Estimated Value
$524,723

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$44,723
Avg. Annual Appreciation
5.25%
Original Mortgage
$384,000
Outstanding Balance
$377,625
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$147,098

Purchase Details

Closed on
Feb 8, 2022
Sold by
Schrandt Jennifer S
Bought by
Schrandt Gregory M

Purchase Details

Closed on
Mar 21, 2007
Sold by
Williams Jasson L and Williams Kristen A
Bought by
Schrandt Gregory M and Schrandt Jennifer S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$168,000
Interest Rate
6.27%
Mortgage Type
Unknown
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
Baird Jacob $480,000 None Listed On Document
Schrandt Gregory M -- --
Schrandt Gregory M -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Baird Jacob $384,000
Previous Owner Schrandt Gregory M $168,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/26/2024 03/26/24 Sold $480,000 -1.8% $132 / Sq Ft
02/21/2024 02/21/24 Pending -- -- --
02/20/2024 02/20/24 Price Changed $489,000 -2.0% $135 / Sq Ft
11/24/2023 11/24/23 For Sale $499,000 -- $137 / 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 $2,752 $383,000 $67,400 $315,600
2023 $2,531 $372,000 $67,400 $304,600
2022 $2,664 $345,400 $67,400 $278,000
2021 $2,220 $293,200 $34,000 $259,200
2020 $2,082 $282,800 $44,200 $238,600
2019 $2,046 $279,100 $44,200 $234,900
2018 $1,960 $274,200 $44,200 $230,000
2017 $1,920 $269,400 $44,200 $225,200
2016 $1,849 $266,200 $44,200 $222,000
2014 $1,767 $257,700 $44,200 $213,500
2013 $1,763 $243,900 $44,200 $199,700
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202342613

Indiana Regional MLS

APN: 79-07-12-302-014.000-003