NOT LISTED FOR SALE

2151 N 400 E Lafayette, IN 47905

Estimated Value: $730,000 - $799,747

5 Beds
5 Baths
4,652 Sq Ft
$161/Sq Ft Est. Value

Last Sold December 12, 2024

Last sale price $725,000 $156 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $4,658/month

28 Days on Market

Highlights

  • In Ground Pool
  • Primary Bedroom Suite
  • Fireplace in Bedroom
  • Hershey Elementary School Rated A-
  • Waterfront
  • Lake, Pond or Stream

About This Home

As of December 2024

Welcome to Blue Herron Estates: a gorgeous house on a private 5 acre wooded lot. Enjoy the beautiful view of the pond and natural light thanks to the abundance amount of windows throughout the house. Don't miss the unique stain glass windows. This 5 bed, 3 full 2 half bath, has so much to offer. Including a finished basement with wet bar, 5 fireplaces, great room with wet bar, sauna, pool, and that is just at the main house! The carriage garage also boast a 1 bed, full bath apartment above. Peaceful setting close to walking trails. Don't miss your chance to see this one, call your favorite Realtor today!

Last Listed By

Cathy Russell

@properties Listed on: 10/15/2024

@properties

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,862

Year Built

  • Built in 1987

Lot Details

  • 5.08 Acre Lot
  • Waterfront
  • Partially Fenced Property
  • Vinyl Fence
  • Brick Fence
  • Irregular Lot
  • Partially Wooded Lot
  • Property is zoned R1

Parking

  • 2 Car Attached Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Wood Siding

Interior Spaces

  • 1.5-Story Property
  • Wet Bar
  • Built-in Bookshelves
  • Built-In Features
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Double Pane Windows
  • Pocket Doors
  • Insulated Doors
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • 5 Fireplaces
  • Formal Dining Room
  • Workshop
  • Storage In Attic

Kitchen

  • Eat-In Kitchen
  • Walk-In Pantry
  • Kitchen Island
  • Stone Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • In-Law or Guest Suite
  • Double Vanity
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Partially Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • Fireplace in Basement
  • Block Basement Construction
  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement
  • Crawl Space
  • Natural lighting in basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • In Ground Pool
  • Lake, Pond or Stream
  • Covered patio or porch

Schools

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

Utilities

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

Community Details

  • Community Pool

Listing and Financial Details

  • Assessor Parcel Number 79-07-12-351-002.000-003

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,862

Year Built

Built in 1987

Lot Details

0

Parking

2

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 1987
  • Age: 37
  • Style: One and Half 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: 5
  • Total Full Bathrooms: 3
  • Total Number of Half Bathrooms: 2
  • Legal Description: PT SW SEC 12 TWP 23 R4 5.08 A
  • Parcel Number ID: 79-07-12-351-002.000-003
  • Platted: Yes
  • Amenities: Attic Storage, Built-In Speaker System, Built-In Bookcase, Cable Available, Ceiling-9+, Ceilings-Vaulted, Closet(s) Walk-in, Countertops-Solid Surf, Countertops-Stone, Detector-Carbon Monoxide, Detector-Smoke, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Foyer Entry, Guest Quarters, Kitchen Island, Near Walking Trail, Pantry-Walk In, Patio Open, Pocket Doors, Porch Covered, Twin Sink Vanity, Wet Bar, Stand Up Shower, Tub/Shower Combination, Workshop, Main Level Bedroom Suite, Formal Dining Room, Great Room, Main Floor Laundry, Sump Pump, Washer Hook-Up, Custom Cabinetry
  • Sp Lp Percent: 87.88
  • County Zoning: R1
  • Year Taxes Payable: 2024
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 4797
  • Total Finished Sq Ft: 4652
  • Above Grade Finished Sq Ft: 3688
  • Below Grade Finished Sq Ft: 964
  • Below Grade Sq Ft: 145
  • Price Per Sq Ft: 196.58
  • Basement: Yes
  • Basement Foundation: Crawl, Daylight, Partial Basement, Walk-Out Basement, Partially Finished
  • Basement Material: Block
  • Number Of Fireplaces: 5
  • Fireplace: Breakfast Room, Den, Living/Great Rm, Rec Rm, 1st Bdrm, Gas Log, Wood Burning, Basement
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Carpet, Laminate, Tile, Ceramic Tile
  • Living Great Room: Dimensions: 23x16, On Level: Main
  • Kitchen: Dimensions: 14x13, On Level: Main
  • Breakfast Room: Dimensions: 18x10, On Level: Main
  • Dining Room: Dimensions: 14x12, On Level: Main
  • Den: Dimensions: 16x12, On Level: Main
  • Recreation Room: Dimensions: 32x15, On Level: Lower
  • Extra Room: Bonus, Dimensions: 16x13, On Level: Lower
  • Bedroom 1: Dimensions: 20x16, On Level: Main
  • Bedroom 2: Dimensions: 14x11, On Level: Main
  • Bedroom 3: Dimensions: 13x12, On Level: Upper
  • Bedroom 4: Dimensions: 11x13, On Level: Upper
  • Bedroom 5: Dimensions: 11x11, On Level: Upper
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 2
  • Total Below Grade Sq Ft: 1109

