Mika Walker
Coldwell Banker Realty
(513) 854-2223
75 Total Sales
1 in Mount Airy
$165,000 Price
5246 Shepherd Rd Cincinnati, OH 45223
Mount Airy Neighborhood
2
Beds
1
Bath
1,350
Sq Ft
1953
Built
Highlights
- View of Trees or Woods
- Ranch Style House
- Wood Flooring
- Walnut Hills High School Rated A+
- Partially Wooded Lot
- No HOA
About This Home
As of September 2026Beautifully secluded raised ranch nestled on a private, park-like setting adjacent to Mount Airy Forest! This charming home features hardwood floors, natural woodwork, spacious open living areas, & a cozy fireplace perfect for relaxing winter nights. Enjoy your morning coffee on the large front porch, then entertain or unwind on the private patio overlooking the tranquil, beautifully landscaped backyard. The lower level offers endless potential to create additional living space, a recreation room, home office, or guest suite. Just steps from Mount Airy Forest, this home is ideal for nature lovers, hikers, & outdoor enthusiasts seeking privacy without sacrificing convenience. Thoughtfully designed landscaping enhances the peaceful atmosphere & creates your own private retreat. Conveniently located minutes from Northside, Downtown Cincinnati, & Clifton, with easy access to shopping, dining, entertainment, & major highways. Don't miss the opportunity to make this hidden gem yours!!
Last Agent to Sell the Property
Keller Williams Advisors License #2009004570 Listed on: 07/15/2026
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,940
Year Built
- Built in 1953
Lot Details
- Sloped Lot
- Partially Wooded Lot
Parking
- 1 Car Garage
- Front Facing Garage
- Garage Door Opener
- Driveway
Property Views
- Woods
- Park or Greenbelt
Home Design
- Ranch Style House
- Block Foundation
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 1,350 Sq Ft Home
- Woodwork
- Double Pane Windows
- Vinyl Clad Windows
- French Doors
- Living Room with Fireplace
- Storage In Attic
- Fire and Smoke Detector
- Oven or Range
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 2 Bedrooms
- 1 Full Bathroom
- Bathtub and Shower Combination in Primary Bathroom
Partially Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Patio
- Fire Pit
- Porch
Location
- Property is near bus stop
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
- Septic Tank
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
Apr 24, 2018
Closed on
Jun 15, 2018
Sold by
Dunphy Brandon M and Dunphy Terri
Bought by
Seller's Agent
Constance Juillerat
Sibcy Cline, Inc.
Buyer's Agent
Mary Jo Hoffman
Comey & Shepherd
List Price
$115,000
Sold Price
$115,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.41%
Original Mortgage
$111,550
Interest Rate
4.5%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 14, 2000
Sold by
Schmelzer Alexis M and Schmelzer Alexis M
Bought by
Dunphy Brandon M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$84,956
Interest Rate
8.31%
Mortgage Type
FHA
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Airy, OH
-
Mika Walker
-
Lori Williams
Lori Williams
Lohmiller Real Estate
(513) 854-1258
91 Total Sales
1 in Mount Airy
$170,000 Price
-
Barry Bates
Barry Bates
Coldwell Banker Realty
(513) 993-6141
139 Total Sales
3 in Mount Airy
$258K - $290K Price Range
-
Richard Davey
Richard Davey
Comey & Shepherd
(513) 586-2995
279 Total Sales
1 in Mount Airy
$320,000 Price
-
Chhabi Neopaney
Chhabi Neopaney
Key Realty, LTD.
(513) 953-4109
129 Total Sales
1 in Mount Airy
$230,000 Price
-
Vernon Duett
Vernon Duett
Responds QuicklyHand In Hand Realty, LLC
(513) 572-7877
91 Total Sales
3 in Mount Airy
$199K - $251K 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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $115,000 | None Available | |
| Warranty Deed | $85,000 | Vintage Title Agency Inc |
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 | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $111,000 | New Conventional | |
| Closed | $111,550 | New Conventional | |
| Previous Owner | $84,956 | FHA |
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/08/2026 09/08/26 | Sold | $210,000 | 0.0% | $156 / Sq Ft | |
| 08/06/2026 08/06/26 | Pending | -- | -- | -- | |
| 07/15/2026 07/15/26 | For Sale | $209,900 | +82.5% | $155 / Sq Ft | |
| 09/13/2018 09/13/18 | Off Market | $115,000 | -- | -- | |
| 06/15/2018 06/15/18 | Sold | $115,000 | 0.0% | $105 / Sq Ft | View Prior Sale |
| 05/06/2018 05/06/18 | Pending | -- | -- | -- | |
| 04/24/2018 04/24/18 | For Sale | $115,000 | -- | $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 | $2,942 | $47,877 | $12,499 | $35,378 |
| 2024 | $2,852 | $47,877 | $12,499 | $35,378 |
| 2023 | $2,917 | $47,877 | $12,499 | $35,378 |
| 2022 | $2,769 | $40,779 | $10,308 | $30,471 |
| 2021 | $2,633 | $40,251 | $10,308 | $29,943 |
| 2020 | $2,710 | $40,251 | $10,308 | $29,943 |
| 2019 | $1,779 | $23,958 | $8,887 | $15,071 |
| 2018 | $1,782 | $23,958 | $8,887 | $15,071 |
| 2017 | $1,692 | $23,958 | $8,887 | $15,071 |
| 2016 | $2,024 | $28,298 | $9,730 | $18,568 |
| 2015 | $1,826 | $28,298 | $9,730 | $18,568 |
| 2014 | $1,839 | $28,298 | $9,730 | $18,568 |
| 2013 | $2,032 | $30,758 | $10,577 | $20,181 |
Source: Public Records
Agents Affiliated with this Home
-
Ben Austin
Seller's Agent in 2026
Ben Austin
Keller Williams Advisors
(513) 706-3159
1 in this area
156 Total Sales
-
Constance Juillerat
Seller's Agent in 2018
Constance Juillerat
Sibcy Cline
(513) 377-4498
48 Total Sales
-
Mary Jo Hoffman
Buyer's Agent in 2018
Mary Jo Hoffman
Comey & Shepherd
(513) 235-6067
116 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1886947
APN: 227-0001-0076
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
- 5360 Colerain Ave
- 2717 W North Bend Rd
- 5406 Bluebird Ln
- 2661 Hummingbird Ct
- 2442 Elderberry Ct
- 5418 Scarletoak Dr Unit 22G
- 2433 Elderberry Ct Unit 19E
- 5612 Colerain Ave
- 2936 N Bend Rd
- 2612 Kathleen Ct
- 5631 Colerain Ave
- 5369 Edger Dr
- 5645 Colerain Ave
- 5557 Fairwood Rd
- 5682 Colerain Ave
- 5592 Regimental Place
- 2830 Orchardpark Dr
- 5928 Thornhill Ave
- 5594 Sunnywoods Ln
- 2818 Orchardpark Dr
Your Personal Tour Guide
Ask me questions while you tour the home.