$900,000
SOLD JUL 24, 2025
5 Beds
3.5 Baths
6,875 Sq Ft
$150/mo HOA Fee

Recently Sold

$131 Per Sq Ft

10% Below List Price

70 Days on Market

Highlights

  • Golf Course Community
  • Primary Bedroom Suite
  • Open Floorplan
  • Homestead Senior High School Rated A
  • Golf Course View
  • Fireplace in Bedroom

About This Home

As of July 2025

This beautiful 5-bedroom, 3.5-bathroom home offers luxury and comfort with an ideal location on the Sycamore Hills Golf Course. The main-level primary suite provides privacy, while the spacious great room features large windows that flood the space with natural light and offer stunning views. The chef’s kitchen is perfect for cooking and entertaining, and a partially finished basement adds additional living space. The expansive back patio is ideal for outdoor relaxation, with serene views of the golf course. With ample storage throughout, including large closets and extra spaces, staying organized is easy. The 3-car garage provides plenty of room for vehicles and additional storage. Situated in the highly sought-after Southwest Allen County School District, this home perfectly blends luxury, convenience, and an exceptional location. Don’t miss the opportunity to make this remarkable property your own!

Last Agent to Sell the Property

Jamie Dubes

Noll Team Real Estate Listed on: 02/27/2025

Last Buyer's Agent

Shellie Friend

Coldwell Banker Real Estate Group

Coldwell Banker Real Estate Group

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $17,880

Year Built

  • Built in 1997

Lot Details

  • Backs to Open Ground
  • Cul-De-Sac
  • Landscaped
  • Irrigation

HOA Fees

  • $150 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Asphalt Roof
  • Stone Exterior Construction
  • Cement Board or Planked

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Skylights
  • Self Contained Fireplace Unit Or Insert
  • Double Pane Windows
  • Pocket Doors
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Formal Dining Room
  • Golf Course Views
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Walk-In Pantry
  • Electric Oven or Range
  • Kitchen Island
  • Ceramic Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Double Vanity
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Attic

  • Storage In Attic
  • Walkup Attic
  • Pull Down Stairs to Attic

Finished Basement

  • Sump Pump
  • Natural lighting in basement

Outdoor Features

  • Balcony
  • Patio
  • Porch

Location

  • Suburban Location

Schools

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

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • ENERGY STAR Qualified Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 02-11-10-152-003.000-075

Community Details

Overview

  • Sycamore Hill Subdivision

Recreation

  • Golf Course Community
  • Community Pool

Security

  • Security Service
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Property Details

Home Type

Condominium

Est. Annual Taxes

$17,880

Year Built

Built in 1997

Lot Details

0

HOA Fees

$150 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Condo/Villa
  • Year Built: 1997
  • Age: 28
  • Style: Two Story
  • Architectural Style: Traditional
  • Total Number of Rooms: 10
  • Bedrooms: 5
  • Number Above Grade Bedrooms: 5
  • Total Bathrooms: 4
  • Total Full Bathrooms: 3
  • Total Number of Half Bathrooms: 1
  • Legal Description: SYCAMORE HILLS SEC III LOT 73
  • Parcel Number ID: 02-11-10-152-003.000-075
  • Platted: Yes
  • Amenities: Alarm System-Security, Attic Pull Down Stairs, Attic Storage, Attic-Walk-up, Balcony, Bar, Built-In Speaker System, Built-In Bookcase, Built-in Desk, Cable Available, Cable Ready, Ceiling-9+, Ceiling Fan(s), Ceilings-Beamed, Closet(s) Walk-in, Countertops-Ceramic, Crown Molding, Detector-Carbon Monoxide, Detector-Smoke, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Foyer Entry, Garage Door Opener, Irrigation System, Kitchen Island, Landscaped, Natural Woodwork, Near Walking Trail, Open Floor Plan, Pantry-Walk In, Patio Open, Pocket Doors, Porch Open, Range/Oven Hook Up Elec, Six Panel Doors, Skylight(s), Twin Sink Vanity, Utility Sink, Wet Bar, Wiring-Security System, Alarm System-Sec. Cameras, Stand Up Shower, Tub/Shower Combination, Main Level Bedroom Suite, Formal Dining Room, Great Room, Main Floor Laundry, Sump Pump, Washer Hook-Up, Custom Cabinetry, Jack & Jill Bath
  • Location: City/Town/Suburb, Near Walking Trail
  • Sp Lp Percent: 90.01
  • Year Taxes Payable: 2025
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 7239
  • Total Finished Sq Ft: 6875
  • Above Grade Finished Sq Ft: 6375
  • Below Grade Finished Sq Ft: 500
  • Below Grade Sq Ft: 364
  • Price Per Sq Ft: 141.18
  • Basement: Yes
  • Basement Foundation: Daylight, Partial Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 3
  • Fireplace: Family Rm, Living/Great Rm, 1st Bdrm, Fireplace Insert, Vented
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Carpet, Vinyl
  • Living Great Room: Dimensions: 25x19, On Level: Main
  • Kitchen: Dimensions: 21x15, On Level: Main
  • Dining Room: Dimensions: 17x16, On Level: Main
  • Family Room: Dimensions: 21x19, On Level: Main
  • Den: Dimensions: 16x15, On Level: Main
  • Bedroom 1: Dimensions: 20x15, On Level: Main
  • Bedroom 2: Dimensions: 17x13, On Level: Upper
  • Bedroom 3: Dimensions: 19x14, On Level: Upper
  • Bedroom 4: Dimensions: 17x16, On Level: Upper
  • Bedroom 5: Dimensions: 14x13, On Level: Upper
  • Number of Main Level Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 864

