NOT LISTED FOR SALE

557 Indian Lake Dr Maineville, OH 45039

Hamilton Area

Estimated Value: $301,000 - $329,741

3 Beds
2.5 Baths
1,474 Sq Ft
$213/Sq Ft Est. Value

Sale Details

Date Sold: October 23, 2017

Last sale price $143,500 $97 Per Sq Ft

Est. 119% increase in value since last sale

Current estimated payment $2,050 / mo

28 Days on Market

Highlights

  • Traditional Architecture
  • Great Room
  • Walk-In Closet
  • Cathedral Ceiling
  • Solid Wood Cabinet
  • Patio

About This Home

As of October 2017

Nice Three Bedroom Two Story! Open Floor Plan w/Pergo Wood Floor Throughout 1st Floor! Large Great Room w/Cathedral Ceiling! Eat-In Kitchen! Breakfast Nook w/Walkout to Patio! 1st Floor Laundry! Large Master Suite w/Walk-In Closet & Private Master Bath! Spacious Bedrooms! Newer Roof! Fenced Backyard! Two Car Garage!

Last Agent to Sell the Property

Lawrence Beebe

Comey & Shepherd License #0000365403 Listed on: 08/08/2017

Comey & Shepherd

Co-Listed By

Jason Beebe

Comey & Shepherd License #2003012600

Last Buyer's Agent

lisa marsh

Coldwell Banker Realty License #2016000793

Coldwell Banker Realty

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,343

Year Built

  • Built in 2000

Lot Details

  • 6,098 Sq Ft Lot
  • Wood Fence

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 1,474 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Vinyl Clad Windows
  • Insulated Windows
  • Panel Doors
  • Great Room
  • Laminate Flooring

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Bathtub and Shower Combination in Primary Bathroom

Outdoor Features

  • Patio

Utilities

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

Community Details

  • Association fees include association dues
  • Indian Lake Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,343

Year Built

Built in 2000

Lot Details

6,098 Sq Ft Lot

HOA Fees

$17 per month

Parking

2

Listing Details

  • Suburb: Hamilton Twp.
  • Cross Street: Willow pond
  • Degree Complete: Completed
  • Land Description: Less than .5 Acre
  • Broker Approved: Yes
  • Miscellaneous: Cable,Ceiling Fan,Recessed Lights,Smoke Alarm,220 Volt
  • Census Tract Realist: 322.01
  • Cooling: Central Air
  • Heating: Gas, Forced Air
  • Lot Area Realist: 5981.00
  • Suburb S I C: Hamilton Twp.
  • Price Per Acre: 1025000.00
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Entry Foyer: Laminate Floor
  • Living Great Rm Dim: 22 x 15
  • Living Room Feat: Laminate Floor,Great Room
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Other
  • Year Built: 2000
  • School 1 Type: District Phone
  • Architecture: Traditional
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: N on Montgomery Rd to L on Willow Pond to R on Indian Lake
  • Lot Measurement: Acres
  • Status: Sold
  • On Market Date: 2017-08-08
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Indian Lake
  • Occupancy: Negotiable
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Multi Panel Doors, Cathedral Ceiling
  • Bedroom 2: 11x10 Level: 2
  • Bedroom 3: 10x10 Level: 2
  • Breakfast Room: 11x8 Level: 1
  • Living Room: 22x15 Level: 1
  • Formal Dining Room: No
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-899-2264
  • Semi Annual Taxes: 1171.72
  • Kitchen: 11x11 Level: 1
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • Kitchen Features: Laminate Floor,Wood Cabinets,Pantry
  • Basement: None
  • Entry: 5x5 Level: 1
  • Bathrooms: 3.00
  • Kitchen Dim: 11 x 11
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 6x5 Level: 1
  • Laundryroom Dim: 6 x 5
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1474.00
  • Windows: Insulated, Vinyl
  • First Floor Family Room: No
  • PrimaryBedroomDim: 14 x 12
  • Primary Bathrooms: Tub w/Shower
  • PrimaryBedFeat: WW Carpet,Bath Adjoins,Walk-in Closet
  • P R I M A R Y B E D R O O M: 14x12 Level: 2

Exterior Features

  • Fencing: Wood
  • Roof: Shingle
  • Construction: Vinyl Siding
  • Outside Features: Patio
  • Foundation: Slab
  • Listing Price: 149900.00
  • Acres: 0.1400
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Garage Attached,Built in
  • Parking: Driveway

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 200.00
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Inc.In HOA/Condo Fee: AssociationDues

Schools

  • District: Little Miami Local S

Lot Info

  • Lot Dimensions: Irregular
  • Lot Size Sq Ft: 6098.00
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 8, 2017
Closed on
Oct 23, 2017
Sold by
Lodewyck Philip A
Bought by
Seller's Agent
Lawrence Beebe
Comey & Shepherd
Buyer's Agent
lisa marsh
Coldwell Banker Realty
List Price
$154,900
Sold Price
$143,500
Premium/Discount to List
-$11,400
-7.36%
Current Estimated Value
$313,685

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$170,185
Avg. Annual Appreciation
9.20%
Original Mortgage
$136,300
Outstanding Balance
$111,382
Interest Rate
3.83%
Mortgage Type
New Conventional
Estimated Equity
$202,303

