NOT LISTED FOR SALE

2538 Camelot Dr Dyer, IN 46311

Estimated Value: $504,697 - $554,000

4 Beds
2.5 Baths
2,304 Sq Ft
$229/Sq Ft Est. Value

Last Sold June 10, 2024

Last sale price $520,000 $226 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,785/month

2 Days on Market

Highlights

  • Views of Trees
  • Wooded Lot
  • Whirlpool Bathtub
  • Kahler Middle School Rated A-
  • Wood Flooring
  • No HOA

About This Home

As of June 2024

SHOWSTOPPER - 3-4Bdrm/2.5Bth, SPRAWLING RANCH HOME loaded w/ UPGRADES, CONVENIENTLY SITUATED in Castleview Estates w/ WOODED BACKDROP! Rich Brick/Stone Facade and Covered Front Porch, WELCOME YOU into Home boasting 10Ft Ceilings, Hand-scraped HW Flooring, & Neutral, Fresh Paint Palette. Foyer, flanked by Formal Dining Rm and Den/Office, leads to Family Rm highlighted by STONE FIREPLACE w/ Custom Mantle. Eat-in Kitchen boasts CUSTOM Cabinetry w/ Deep Drawers, Crown Molding, & Eat-in Bar. Stainless Steel Applcs include VIKING Oven/Range w/ Professional Hood. SPLIT BEDROOM FLOOR PLAN offers Primary Suite w/ Tray Ceiling and Glass Slider to Covered Patio w/ PEACEFUL VIEWS. Additional Bdrms share Jack-n-Jill Bath, along w/ Powder Rm for Guests. FULL DAYLIGHT BASEMENT w/ Rough-in for Bath. OUTSIDE OASIS features Tiered Patio w/ Overhang, Sunshade, & FIREPIT, to ENJOY NATURE'S BACKDROP. Roof, Hvac, & Hot Water Heater, All NEW in 2022. Look to Attached List for Full Amenities/Details!

Last Agent to Sell the Property

Lisa Thompson

@properties/Christie's Intl RE License #RB14031377 Listed on: 05/09/2024

@properties/Christie's Intl RE

Last Buyer's Agent

Lisa Thompson

@properties/Christie's Intl RE License #RB14031377 Listed on: 05/09/2024

@properties/Christie's Intl RE

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,514

Year Built

  • Built in 2005

Lot Details

  • 0.28 Acre Lot
  • Lot Dimensions are 80 x 150
  • Landscaped
  • Wooded Lot

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Foundation
  • Stone

Interior Spaces

  • 2,304 Sq Ft Home
  • 1-Story Property
  • Wood Burning Fireplace
  • Self Contained Fireplace Unit Or Insert
  • Fireplace With Glass Doors
  • Fireplace With Gas Starter
  • Wood Frame Window
  • Living Room with Fireplace
  • Views of Trees
  • Natural lighting in basement

Kitchen

  • Gas Range
  • Range Hood
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Whirlpool Bathtub

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer
  • Sink Near Laundry

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Covered Patio or Porch

Schools

  • Lake Central High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Softener is Owned

Community Details

  • No Home Owners Association
  • Castleview Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 45-11-18-429-004.000-034

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,514

Year Built

Built in 2005

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 2005
  • Reso Property Sub Type: Single Family Residence
  • ResoLaundryFeatures: Laundry Room, Sink, Main Level
  • ResoLotFeatures: Back Yard, Wooded, Sprinklers In Front, Sprinklers In Rear, Landscaped, Level, Front Yard, Gentle Sloping
  • Road Surface Type: Paved
  • Reso View: Trees/Woods
  • ResoSecurityFeatures: Security System, Smoke Detector(s)
  • Co List Office Mls Id: NRA2041
  • Subdivision Name: Castleview Estates
  • Above Grade Finished Sq Ft: 2304
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Property Attached Yn: No
  • ResoWindowFeatures: Wood Frames
  • AuctionYN: No
  • AccessibilityFeaturesYN: No
  • AboveGradeUnfinishedArea: 0.00
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Convection Oven, Range Hood, Water Softener Owned, Water Purifier Owned, Washer, Stainless Steel Appliance(s), Refrigerator, Instant Hot Water, Microwave, Dishwasher, Gas Range, Dryer, Disposal
  • Interior Amenities: Ceiling Fan(s), Tray Ceiling(s), Whirlpool Tub, Walk-In Closet(s), Pantry, Recessed Lighting, High Ceilings, Entrance Foyer, Eat-in Kitchen
  • Basement: Bath/Stubbed, Sump Pump, Unfinished, Concrete, Daylight
  • Flooring: Hardwood, Tile
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas Starter, Wood Burning, Living Room, Insert, Glass Doors
  • Fireplaces: 1
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Exterior Features: Fire Pit, Private Yard
  • Acres: 0.28
  • Construction Type: Brick, Stone, Vinyl Siding
  • Patio And Porch Features: Covered, Patio, Porch
  • Reso Roof: Shingle

