NOT LISTED FOR SALE

4038 Farmington Dr N Lafayette, IN 47905

Estimated Value: $472,000 - $522,000

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

Last Sold March 26, 2024

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

Est. 3% increase in value since last sale

Current estimated payment $2,948/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
  • Age: 24
  • Style: Two Story
  • Architectural Style: Traditional
  • Total Number of Rooms: 13
  • Total Number of Rooms Below Grade: 2
  • Bedrooms: 5
  • Number Above Grade 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
  • Sp Lp Percent: 98.16
  • Year Taxes Payable: 2023
  • 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
  • Price Per Sq Ft: 177.91
  • 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 Sq Ft: 696
  • 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

  • School District: Tippecanoe School Corp.
  • Elementary School: Hershey
  • Middle School: East Tippecanoe
  • High School: William Henry Harrison
  • 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.

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
$492,253

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$12,253
Avg. Annual Appreciation
2.22%
Original Mortgage
$384,000
Interest Rate
6.64%
Mortgage Type
New Conventional

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

Similar Homes in Lafayette, IN

  • 125 Durkees Run Dr, Lafayette, IN 47905

    $529,900

    • 3 Beds
    • 3.5 Baths
    • 4,134 Sq Ft
    • 125 Durkees Run Dr
    • Lafayette, IN

    Located in Lafayette’s Saw Mill Run subdivision, this 3-bed, 3-bath home offers style and comfort. The entry features soaring ceilings and an open staircase between the formal dining and living rooms. Tray ceilings add sophistication to the dining area, while the kitchen includes an island, breakfast nook, and coffee/wine bar. The living room has skylights that provide tons of natural light and a

    Cathy Russell @properties

    Section Image
  • 3935 Shana Jane Dr, Lafayette, IN 47905

    $490,000

    • 3 Beds
    • 4 Baths
    • 3,878 Sq Ft
    • 3935 Shana Jane Dr
    • Lafayette, IN

    Don’t miss this beautifully maintained 3-bedroom, 4-bathroom home located on a premium corner lot in the highly sought-after Watkins Glen neighborhood. Nestled in the desirable Hershey / East Tippecanoe School District, this home offers a perfect blend of privacy, convenience, and thoughtful updates. The main level features a spacious layout with abundant natural light, while the finished

    Calvin Dykhuizen Trueblood Real Estate

    Section Image
  • 60 Mill Dr, Lafayette, IN 47905

    $399,999

    • 3 Beds
    • 3 Baths
    • 3,004 Sq Ft
    • 60 Mill Dr
    • Lafayette, IN

    Stunning Home with Pond Views & Open-Concept Living Nestled in a prime location, this three-bedroom, three-bathroom home offers a perfect blend of comfort and style. The unique design features an inviting open-concept layout, ideal for modern living. Enjoy cozy evenings by the gas log fireplace, while large windows showcase picturesque views. The main level boasts a versatile office or extra

    Joan Abbott Joan Abbott Real Estate

    Section Image
  • 1320 Castle Dr, Lafayette, IN 47905

    $545,000

    • 4 Beds
    • 3.5 Baths
    • 4,435 Sq Ft
    • 1320 Castle Dr
    • Lafayette, IN

    Nestled in the heart of the prestigious Kings Ridge neighborhood, 1320 Castle Drive in Lafayette offers an enchanting blend of serene, nature-filled living and sophisticated comfort. This stunning custom two-story home sits on a private, wooded 1.42-acre lot, a true bird watcher’s paradise where deer are frequent visitors, providing a peaceful backdrop to everyday life. Step inside to discover

    Amanda Oakley Trueblood Real Estate

    Section Image
  • 4201 Eisenhower Rd, Lafayette, IN 47905

    $534,900

    • 3 Beds
    • 3.5 Baths
    • 3,607 Sq Ft
    • 4201 Eisenhower Rd
    • Lafayette, IN

    The setting is stunning! This beautifully designed home sits above the running waters of the Wildcat Creek Creek in a wooded, private setting. The creek is visible through all four seasons and you will feel like you are far away from the bright lights of the city, but you are only just a few miles to shopping, dining, schools. The interior spaces have a special architectural style. The

    Amy Junius-Humbaugh F.C. Tucker/Shook

    Section Image
  • 570 Golden Place, Lafayette, IN 47905

    $599,900

    • 3 Beds
    • 3.5 Baths
    • 3,923 Sq Ft
    • 570 Golden Place
    • Lafayette, IN

    This California Ranch style home is not like anything you have seen currently on the market. Nestled on over an acre and a half this classic beauty is a rare find. Where spacious interiors meet a seamless connection to the outdoors. 3 large bedrooms as well as a den in the basement that the sellers have used as a 4th bedroom in the past. 3 full bathrooms and 1 half bath. The quality, detail and

    Robyn Bower The Real Estate Agency

    Section Image
  • 44 Fairfieldview Ct, Lafayette, IN 47905

    $394,900

    • 3 Beds
    • 3 Baths
    • 2,319 Sq Ft
    • 44 Fairfieldview Ct
    • Lafayette, IN

    This walkout ranch is a unique and special property, nestled on a wooded lot that provides great privacy during the summer and beautiful views of the pond in the winter. Step inside to discover a family room featuring three elegant arched windows, crown molding, and a double-sided fireplace. The main level boasts a thoughtful split floor plan with a spacious primary suite, complete with a

    Amy Junius-Humbaugh F.C. Tucker/Shook

    Section Image
  • 2711 Sleepy Hollow Dr, Lafayette, IN 47904

    $419,000

    • 4 Beds
    • 3.5 Baths
    • 4,218 Sq Ft
    • 2711 Sleepy Hollow Dr
    • Lafayette, IN

    Welcome to 2711 Sleepy Hollow Dr, a charming 4-level home in Lafayette’s desirable Jesco Hills subdivision. With a traditional floor plan, spacious rooms, and a backyard retreat, this home blends timeless character with modern comfort. Inside, you’ll find warm wood floors, a formal living room, formal dining room, and a cozy family room with a brick fireplace. The spacious kitchen is a chef’s

    Eric Seymour BerkshireHathaway HS IN Realty

    Section Image
  • 6112 Helmsdale Dr, Lafayette, IN 47905

    $599,000

    • 4 Beds
    • 3 Baths
    • 3,668 Sq Ft
    • 6112 Helmsdale Dr
    • Lafayette, IN

    This new build home by Jordan Custom Homes is located in Barrington Woods Subdivision. Enjoy this beautiful wooded lot and being surrounded by nature. With 4 bedrooms and 3 full bathrooms this house has plenty of room for entertaining. This home has a large finished basement! With an additional bedroom and playroom downstairs there is plenty of room for guests. Open concept kitchen and living

    Travis Nuest Copper Leaf Real Estate

    Section Image

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
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 Lesley A $389,800
Closed Baird Jacob $384,000
Previous Owner Schrandt Gregory M $102,500
Previous Owner Schrandt Gregory M $161,100
Previous Owner Schrandt Gregory M $168,000
Previous Owner Williams Jasson L $28,000
Previous Owner Williams Jasson L $206,650
Previous Owner Williams Jasson L $206,650
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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,531 $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