Purchase Details

Closed on
Jun 19, 2014
Sold by
Lodewyck Philip A and Lodewyck Clement C
Bought by
Lodewyck Philip A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$136,300
Interest Rate
3.83%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 8, 2013
Sold by
Andry Allison R and Andry Michael J
Bought by
Lodewyck Philip A and Lodewyck Clement C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$117,826
Interest Rate
4.25%
Mortgage Type
FHA

Purchase Details

Closed on
Oct 6, 2011
Sold by
Baldus Jill M
Bought by
Andry Allison R and Andry Michael J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$104,774
Interest Rate
4.4%
Mortgage Type
FHA
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Maineville, OH

  • Julie Comella Real Estate Agent - Plum Tree Realty

    Julie Comella

    Plum Tree Realty

    (513) 866-7528

    23 Total Sales

    4 in Hamilton

    $297K - $790K Price Range

    Julie Comella
     Section Image
  • Lisa Goris-May Real Estate Agent - Glasshouse Realty Group

    Lisa Goris-May

    Glasshouse Realty Group

    (937) 813-6973

    220 Total Sales

    2 in Hamilton

    $265,000 Price Range

    Lisa Goris-May
     Section Image
  • Helena Cameron Real Estate Agent - Sibcy Cline, Inc.

    Helena Cameron

    Sibcy Cline, Inc.

    (513) 952-8574

    317 Total Sales

    26 in Hamilton

    $275K - $935K Price Range

    Helena Cameron
     Section Image
  • Mark Tilford Real Estate Agent - Plum Tree Realty

    Mark Tilford

    Plum Tree Realty

    (513) 586-2830

    24 Total Sales

    1 in Hamilton

    $425,000 Price

    Mark Tilford
     Section Image
  • Brandy Mccaster Real Estate Agent - Keller Williams Seven Hills Re

    Brandy Mccaster

    Keller Williams Seven Hills Re

    (513) 993-4223

    116 Total Sales

    2 in Hamilton

    $332K - $368K Price Range

    Brandy Mccaster
     Section Image
  • Erin Laurito Real Estate Agent - BHHS Professional Realty

    Erin Laurito

    BHHS Professional Realty

    (937) 930-4786

    80 Total Sales

    2 in Hamilton

    $695,000 Price Range

    Erin Laurito
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$144,000 --
Lodewyck Philip A -- --
Lodewyck Philip A -- Prodigy Title Agency Llc
Andry Allison R $107,500 Prodigy
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $136,300
Previous Owner Lodewyck Philip A $136,300
Previous Owner Lodewyck Philip A $117,826
Previous Owner Andry Allison R $104,774
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
01/21/2018 01/21/18 Off Market $143,500 -- --
10/23/2017 10/23/17 Sold $143,500 -4.3% $97 / Sq Ft
09/05/2017 09/05/17 Pending -- -- --
08/31/2017 08/31/17 Price Changed $149,900 -3.2% $102 / Sq Ft
08/08/2017 08/08/17 For Sale $154,900 -- $105 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $3,625 $81,180 $29,750 $51,430
2024 $3,626 $81,180 $29,750 $51,430
2023 $3,036 $60,567 $15,067 $45,500
2022 $2,998 $60,568 $15,068 $45,500
2021 $2,859 $60,568 $15,068 $45,500
2020 $2,723 $49,242 $12,250 $36,992
2019 $2,768 $49,242 $12,250 $36,992
2018 $2,682 $49,242 $12,250 $36,992
2017 $2,301 $41,916 $10,584 $31,332
2016 $2,355 $41,916 $10,584 $31,332
2015 $2,354 $41,916 $10,584 $31,332
2014 $2,488 $39,170 $9,890 $29,280
2013 $2,418 $48,510 $12,250 $36,260
Source: Public Records

Agents Affiliated with this Home

  • Lawrence Beebe Real Estate Agent - Comey & Shepherd

    Seller's Agent in 2017

    Lawrence Beebe

    Comey & Shepherd

    (513) 290-6663

    197 Total Sales

    Lawrence Beebe
    Section Image
  • Jason Beebe Real Estate Agent - Comey & Shepherd

    Seller Co-Listing Agent in 2017

    Jason Beebe

    Comey & Shepherd

    (513) 850-1647

    218 Total Sales

    Jason Beebe
    Section Image

  • LM

    Buyer's Agent in 2017

    lisa marsh

    Coldwell Banker Realty

    Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1549076

MLS of Greater Cincinnati (CincyMLS)

APN: 16-05-335-008

Ohio Warren County Maineville 45039

557 Indian Lake Dr, Maineville, OH

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLS of Greater Cincinnati (CincyMLS) The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.