Garage/Parking

  • Garage Spaces: 2.5
  • Parking Features: Attached, Electric Vehicle Charging Station(s), Garage Door Opener

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Curbs, Sidewalks, Street Lights
  • Association: No

Schools

  • Junior High Dist: Lake Central

Lot Info

  • Lot Dimensions: 80 x 150
  • Lot Size Sq Ft: 12196.8
  • Additional Parcels: No
  • Parcel #: 45-11-18-429-004.000-034
  • Zoning Description: Residential

Tax Info

  • Year: 2023
  • Tax Annual Amount: 5514

MLS Schools

  • HighSchool: Lake Central High School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 9, 2024
Closed on
Jun 5, 2024
Sold by
Adams Arthur J and Adams Kristen W
Bought by
Maio William Joseph and Miles Ilse
Seller's Agent
Lisa Thompson
@properties/Christie's Intl RE
Buyer's Agent
Lisa Thompson
@properties/Christie's Intl RE
List Price
$509,900
Sold Price
$520,000
Premium/Discount to List
$10,100
1.98%
Views
29
Current Estimated Value
$527,424

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$7,424
Avg. Annual Appreciation
1.09%
Original Mortgage
$416,000
Outstanding Balance
$410,671
Interest Rate
7%
Mortgage Type
New Conventional
Estimated Equity
$116,753

Purchase Details

Listed on
Oct 1, 2020
Closed on
Dec 18, 2020
Sold by
Kuresten Scott M and Kuresten Mary Jo
Bought by
Adams Kristen W and Adams Arthur J
Seller's Agent
Tina Lopez
Realty Executives Premier
List Price
$418,000
Sold Price
$418,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.48%
Original Mortgage
$397,100
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 29, 2005
Sold by
Eenigenburg Builders Inc
Bought by
Kuersten Scott M and Kuersten Mary Jo

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$280,000
Interest Rate
6.13%
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
Maio William Joseph $520,000 Proper Title
Adams Kristen W -- Fidelity National Title Co
Kuersten Scott M -- Chicago Title Insurance Comp
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Maio William Joseph $416,000
Previous Owner Adams Kristen W $397,100
Previous Owner Kuersten Scott M $280,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/10/2024 06/10/24 Sold $520,000 0.0% $226 / Sq Ft
05/16/2024 05/16/24 Price Changed $519,900 +2.0% $226 / Sq Ft
05/12/2024 05/12/24 Pending -- -- --
05/09/2024 05/09/24 For Sale $509,900 +22.0% $221 / Sq Ft
12/18/2020 12/18/20 Sold $418,000 0.0% $181 / Sq Ft
11/20/2020 11/20/20 Pending -- -- --
10/01/2020 10/01/20 For Sale $418,000 -- $181 / Sq Ft
Source: Northwest Indiana Association of REALTORS®

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 $11,858 $477,500 $70,000 $407,500
2023 $5,143 $466,300 $70,000 $396,300
2022 $5,143 $458,100 $70,000 $388,100
2021 $5,203 $433,200 $70,000 $363,200
2020 $5,061 $416,600 $59,800 $356,800
2019 $5,710 $452,900 $55,800 $397,100
2018 $5,780 $438,700 $55,800 $382,900
2017 $5,305 $433,700 $55,800 $377,900
2016 $5,035 $408,700 $55,800 $352,900
2014 $4,612 $394,300 $55,800 $338,500
2013 $4,618 $389,600 $55,800 $333,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northwest Indiana Association of REALTORS®

MLS Number: 803367

Northwest Indiana Association of REALTORS®

APN: 45-11-18-429-004.000-034