NOT LISTED FOR SALE

Estimated Value: $2,036,359 - $2,151,000

5 Beds
4 Baths
5,460 Sq Ft
$386/Sq Ft Est. Value

Last Sold April 10, 2025

Last sale price $2,150,000 $394 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $12,953/month

139 Days on Market

Highlights

  • Lake Front
  • Vaulted Ceiling
  • Wood Flooring
  • Great Room with Fireplace
  • Ranch Style House
  • Bar Fridge

About This Home

As of April 2025

Presenting this one-of-a-kind, fully renovated 5-bedroom, 4-bathroom waterfront ranch on Geist Reservoir's main body. Situated on an exclusive lot with 250 feet of pristine water frontage, this stunning home offers nearly 5,500 square feet of sophisticated living space across two expansive levels. Upon entry, you're greeted by breathtaking panoramic water views from multiple rooms, all thoughtfully designed to complement a lifestyle centered around hosting and relaxation. The home provides multiple dining areas, including a charming breakfast nook with picturesque water views, an elegant dining space perfect for large gatherings, and an oversized kitchen island with seating, making this the ultimate spot for meals or casual entertaining. The completely remodeled gourmet kitchen is a chef's dream space. Flowing seamlessly from the kitchen, the great room features a striking, eye-catching fireplace, adding to the home's inviting yet upscale ambiance. Retreat to the spacious master suite, where expansive windows allow you to wake up to serene water views. The master bathroom is a true sanctuary, featuring floor-to-ceiling tile, a spa-like shower, and a massive walk-in closet. The walkout lower level offers two additional bedrooms and is an entertainer's paradise, complete with a kitchenette & bar area that flows effortlessly into the backyard. Outside, the expansive deck offers spectacular views and direct access to the dock, providing the perfect spot to take in the gorgeous lakefront setting. Whether you're entertaining or simply relaxing, the seamless indoor-outdoor flow creates a truly remarkable experience. The home offers a spacious 3-car garage to complement this rare waterfront opportunity. With over 0.4 acres of beautifully manicured grounds, this Geist waterfront home provides everything you could want for the perfect lakeside lifestyle.

Last Agent to Sell the Property

Patrick Tumbarello

F.C. Tucker Company Brokerage Email: patrick@homesofindiana.com License #RB14052174 Listed on: 10/24/2024

F.C. Tucker Company

Last Buyer's Agent

Matt King

F.C. Tucker Company License #RB16001708

F.C. Tucker Company

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,574

Year Built

  • Built in 1989

Lot Details

  • 0.4 Acre Lot
  • Lake Front
  • Reservoir Front
  • Sprinkler System

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • Wet Bar
  • Bar Fridge
  • Vaulted Ceiling
  • Fireplace With Gas Starter
  • Great Room with Fireplace
  • 2 Fireplaces
  • Utility Room
  • Lake Views
  • Attic Access Panel

Kitchen

  • Eat-In Kitchen
  • Gas Oven
  • Range Hood
  • <<microwave>>
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • 9 Foot Basement Ceiling Height
  • Sump Pump with Backup
  • Fireplace in Basement

Outdoor Features

  • Multiple Outdoor Decks
  • Patio

Utilities

  • Humidifier
  • Forced Air Heating System
  • Electric Water Heater

Community Details

  • Association fees include home owners, security
  • Association Phone (317) 875-5600
  • Admirals Pointe Subdivision
  • Property managed by Community Association Services
  • The community has rules related to covenants, conditions, and restrictions

Listing and Financial Details

  • Legal Lot and Block 49-01-15-120-020.000-400 / A
  • Assessor Parcel Number 490115120020000400
  • Seller Concessions Not Offered

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,574

Year Built

Built in 1989

Lot Details

0

HOA Fees

