Seller's Agent in 2023
Michael Hinckley
Coldwell Banker Realty
(513) 608-1886
17 in this area
344 Total Sales
517 Missouri Ave Cincinnati, OH 45226
Columbia Tusculum NeighborhoodEstimated Value: $813,000 - $902,000
3
Beds
3.5
Baths
2,804
Sq Ft
$307/Sq Ft
Est. Value
Highlights
- Transitional Architecture
- Wood Flooring
- No HOA
- Walnut Hills High School Rated A+
- Solid Surface Countertops
- Double Oven
About This Home
As of November 2023Great 10 year old home - tax abated until 2028! Open floor plan - great deep level fenced rear lawn with private terrace - hardwood floors- coiffered ceilings - stone gas fireplace - Granite & stainless kitchen w/ counter bar - finished lower level - 2nd floor laundry - study plus family room on 1st floor - E-Z to show!
Last Agent to Sell the Property
Coldwell Banker Realty License #0000261574 Listed on: 09/29/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,774
Year Built
- Built in 2013
Lot Details
- 8,102 Sq Ft Lot
- Lot Dimensions are 50 x 168
- Privacy Fence
- Wood Fence
Parking
- 2 Car Garage
- Garage Door Opener
- Driveway
Home Design
- Transitional Architecture
- Quad-Level Property
- Poured Concrete
- Shingle Roof
- Vinyl Siding
- Stone
Interior Spaces
- 2,804 Sq Ft Home
- Bookcases
- Crown Molding
- Ceiling height of 9 feet or more
- Recessed Lighting
- Chandelier
- Gas Fireplace
- Insulated Windows
- Double Hung Windows
- French Doors
- Living Room with Fireplace
- Wood Flooring
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Double Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Solid Surface Countertops
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
Outdoor Features
- Patio
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 29, 2023
Closed on
Nov 14, 2023
Sold by
Moore Revocable Trust
Bought by
Shewakramani Sanjay
Seller's Agent
Michael Hinckley
Coldwell Banker Realty
Buyer's Agent
Rick Finn
Coldwell Banker Realty
List Price
$795,000
Sold Price
$760,000
Premium/Discount to List
-$35,000
-4.4%
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
$100,233
Avg. Annual Appreciation
6.08%
Original Mortgage
$722,000
Outstanding Balance
$707,485
Interest Rate
6.75%
Mortgage Type
New Conventional
Estimated Equity
$152,748
Purchase Details
Listed on
May 17, 2019
Closed on
Jun 28, 2019
Sold by
Diedrichs Joshua D and Diedrichs Lisa J Caldemeyers
Bought by
Moore Dennis W and Moore Trude A
Seller's Agent
Michael Hinckley
Coldwell Banker Realty
Buyer's Agent
Michael Hinckley
Coldwell Banker Realty
List Price
$719,000
Sold Price
$685,000
Premium/Discount to List
-$34,000
-4.73%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.39%
Purchase Details
Closed on
Jan 16, 2014
Sold by
Black Diamond Construction Company
Bought by
Diedrichs Joshua D and Diedrichs Lisa J Caldemeyer
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$424,000
Interest Rate
3.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Listed on
Sep 26, 2012
Closed on
Jan 24, 2013
Sold by
Fannie Mae
Bought by
Black Diamond Construction Company
Seller's Agent
Kay Edwards
RE/MAX Preferred Group
Buyer's Agent
Maryann Ries
Comey & Shepherd
List Price
$144,900
Sold Price
$110,000
Premium/Discount to List
-$34,900
-24.09%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
17.27%
Purchase Details
Closed on
Sep 18, 2012
Sold by
Marx Nolan and Marx Martha
Bought by
Federal Home Loan Mortgage Corporation
Purchase Details
Closed on
Nov 22, 2010
Sold by
Marx Martha L and Marx Martha
Bought by
Marx Nolan
Purchase Details
Closed on
Jul 25, 2002
Sold by
Daniel Guigui and Daniel D
Bought by
Marx Nolan and Marx Martha
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$180,000
Interest Rate
6.64%
Purchase Details
Closed on
Jun 5, 1997
Sold by
Schifrin Kevin and Essene Paul
Bought by
Guiqui Daniel
Purchase Details
Closed on
Dec 16, 1993
Sold by
Robertson Patricia Leota
Bought by
Schifrin Kevin and Danner Kim
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$124,200
Interest Rate
7.16%
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Shewakramani Sanjay | $760,000 | None Listed On Document | |
| Moore Dennis W | $685,000 | None Available | |
| Diedrichs Joshua D | $538,694 | Attorney | |
| Black Diamond Construction Company | $110,000 | None Available | |
| Federal Home Loan Mortgage Corporation | $90,000 | None Available | |
| Marx Nolan | -- | Stonebridge Land Title | |
| Marx Nolan | $180,000 | Custom Land Title Llc | |
| Guiqui Daniel | $124,000 | -- | |
| Schifrin Kevin | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Shewakramani Sanjay | $722,000 | |
| Previous Owner | Diedrichs Joshua D | $424,000 | |
| Previous Owner | Marx Nolan | $180,000 | |
| Previous Owner | Schifrin Kevin | $124,200 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 11/20/2023 11/20/23 | Sold | $760,000 | -4.4% | $271 / Sq Ft | |
| 10/18/2023 10/18/23 | Pending | -- | -- | -- | |
| 09/29/2023 09/29/23 | For Sale | $795,000 | +16.1% | $284 / Sq Ft | |
| 09/29/2019 09/29/19 | Off Market | $685,000 | -- | -- | |
| 06/28/2019 06/28/19 | Sold | $685,000 | 0.0% | $244 / Sq Ft | View Prior Sale |
| 06/20/2019 06/20/19 | Pending | -- | -- | -- | |
| 06/10/2019 06/10/19 | Price Changed | $685,000 | -4.7% | $244 / Sq Ft | |
| 05/15/2019 05/15/19 | For Sale | $719,000 | +553.6% | $256 / Sq Ft | |
| 05/01/2013 05/01/13 | Off Market | $110,000 | -- | -- | |
| 01/28/2013 01/28/13 | Sold | $110,000 | -24.1% | $39 / Sq Ft | View Prior Sale |
| 12/21/2012 12/21/12 | Pending | -- | -- | -- | |
| 09/26/2012 09/26/12 | For Sale | $144,900 | -- | $52 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History Compared to Growth
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 | $6,393 | $247,076 | $91,693 | $155,383 |
| 2023 | $6,538 | $247,076 | $91,693 | $155,383 |
| 2022 | $6,789 | $239,750 | $37,331 | $202,419 |
| 2021 | $6,535 | $239,750 | $37,331 | $202,419 |
| 2020 | $6,726 | $239,750 | $37,331 | $202,419 |
| 2019 | $2,421 | $161,578 | $32,746 | $128,832 |
| 2018 | $2,425 | $161,578 | $32,746 | $128,832 |
| 2017 | $2,303 | $161,578 | $32,746 | $128,832 |
| 2016 | $3,457 | $188,542 | $38,500 | $150,042 |
| 2015 | $3,117 | $188,542 | $38,500 | $150,042 |
| 2014 | $10,129 | $149,517 | $38,500 | $111,017 |
| 2013 | $2,059 | $29,768 | $29,768 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Michael Hinckley
-
John Hinckley
Seller Co-Listing Agent in 2023
John Hinckley
Coldwell Banker Realty
(513) 604-1686
13 in this area
297 Total Sales
-
Rick Finn
Buyer's Agent in 2023
Rick Finn
Coldwell Banker Realty
(513) 560-6513
20 in this area
918 Total Sales
-
Kay Edwards
Seller's Agent in 2013
Kay Edwards
RE/MAX
(513) 227-3441
2 in this area
122 Total Sales
-
Leann Starks
Seller Co-Listing Agent in 2013
Leann Starks
RE/MAX
(513) 659-0022
3 in this area
142 Total Sales
-
Maryann Ries
Buyer's Agent in 2013
Maryann Ries
Comey & Shepherd
(513) 470-0564
3 in this area
101 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1785251
APN: 026-0002-0106
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 2025, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 459 Flinn Ave
- 455 Flinn Ave
- 3554 Handman Ave
- 473 Stanley Ave
- 457 Strafer St
- 536 Hoge St
- 465 Stanley Ave
- 3516 Handman Ave
- 555 Delta Ave
- 462 Stanley Ave
- 571 Delta Ave
- 575 Delta Ave
- 438 Strafer St
- 559 Delta Terrace
- 3450 Golden Ave
- 537 Tusculum Ave
- 420 Strafer St
- 3446 Golden Ave
- 550 Tusculum Ave Unit 550
- 412 Stanley Ave
- 515 Missouri Ave
- 513 Missouri Ave
- 509 Missouri Ave
- 0 Missouri Ave Unit 1466052
- 505 Missouri Ave
- 527 Missouri Ave
- 624 Rushton Rd
- 630 Rushton Rd
- 620 Rushton Rd
- 531 Missouri Ave
- 616 Rushton Rd
- 508 Missouri Ave
- 520 Missouri Ave
- 522 Missouri Ave
- 524 Missouri Ave
- 518 Missouri Ave
- 512 Missouri Ave
- 526 Missouri Ave
- 504 Missouri Ave
- 634 Rushton Rd