Exterior Features

  • Exterior: Brick, Wood
  • Outbuilding1: None
  • Pool: Below Ground
  • Pool: Yes
  • Fence: Brick, Partial, PVC

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 2
  • Garage Size: Dimensions: 22x20
  • Garage Sq Ft: 440
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: Septic
  • Water Utilities: Well
  • Hvac: Ceiling Fan, Zoned Air Condtioning, Zoned Heating
  • Laundry: Dimensions: Mainx8, On Level: 18
  • Water Type: Pond
  • Well Type: Private

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: Irregular, Partially Wooded, Waterfront
  • Lot Dimensions: Irregular
  • Estimated Lot Sq Ft: 221285
  • Estimated Lot Size Acres: 5.08

Green Features

  • Energy Efficient Windows/Doors: Double Pane Windows, Insulated Doors

Tax Info

  • Annual Taxes: 5862.16
  • Total Assessed Value: 713300

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
Oct 15, 2024
Closed on
Dec 12, 2024
Sold by
Rodkey Mary Kathleen
Bought by
Hostetler Ray and Hostetler Kristie
Seller's Agent
Cathy Russell
@properties
Buyer's Agent
Kyle Charters
Indiana Integrity REALTORS
List Price
$825,000
Sold Price
$725,000
Premium/Discount to List
-$100,000
-12.12%
Total Days on Market
28
Views
149
Current Estimated Value
$748,437

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$23,437
Avg. Annual Appreciation
8.01%
Original Mortgage
$652,500
Outstanding Balance
$650,818
Interest Rate
6.79%
Mortgage Type
New Conventional
Estimated Equity
$96,302

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
Hostetler Ray -- Foundation Title
Hostetler Ray $725,000 Foundation Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hostetler Ray $652,500
Closed Hostetler Ray $652,500
Previous Owner Rodkey Mary Kathleen $475,000
Previous Owner Rodkey Mary Kathleen $417,000
Previous Owner Rodkey Mary Kathleen $93,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/12/2024 12/12/24 Sold $725,000 -12.1% $156 / Sq Ft
11/12/2024 11/12/24 Pending -- -- --
10/15/2024 10/15/24 For Sale $825,000 +57.1% $177 / Sq Ft
07/24/2013 07/24/13 Sold $525,000 -3.7% $113 / Sq Ft
06/01/2013 06/01/13 Pending -- -- --
04/07/2013 04/07/13 For Sale $545,000 -- $117 / 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 $5,862 $737,400 $46,900 $690,500
2023 $5,862 $713,300 $46,900 $666,400
2022 $5,826 $642,700 $46,900 $595,800
2021 $5,101 $561,900 $46,900 $515,000
2020 $4,716 $529,600 $46,900 $482,700
2019 $4,605 $518,200 $46,900 $471,300
2018 $4,359 $501,800 $46,900 $454,900
2017 $4,193 $484,200 $46,900 $437,300
2016 $4,017 $473,800 $46,900 $426,900
2014 $3,452 $416,700 $46,900 $369,800
2013 $3,641 $410,500 $46,900 $363,600
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Indiana Regional MLS

MLS Number: 202440021

Indiana Regional MLS

APN: 79-07-12-351-002.000-003