NOT LISTED FOR SALE

Estimated Value: $764,000 - $814,000

5 Beds
4.5 Baths
4,814 Sq Ft
$164/Sq Ft Est. Value

Last Sold December 10, 2024

Last sale price $811,000 $168 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $5,027/month

8 Days on Market

Highlights

  • Waterfront
  • Lake, Pond or Stream
  • Cul-De-Sac
  • Summit Middle School Rated A-
  • Cathedral Ceiling
  • 3 Car Attached Garage

About This Home

As of December 2024

**Multiple Offer Received** This exquisite custom ranch, crafted by Rodney Robrock in 2015, is nestled in the sought-after Waterside Woods community, seamlessly blending modern conveniences with the serenity of natural surroundings. A grand double-door entry opens to an impeccably designed interior adorned with George Kovacs lighting and refined finishes. The gourmet kitchen features custom Miller cabinetry, dual islands, and professional-grade Thermador and Bosch appliances, a dream space for any chef. Entertainment is elevated with beverage refrigerators on both levels and integrated surround sound, featuring Denon receivers and Polk speakers. A spacious main-floor office with large windows and custom cabinetry provides a perfect work-from-home setting. Further enhancements include a central vacuum system, reverse osmosis water filtration, zoned HVAC, whole-house generator, and Tesla EV charger. Positioned on an elevated lot with a walk-out basement, the home opens to a covered deck with tranquil pond views and exclusive water access for fishing, kayaking, and paddle boarding. In an award-winning school district and close to scenic trails, shopping, and major expressways, this residence offers both luxury and convenience in a warm, welcoming community.

Last Agent to Sell the Property

Joseph Hege

Uptown Realty Group Brokerage Phone: 260-615-0738 Listed on: 11/01/2024

Co-Listed By

Jacob Hege

Uptown Realty Group Brokerage Phone: 260-615-0738

Last Buyer's Agent

Deb Paton-Showley

Coldwell Banker Real Estate Group

Coldwell Banker Real Estate Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,151

Year Built

  • Built in 2015

Lot Details

  • 0.48 Acre Lot
  • Lot Dimensions are 155x140
  • Waterfront
  • Cul-De-Sac

HOA Fees

  • $69 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Poured Concrete
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 1-Story Property
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Cathedral Ceiling
  • Living Room with Fireplace
  • Water Views
  • Home Security System

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement

Outdoor Features

  • Lake, Pond or Stream

Schools

  • Haverhill Elementary School
  • Summit Middle School
  • Homestead High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Cable TV Available

Community Details

  • Waterside Woods Subdivision

Listing and Financial Details

  • Assessor Parcel Number 02-11-13-154-011.000-075
  • Seller Concessions Not Offered

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,151

Year Built

Built in 2015

Lot Details

0

HOA Fees

$69 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 2015
  • Age: 9
  • Style: One Story
  • Total Number of Rooms: 8
  • Total Number of Rooms Below Grade: 2
  • Bedrooms: 5
  • Number Above Grade Bedrooms: 3
  • Total Bathrooms: 5
  • Total Full Bathrooms: 4
  • Total Number of Half Bathrooms: 1
  • Legal Description: Waterside Woods Lot 20
  • Parcel Number ID: 02-11-13-154-011.000-075
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Alarm System-Security, Bar, Built-In Speaker System, Built-In Bookcase, Cable Available, Ceiling-9+, Ceiling-Cathedral
  • Number Below Grade Bedrooms: 2
  • Sp Lp Percent: 100
  • Year Taxes Payable: 2024
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 7677
  • Total Finished Sq Ft: 4814
  • Above Grade Finished Sq Ft: 2863
  • Below Grade Finished Sq Ft: 1951
  • Below Grade Sq Ft: 2863
  • Price Per Sq Ft: 283.27
  • Basement: Yes
  • Basement Foundation: Full Basement, Walk-Out Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm
  • Fireplace: Yes
  • Living Great Room: Dimensions: 19x18, On Level: Main
  • Kitchen: Dimensions: 15x16, On Level: Main
  • Dining Room: Dimensions: 15x8, On Level: Main
  • Den: Dimensions: 11x14, On Level: Main
  • Recreation Room: Dimensions: 33x20, On Level: Lower
  • Extra Room: Dimensions: 12x9, On Level: Lower
  • Bedroom 1: Dimensions: 16x17, On Level: Main
  • Bedroom 2: Dimensions: 13x13, On Level: Main
  • Bedroom 3: Dimensions: 13x16, On Level: Main
  • Bedroom 4: Dimensions: 16x18, On Level: Lower
  • Bedroom 5: Dimensions: 15x16, On Level: Lower
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 3
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 4814

