NOT LISTED FOR SALE

4038 Farmington Dr N Lafayette, IN 47905

Estimated Value: $475,000 - $525,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,836/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 Listed By

Amy Junius-Humbaugh

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

F.C. Tucker/Shook

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
  • 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

Partially Finished Basement

  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement

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%
Total Days on Market
89
Views
301
Current Estimated Value
$493,471

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$13,471
Avg. Annual Appreciation
2.50%
Original Mortgage
$384,000
Outstanding Balance
$379,821
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$113,650

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

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

Similar Homes in Lafayette, IN

  • 2045 Foxmoor Ln, Lafayette, IN 47905

    $535,000

    • 5 Beds
    • 4.5 Baths
    • 4,661 Sq Ft
    • 2045 Foxmoor Ln
    • Lafayette, IN

    This stunning 5-bedroom, 4.5-bath home sits on a generous 0.38-acre lot and offers a perfect blend of luxury and function. The gourmet kitchen features custom cabinets, granite countertops, a large island, and double ovens—ideal for cooking and entertaining. Enjoy the warmth of hand-scraped hardwood floors, a cozy gas fireplace, and a bright sunroom overlooking the serene backyard. The full

    Angela Rohrabaugh BerkshireHathaway HS IN Realty

    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
  • 2508 Rainbow Dr, Lafayette, IN 47904

    $429,000

    • 5 Beds
    • 3.5 Baths
    • 3,307 Sq Ft
    • 2508 Rainbow Dr
    • Lafayette, IN

    Convenient location for shopping, schools and interstate this well maintained home is ready for new owners. Beautiful wood floors in living room, dining room, and breakfast nook. Newer carpet throughout, new appliances, two fireplaces in living room and family room in basement. Five bedrooms, three and a half baths, with nice out door space as well. Large storage shed and fenced in back yard and

    LuAnn Parker Keller Williams Lafayette

    Section Image
  • 2501 Sunrise Ave, Lafayette, IN 47904

    $459,000

    • 4 Beds
    • 5 Baths
    • 3,474 Sq Ft
    • 2501 Sunrise Ave
    • Lafayette, IN

    Welcome to 2501 Sunrise Avenue, a home that boasts unique architectural features and impressive updates. Step outside to discover two expansive decks -- one welcoming you at the front of the house and a private courtyard deck on the back. The main living space features a vaulted, maple wood ceiling, stone fireplace and expansive windows that offer wonderful natural lighting. The kitchen was

    Amy Junius-Humbaugh F.C. Tucker/Shook

    Section Image
  • 6112 Helmsdale Dr, Lafayette, IN 47905

    $614,900

    • 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
  • 6218 Helmsdale Dr, Lafayette, IN 47905

    $489,900

    • 4 Beds
    • 3.5 Baths
    • 2,923 Sq Ft
    • 6218 Helmsdale Dr
    • Lafayette, IN

    Welcome to the BRAND NEW-MILAKIS HOMES Lilac floor plan nestled on a acre lot in the east sides Barrington Woods subdivision. Conveniently located minutes from SR26, I65, Purdue University, SIA, Hospitals, Shopping, & TSC’s Wyandotte, East Tipp, & Harrison schools. With nearly 3000 SF and 3-4 bedrooms & 3 baths this home has space for everyone. Main floor highlights include: An inviting two

    Michelle Wagoner Keller Williams Lafayette

    Section Image
  • 4239 N 750 E, Lafayette, IN 47905

    $525,000

    • 6 Beds
    • 4 Baths
    • 2,688 Sq Ft
    • 4239 N 750 E
    • Lafayette, IN

    Are you dreaming of your own slice of paradise away from the hustle and bustle of city life? Your search ends here! Discover this exciting new listing on a beautiful 3-acre lot that guarantees privacy, complete with a delightful wooded tree-line at the back, ensuring peace and tranquility! Dive into the inviting in-ground pool, relax on the sunbathing patios, and enjoy the convenience of a pool

    Tabitha Casto TruVant Realty

    Section Image
  • 30 Mary Hill Rd, Lafayette, IN 47905

    $584,900

    • 4 Beds
    • 3.5 Baths
    • 2,912 Sq Ft
    • 30 Mary Hill Rd
    • Lafayette, IN

    Welcome to 30 Mary Hill Road, an absolutely stunning mid-century modern home nestled on a wooded lot just minutes from downtown. This beautifully renovated home boasts an impressive kitchen that offers all the wow factors—quartz countertops, a gas range, a range hood, and a built-in bar. You’ll also enjoy breathtaking views while cooking and entertaining. The property features four bedrooms,

    Amy Junius-Humbaugh F.C. Tucker/Shook

    Section Image
  • 5368 Crocus Dr, Lafayette, IN 47906

    $569,900

    • 4 Beds
    • 4 Baths
    • 3,011 Sq Ft
    • 5368 Crocus Dr
    • Lafayette, IN

    BETTER THAN NEW in Oak Ridge – 4 Bed | 4 Bath | 3-Car Garage Welcome to this stunning better-than-new 4 Bedroom, 4 Full Bath home located in the highly desirable Oak Ridge neighborhood of West Lafayette. Built less than two years ago, this beautifully designed home is ideally situated just minutes from I-65, US 52W, SR 43N, Purdue University, and top-rated Burnett Creek, Battle Ground, and

    Michelle Wagoner Keller Williams Lafayette

    Section Image

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 $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