NOT LISTED FOR SALE

Estimated Value: $450,000 - $502,615

4 Beds
3.5 Baths
2,436 Sq Ft
$195/Sq Ft Est. Value

Last Sold April 21, 2023

Last sale price $467,500 $192 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $2,884/month

94 Days on Market

Highlights

  • Waterfront
  • Open Floorplan
  • Lake, Pond or Stream
  • Homestead Senior High School Rated A
  • Fireplace in Bedroom
  • Backs to Open Ground

About This Home

As of April 2023

Take a look at the stunning YELLOWSTONE by Majestic Homes. Situated on a pond lot this home offers 2,436 sq/ft of living space with 4 bedrooms, den, sunroom, island kitchen, large covered patio, and a 3 car garage. Features include all the Majestic Series standards along with QUARTZ countertops. Master bedroom suite offers a nice step ceiling with fan, tiled walk-in shower and double vanity. The sunroom is inviting with the fireplace and a wonderful view of pond. The great room is spacious and open to the island kitchen that offers D & B custom cabinetry, plenty of storage, walk-in pantry and LVP flooring. Sod and Irrigation in the front yard, 9' ceilings standard throughout the house, Lennox HVAC, Frigidaire Gallery Series Appliances and much more. Take Palmira Lakes entrance off Bass Rd just east of W. Hamilton Rd which is Hager Way then turn left on Fazio then right onto Koehler.

Last Agent to Sell the Property

David Dehaven

Mike Thomas Assoc., Inc Listed on: 01/04/2023

Mike Thomas Assoc., Inc

Last Buyer's Agent

Brandy Beckstedt

Mike Thomas Assoc., Inc

Mike Thomas Assoc., Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,684

Year Built

  • Built in 2022

Lot Details

  • 0.39 Acre Lot
  • Lot Dimensions are 140 x 191 x 140 x 48
  • Waterfront
  • Backs to Open Ground
  • Cul-De-Sac
  • Rural Setting
  • Landscaped
  • Irrigation

HOA Fees

  • $29 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Slab Foundation
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 2,436 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Log Fireplace
  • Pocket Doors
  • Entrance Foyer
  • Fire and Smoke Detector
  • Washer and Electric Dryer Hookup

Kitchen

  • Walk-In Pantry
  • Oven or Range
  • Solid Surface Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Bedroom
  • Split Bedroom Floorplan
  • Double Vanity
  • Separate Shower

Attic

  • Storage In Attic
  • Pull Down Stairs to Attic

Outdoor Features

  • Lake, Pond or Stream
  • Covered Patio or Porch

Schools

  • Deer Ridge Elementary School
  • Woodside Middle School
  • Homestead High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Community Details

  • Palmira Lakes Subdivision

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 02-11-04-106-013.000-038

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,684

Year Built

Built in 2022

Lot Details

0

HOA Fees

$29 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 2022
  • Style: One Story
  • Bedrooms: 4
  • Total Bathrooms: 4
  • Total Full Bathrooms: 3
  • Total Number of Half Bathrooms: 1
  • Legal Description: PALMIRA LAKES SECTION IV LOT 148
  • Parcel Number ID: 02-11-04-106-013.000-038
  • Platted: Yes
  • Amenities: Attic Pull Down Stairs, Attic Storage, Ceiling-9+, Ceiling Fan(s), Countertops-Solid Surf, Detector-Smoke, Disposal, Dryer Hook Up Electric, Foyer Entry, Garage Door Opener, Home Warranty Included, Irrigation System, Landscaped, Open Floor Plan, Pantry-Walk In, Patio Open, Pocket Doors, Porch Covered, Range/Oven Hk Up Gas/Elec, Split Br Floor Plan, Twin Sink Vanity, Stand Up Shower, Washer Hook-Up
  • Location: Rural Subdivision
  • New Construction: Spec
  • Special Features: NewHome
  • Stories: 1

Interior Features

  • Total Sq Ft: 2436
  • Total Finished Sq Ft: 2436
  • Above Grade Finished Sq Ft: 2436
  • Basement Foundation: Slab
  • Number Of Fireplaces: 1
  • Fireplace: Extra Rm, Gas Log, Vented
  • Fireplace: Yes
  • Flooring: Carpet, Laminate, Ceramic Tile
  • Living Great Room: Dimensions: 20x16, On Level: Main
  • Kitchen: Dimensions: 12x11, On Level: Main
  • Dining Room: Dimensions: 14x12, On Level: Main
  • Den: Dimensions: 10x10, On Level: Main
  • Extra Room: Sun Room, Dimensions: 14x12, On Level: Main
  • Bedroom 1: Dimensions: 15x13, On Level: Main
  • Bedroom 2: Dimensions: 12x10, On Level: Main
  • Bedroom 3: Dimensions: 12x10, On Level: Main
  • Bedroom 4: Dimensions: 10x10, On Level: Main
  • Number of Main Level Full Bathrooms: 3
  • Number of Main Level Half Bathrooms: 1

Exterior Features

  • Exterior: Stone, Vinyl
  • Outbuilding1: None

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 32x23
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: City
  • Water Utilities: Public
  • Hvac: Ceiling Fan
  • Water Type: Pond

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 350
  • Association Fees Frequency: Annually

Schools

  • Elementary School: Deer Ridge

Lot Info

  • Lot Description: Cul-De-Sac, Waterfront
  • Lot Dimensions: 140 x 191 x 140 x 48
  • Estimated Lot Sq Ft: 16867
  • Estimated Lot Size Acres: 0.387
  • Lot Number: 148

MLS Schools

  • High School: Homestead
  • Middle School: Woodside
  • School District: MSD of Southwest Allen Cnty

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 4, 2023
Closed on
Apr 21, 2023
Sold by
Majestic Custom Homes Of Lafayette Inc
Bought by
Mcmaken Daniel and Mcmaken Barbara
Seller's Agent
David Dehaven
Mike Thomas Assoc., Inc
Buyer's Agent
Brandy Beckstedt
Mike Thomas Assoc., Inc
List Price
$469,900
Sold Price
$467,500
Premium/Discount to List
-$2,400
-0.51%
Current Estimated Value
$485,922

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$18,422
Avg. Annual Appreciation
0.60%

Purchase Details

Listed on
Jan 4, 2023
Closed on
Apr 19, 2023
Sold by
Majestic Custom Homes Of Lafayette Inc
Bought by
Mcmaken Daniel and Mcmaken Barbara
Seller's Agent
David Dehaven
Mike Thomas Assoc., Inc
Buyer's Agent
Brandy Beckstedt
Mike Thomas Assoc., Inc
List Price
$469,900
Sold Price
$467,500
Premium/Discount to List
-$2,400
-0.51%

Purchase Details

Closed on
Dec 30, 2021
Sold by
Palmira Development Llc
Bought by
Majestic Custom Homes Of Lafayette Inc
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
Mcmaken Daniel -- Metropolitan Title Of In
Mcmaken Daniel $467,500 Metropolitan Title Of In
Majestic Custom Homes Of Lafayette Inc $321,670 Renaissance Title
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/21/2023 04/21/23 Sold $467,500 -0.5% $192 / Sq Ft
04/08/2023 04/08/23 Pending -- -- --
01/04/2023 01/04/23 For Sale $469,900 -- $193 / 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 $3,684 $503,100 $84,500 $418,600
2022 $11 $800 $800 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202300234

Indiana Regional MLS

APN: 02-11-04-106-013.000-038