Exterior Features

  • Exterior: Stone, Vinyl
  • Outbuilding1: None

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 33x28
  • Garage Sq Ft: 924
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: City
  • Water Utilities: City
  • Laundry: Dimensions: Mainx8, On Level: 10
  • Water Type: Pond

Condo/Co-op/Association

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

Schools

  • School District: MSD of Southwest Allen Cnty
  • Elementary School: Haverhill
  • Middle School: Summit
  • High School: Homestead
  • Elementary School: Haverhill

Lot Info

  • Lot Description: Cul-De-Sac, Waterfront, Water View
  • Lot Dimensions: 155x140
  • Estimated Lot Sq Ft: 20909
  • Estimated Lot Size Acres: 0.48
  • Lot Number: 20

Tax Info

  • Annual Taxes: 7150.64

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 1, 2024
Closed on
Dec 10, 2024
Sold by
Zirpoli Anthony J and Zirpoli Julia A
Bought by
Alexander Bruce A and Alexander Melissa L
Seller's Agent
Joseph Hege
Uptown Realty Group
Buyer's Agent
Deb Paton-Showley
Coldwell Banker Real Estate Group
List Price
$809,900
Sold Price
$811,000
Premium/Discount to List
$1,100
0.14%
Views
76
Current Estimated Value
$789,922

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$21,078
Avg. Annual Appreciation
-1.83%
Original Mortgage
$511,000
Outstanding Balance
$509,215
Interest Rate
6.72%
Mortgage Type
New Conventional
Estimated Equity
$293,018

Purchase Details

Listed on
Jul 11, 2024
Closed on
Aug 8, 2024
Sold by
Valcarcel Joel C and Valcarcel Kristine C
Bought by
Zirpoli Anthony J and Zirpoli Julia A
Seller's Agent
Kami Bardon
CENTURY 21 Bradley Realty, Inc
Buyer's Agent
Jacob Hege
Uptown Realty Group
List Price
$799,900
Sold Price
$799,900
Views
25

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.14%
Original Mortgage
$757,900
Interest Rate
6.95%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 2, 2017
Bought by
Valcarcel Joel

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$512,500
Interest Rate
3.94%

Purchase Details

Closed on
Nov 16, 2016
Bought by
Vlcarcel Joel and Vlcarcel Kristine

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$525,878
Interest Rate
3.57%

Purchase Details

Closed on
Oct 24, 2013
Sold by
Covington Hollow Development Llc
Bought by
Valcarcel Joel C and Valcarcel Kristine C
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
Alexander Bruce A -- Metropolitan Title Of In
Alexander Bruce A $811,000 Metropolitan Title Of In
Zirpoli Anthony J $799,900 Metropolitan Title Of In
Valcarcel Joel -- --
Vlcarcel Joel -- --
Valcarcel Joel C -- Renaissance Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Alexander Bruce A $511,000
Closed Alexander Bruce A $511,000
Previous Owner Zirpoli Anthony J $757,900
Previous Owner Valcarcel Joel C $600,000
Previous Owner Valcarcel Joel C $198,500
Previous Owner Vlcarcel Joel $512,500
Previous Owner Vlcarcel Joel --
Previous Owner Valcarcel Joel C $512,500
Previous Owner Vlcarcel Joel $525,878
Previous Owner Vlcarcel Joel --
Previous Owner Valcarcel Joel C $525,878
Previous Owner Valcarcel Joel C $559,945
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/10/2024 12/10/24 Sold $811,000 0.0% $168 / Sq Ft
11/10/2024 11/10/24 Price Changed $811,000 +0.1% $168 / Sq Ft
11/09/2024 11/09/24 Pending -- -- --
11/01/2024 11/01/24 For Sale $809,900 +1.3% $168 / Sq Ft
08/09/2024 08/09/24 Sold $799,900 0.0% $166 / Sq Ft
07/14/2024 07/14/24 Pending -- -- --
07/11/2024 07/11/24 For Sale $799,900 -- $166 / 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 $7,151 $670,400 $109,300 $561,100
2023 $7,151 $662,200 $67,400 $594,800
2022 $6,883 $631,600 $67,400 $564,200
2021 $5,712 $541,500 $67,400 $474,100
2020 $5,633 $532,200 $67,400 $464,800
2019 $5,241 $493,700 $67,400 $426,300
2018 $4,827 $453,900 $67,400 $386,500
2017 $4,472 $419,200 $67,400 $351,800
2016 $4,605 $429,700 $67,400 $362,300
2014 $2,104 $67,400 $67,400 $0
2013 $28 $900 $900 $0
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: 202442360

Indiana Regional MLS

APN: 02-11-13-154-011.000-075