$42 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Ranch
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2023
  • Year Built: 1989
  • Building Area Total: 5460
  • Garage Y N: Yes
  • Lot Size Acres: 0.4
  • Subdivision Name: Admirals Pointe
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • Website: www.homesofindiana.com
  • Accessibility Features YN: No
  • MBR_AttributionContact: patrick@homesofindiana.com
  • Attribution Contact: patrick@homesofindiana.com
  • Special Features: VirtualTour

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Finished, Full, Walk Out
  • Appliances: Dishwasher, Dryer, Electric Water Heater, Disposal, Humidifier, Microwave, Gas Oven, Range Hood, Refrigerator, Bar Fridge, Washer, Water Softener Owned
  • Levels: One
  • Full Bathrooms: 4
  • Total Bathrooms: 4
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 2730
  • Fireplace Features: Basement, Gas Starter, Great Room
  • Fireplaces: 2
  • Interior Amenities: Attic Access, Bath Sinks Double Main, Raised Ceiling(s), Center Island, Eat-in Kitchen, Walk-in Closet(s), Wet Bar
  • Living Area: 5460
  • Main Level Bedrooms: 3
  • Other Equipment: Sump Pump w/Backup
  • Areas Interior: Utility Room
  • Eating Area: Breakfast Room,Formal Dining Room
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 3
  • Main Level Sq Ft: 2730
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 0
  • Kitchen Features: Kitchen Updated
  • Rooms Basement: 5

Exterior Features

  • Construction Materials: Brick
  • Exterior Features: Sprinkler System
  • Foundation Details: Concrete Perimeter
  • List Price: 2199900
  • Patio And Porch Features: Multiple Decks, Open Patio
  • View: Lake, Water
  • View Y N: Yes
  • Waterfront Features: Dock, Lake Front, On Reservoir, Waterfront
  • Waterfront: Yes

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached
  • Garage Sq Ft: 744

Utilities

  • Heating: Forced Air, Natural Gas
  • Laundry Features: Main Level
  • Water Source: Municipal/City
  • Solid Waste: Yes

Condo/Co-op/Association

  • Association Fee: 500
  • Association Fee Frequency: Annually
  • Association Phone: 317-875-5600
  • Association YN: Yes
  • Management Company Name: Community Association Services
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Association Home Owners, Entrance Common, Security

Lot Info

  • Property Attached Yn: No
  • Horse Amenities: None
  • Lot Size Sq Ft: 17424
  • Parcel Number: 490115120020000400
  • Acres: 1/4-1/2 Acre
  • Price Acre: 5375000

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 14574
  • Tax Block: A
  • Tax Lot: 49-01-15-120-020.000-400
  • Semi Annual Property Tax Amt: 7287
  • Tax Exemption: Homestead Tax Exemption

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 30, 2022
Closed on
Jul 28, 2022
Sold by
Jo Zwicker Geraldine
Bought by
Barnes Scot and Barnes Jodi
Seller's Agent
Patrick Tumbarello
F.C. Tucker Company
Buyer's Agent
Patrick Tumbarello
F.C. Tucker Company
List Price
$1,850,000
Sold Price
$1,850,000
Current Estimated Value
$2,109,453

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$259,453
Avg. Annual Appreciation
4.50%
Original Mortgage
$1,350,000
Outstanding Balance
$1,297,630
Interest Rate
5.7%
Mortgage Type
New Conventional
Estimated Equity
$811,823
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
Barnes Scot $1,850,000 Schmitz David A
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Barnes Scot $386,961
Open Barnes Scot $1,350,000
Previous Owner Zwicker Geraldine J $417,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/10/2025 04/10/25 Sold $2,150,000 -2.3% $394 / Sq Ft
03/12/2025 03/12/25 Pending -- -- --
03/03/2025 03/03/25 Price Changed $2,199,900 0.0% $403 / Sq Ft
03/03/2025 03/03/25 For Sale $2,199,900 +2.3% $403 / Sq Ft
02/12/2025 02/12/25 Off Market $2,150,000 -- --
10/24/2024 10/24/24 For Sale $2,250,000 +21.6% $412 / Sq Ft
07/27/2022 07/27/22 Sold $1,850,000 0.0% $720 / Sq Ft
07/07/2022 07/07/22 Pending -- -- --
06/30/2022 06/30/22 For Sale $1,850,000 -- $720 / Sq Ft
Source: MIBOR Broker Listing Cooperative®

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 $14,736 $1,300,500 $209,800 $1,090,700
2023 $14,736 $1,313,500 $209,800 $1,103,700
2022 $8,504 $744,700 $209,800 $534,900
2021 $8,086 $698,100 $209,800 $488,300
2020 $7,875 $672,400 $209,800 $462,600
2019 $7,255 $711,000 $209,800 $501,200
2018 $7,222 $708,100 $209,800 $498,300
2017 $6,046 $590,900 $209,800 $381,100
2016 $5,956 $582,300 $209,800 $372,500
2014 $5,674 $567,400 $209,800 $357,600
2013 $5,674 $567,400 $209,800 $357,600
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 22007734

MIBOR Broker Listing Cooperative®

APN: 49-01-15-120-020.000-400