Robert Smith
Coldwell Banker Realty
(513) 599-1654
325 Total Sales
2 in Mount Auburn
$100K - $225K Price Range
542 Milton St Cincinnati, OH 45202
Mount Auburn NeighborhoodEstimated Value: $799,916
3
Beds
3.5
Baths
3,104
Sq Ft
$258/Sq Ft
Est. Value
Highlights
- City View
- Living Room with Fireplace
- No HOA
- Deck
- Wood Flooring
- Formal Dining Room
About This Home
As of September 2024Stunning home in historic Prospect Hill. Meticulously maintained and renovated with nothing to do but move right in. Kitchen features granite counter tops, stainless steel/high end appliances, beverage center and counter bar. Updated bathrooms w/ steam shower. Incredible city views from the roof top deck. 10ft ceilings . Private backyard oasis with new bluestone patio, rear turf lawn, waterfall feature, and tiered gardens. Off street parking for 2 cars. Lower level could be used as guest suite.
Last Agent to Sell the Property
Coldwell Banker Realty License #0000261574 Listed on: 08/08/2024
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
- $8,976
Year Built
- Built in 1880
Lot Details
- 2,483 Sq Ft Lot
- Privacy Fence
- Historic Home
Home Design
- Brick Exterior Construction
- Stone Foundation
- Shingle Roof
Interior Spaces
- 3,104 Sq Ft Home
- 3-Story Property
- Bookcases
- Crown Molding
- Ceiling height of 9 feet or more
- Chandelier
- Non-Functioning Fireplace
- Insulated Windows
- Panel Doors
- Family Room
- Living Room with Fireplace
- 3 Fireplaces
- Formal Dining Room
- Wood Flooring
- City Views
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Wine Cooler
- Kitchen Island
- Solid Wood Cabinet
Bedrooms and Bathrooms
- 3 Bedrooms
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Parking
- Off-Street Parking
- Assigned Parking
Outdoor Features
- Balcony
- Deck
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
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, 2024
Closed on
Sep 17, 2024
Sold by
Bought by
Seller's Agent
Michael Hinckley
Coldwell Banker Realty
Buyer's Agent
Jonathan Amster
Comey & Shepherd
List Price
$819,000
Sold Price
$825,000
Premium/Discount to List
$6,000
0.73%
Views
6
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$25,084
Avg. Annual Appreciation
-1.63%
Original Mortgage
$660,000
Outstanding Balance
$608,443
Interest Rate
5.63%
Mortgage Type
New Conventional
Estimated Equity
$191,473
Purchase Details
Listed on
Aug 27, 2015
Closed on
Sep 28, 2015
Sold by
Bought by
Seller's Agent
Anne Cavellier
Keller Williams Advisors
Buyer's Agent
Cathy Frank
Comey & Shepherd
List Price
$375,000
Sold Price
$352,000
Premium/Discount to List
-$23,000
-6.13%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.95%
Original Mortgage
$316,800
Interest Rate
3.84%
Mortgage Type
Unknown
Purchase Details
Listed on
Jul 3, 2011
Closed on
Feb 8, 2012
Sold by
Bought by
Seller's Agent
Christine Schoonover
Sibcy Cline, Inc.
Buyer's Agent
Anne Cavellier
Keller Williams Advisors
List Price
$295,000
Sold Price
$250,000
Premium/Discount to List
-$45,000
-15.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
9.86%
Original Mortgage
$200,000
Interest Rate
3.91%
Mortgage Type
New Conventional
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Auburn, OH
-
Robert Smith
-
Cindy Shetterly
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
528 Total Sales
2 in Mount Auburn
$105K - $172K Price Range
-
Kristine Green
Kristine Green
Coldwell Banker Realty
(513) 440-3058
25 Total Sales
1 in Mount Auburn
$292,500 Price
-
Wendi Sheets
Wendi Sheets
eXp Realty
(513) 813-1446
215 Total Sales
1 in Mount Auburn
$750,000 Price
-
Beth Silber
Beth Silber
Coldwell Banker Realty
(513) 650-7552
241 Total Sales
5 in Mount Auburn
$176K - $560K Price Range
-
Michael Tekulve
Michael Tekulve
TREO REALTORS
(513) 650-6460
64 Total Sales
2 in Mount Auburn
$325K - $430K Price Range
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 |
|---|---|---|---|
| $825,000 | Nationwide Title Clearing (Ntc | ||
| $352,000 | Attorney | ||
| $250,000 | Ltoc |
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 | $660,000 | ||
| Previous Owner | $280,000 | ||
| Previous Owner | $316,800 | ||
| Previous Owner | $200,000 | ||
| Previous Owner | $102,300 | ||
| Previous Owner | $109,000 |
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 | Prior Sale |
|---|---|---|---|---|---|
| 09/16/2024 09/16/24 | Sold | $825,000 | +0.7% | $266 / Sq Ft | |
| 08/11/2024 08/11/24 | Pending | -- | -- | -- | |
| 08/08/2024 08/08/24 | For Sale | $819,000 | +132.7% | $264 / Sq Ft | |
| 12/27/2015 12/27/15 | Off Market | $352,000 | -- | -- | |
| 09/28/2015 09/28/15 | Sold | $352,000 | -6.1% | $103 / Sq Ft | View Prior Sale |
| 08/31/2015 08/31/15 | Pending | -- | -- | -- | |
| 08/27/2015 08/27/15 | For Sale | $375,000 | +50.0% | $109 / Sq Ft | |
| 05/08/2012 05/08/12 | Off Market | $250,000 | -- | -- | |
| 02/08/2012 02/08/12 | Sold | $250,000 | -15.3% | $73 / Sq Ft | View Prior Sale |
| 12/14/2011 12/14/11 | Pending | -- | -- | -- | |
| 07/03/2011 07/03/11 | For Sale | $295,000 | -- | $86 / 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 | $11,309 | $192,003 | $44,275 | $147,728 |
| 2024 | $8,790 | $192,003 | $44,275 | $147,728 |
| 2023 | $8,989 | $192,003 | $44,275 | $147,728 |
| 2022 | $8,555 | $167,819 | $28,781 | $139,038 |
| 2021 | $8,236 | $167,819 | $28,781 | $139,038 |
| 2020 | $8,994 | $167,819 | $28,781 | $139,038 |
| 2019 | $7,563 | $129,091 | $22,138 | $106,953 |
| 2018 | $7,575 | $123,201 | $22,138 | $101,063 |
| 2017 | $6,937 | $123,201 | $22,138 | $101,063 |
| 2016 | $6,222 | $88,449 | $12,880 | $75,569 |
| 2015 | $5,609 | $88,449 | $12,880 | $75,569 |
| 2014 | $5,649 | $87,500 | $12,880 | $74,620 |
| 2013 | $5,748 | $87,500 | $12,880 | $74,620 |
Source: Public Records
Agents Affiliated with this Home
-
Michael Hinckley
Seller's Agent in 2024
Michael Hinckley
Coldwell Banker Realty
(513) 608-1886
2 in this area
318 Total Sales
-
John Hinckley
Seller Co-Listing Agent in 2024
John Hinckley
Coldwell Banker Realty
(513) 604-1686
2 in this area
300 Total Sales
-
Jonathan Amster
Buyer's Agent in 2024
Jonathan Amster
Comey & Shepherd
(513) 307-3937
1 in this area
86 Total Sales
-
Anne Cavellier
Seller's Agent in 2015
Anne Cavellier
Keller Williams Advisors
(513) 505-9633
26 Total Sales
-
Cathy Frank
Buyer's Agent in 2015
Cathy Frank
Comey & Shepherd
(513) 241-3400
2 in this area
16 Total Sales
-
C
Seller's Agent in 2012
Christine Schoonover
Sibcy Cline
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1813267
APN: 086-0001-0078
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.
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
- 525 Boal St Unit 525
- 561 Milton St
- 548 Liberty Hill
- 510 Corporation Aly
- 540 Slack St
- 546 Slack St
- 420 Boal St
- 435 Milton St
- 412 Liberty Hill Unit 1d
- 412 Liberty Hill
- 336 Boal St
- 1316 Spring St
- 1312 Spring St
- 330 Boal St
- 331 Milton St
- 320 E 14th St
- 1619 Mansfield St
- 1931 Bigelow St
- 1938 Bigelow St
- 1940 Bigelow St
Your Personal Tour Guide
Ask me questions while you tour the home.