Exterior Features

  • Exterior: Stone, Cement Board
  • Roof Material: Asphalt
  • Outbuilding1: None

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 26x25
  • Garage Sq Ft: 650
  • Garage: Yes

Utilities

  • Cooling: Central Air, Multiple Cooling Units
  • Heating Fuel: Gas, Conventional, Multiple Heating Systems
  • Sewer: City
  • Water Utilities: City
  • Electric Company: AEP/I&M
  • Gas Company: NIPSCO
  • Water Company: Aqua America
  • Cable Company: Comcast/Xfinity
  • Hvac: Ceiling Fan, Zoned Air Condtioning, Zoned Heating
  • Laundry: Dimensions: Mainx10, On Level: 12

Condo/Co-op/Association

  • Association Fees: 450
  • Association Fees Frequency: Quarterly
  • Common Amenities: Cable TV Antenna, Golf Course, Security, Swimming Pool, Tennis Courts

Schools

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

Green Features

  • Energy Efficient: Water Heater
  • Energy Efficient Windows/Doors: Double Pane Windows

Lot Info

  • Lot Description: Cul-De-Sac, Golf Frontage
  • Lot Dimensions: 122x133x102x131

Tax Info

  • Annual Taxes: 17880.36

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
Feb 27, 2025
Closed on
Jul 21, 2025
Sold by
Stein David
Bought by
Hardwick Mark and Hardwick Catherine
Seller's Agent
Jamie Dubes
Noll Team Real Estate
Buyer's Agent
Shellie Friend
Coldwell Banker Real Estate Group
List Price
$999,900
Sold Price
$900,000
Premium/Discount to List
-$99,900
-9.99%
Views
74

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
22.42%
Original Mortgage
$450,000
Outstanding Balance
$446,890
Interest Rate
5.97%
Mortgage Type
New Conventional
Estimated Equity
$495,977

Purchase Details

Closed on
Aug 3, 2017
Sold by
Stein Marilyn
Bought by
Stein David

Purchase Details

Listed on
Mar 16, 2012
Closed on
Sep 19, 2012
Sold by
Jpmorgan Chase Bank Na
Bought by
Stein David and Stein Marilyn
Seller's Agent
Bette Sue Rowe
Coldwell Banker Real Estate Gr
Buyer's Agent
Carlye Baenen
Coldwell Banker Real Estate Gr
List Price
$545,000
Sold Price
$465,000
Premium/Discount to List
-$80,000
-14.68%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.56%

Purchase Details

Closed on
Oct 21, 2005
Sold by
Doermer Richard T
Bought by
Doermer Richard T and Doermer Family Trust
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 Type Sale Price Title Company
Warranty Deed -- Near North Title Group
Interfamily Deed Transfer -- None Available
Trustee Deed -- Renaissance Title
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $450,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/24/2025 07/24/25 Sold $900,000 -10.0% $131 / Sq Ft
05/08/2025 05/08/25 Pending -- -- --
02/27/2025 02/27/25 For Sale $999,900 +115.0% $145 / Sq Ft
09/21/2012 09/21/12 Sold $465,000 -14.7% $70 / Sq Ft View Prior Sale
08/22/2012 08/22/12 Pending -- -- --
03/16/2012 03/16/12 For Sale $545,000 -- $82 / 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 $17,880 $804,200 $118,400 $685,800
2023 $17,880 $834,400 $118,400 $716,000
2022 $14,648 $681,300 $94,700 $586,600
2021 $13,397 $640,100 $94,700 $545,400
2020 $12,669 $603,500 $94,700 $508,800
2019 $12,487 $593,100 $94,700 $498,400
2018 $11,636 $551,600 $94,700 $456,900
2017 $5,947 $556,000 $94,700 $461,300
2016 $5,980 $556,700 $94,700 $462,000
2014 $5,534 $518,800 $95,600 $423,200
2013 $5,061 $471,900 $95,600 $376,300
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: 202506067

Indiana Regional MLS

APN: 02-11-10-152-003.000-075