Save
Ask
Tour
Hide
Share
$569,900
28 Days On Site

1797 Sycamore Street
Cincinnati, OH 45202

Single Family Residence|Pending
3
Beds
3
Total Baths
2
Full Baths
1
Partial Bath
2,320
SqFt
$246
/SqFt
2006
Built
County:
Hamilton
Listing courtesy of M. Doug Spitz of Coldwell Banker Realty

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

1797 Sycamore Street1797 Sycamore Street1797 Sycamore Street1797 Sycamore Street
Save
Ask
Tour
Hide
Share

Perched above downtown, Prospect Hill blends historic charm w/ unbeatable urban access. Tucked between Mount Auburn and Over-the-Rhine, this hillside neighborhood offers a quiet, residential feel just minutes from the city's core. This home features 2 ensuite bedrooms, plus a 3rd-floor bedroom or flexible bonus space, a 2-car tandem garage, rooftop deck with city views, and a backyard patio oasis great for entertaining. Your extended community includes OTR, offering vibrant dining, coffee shops, boutiques, and Findlay Market, creating a welcoming, connected lifestyle in one of Cincinnati's most character-rich neighborhoods. Take a short drive to downtown's business district, major employers, and top entertainment venues, including Great American Ball Park, Paycor Stadium, and TQL Stadium. Located near UC Medical Center and Cincinnati Children's, this home offers a seamless commute with quick connections to I-71, I-75, and Columbia Parkway.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$569,900
Days On Site 
28 Days
Bedrooms 
3
Inside Area (SqFt) 
2,320 sqft
Total Baths 
3
Full Baths 
2
Partial Baths 
1
Lot Size 
0.055 Acres
Year Built 
2006
MLS® Number 
1879459
Status 
Pending
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
4 weeks agoListing updated with changes from the MLS®
4 weeks agoStatus changed to Pending
4 weeks agoListing first seen on site
General Features
Acres 
0.055
Garage 
Yes
Garage Spaces 
2
Levels 
Three Or More
Parking 
Driveway
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
Style 
Transitional
Utilities 
Natural Gas Available
Water Source 
Public
Zoning 
Residential
Interior Features
Appliances 
DisposalRangeOvenGas Water HeaterMicrowaveRefrigerator
Basement 
Full
Cooling 
Ceiling Fan(s)Central Air
Fireplace 
Yes
Fireplace Features 
Living RoomStoneGas
Fireplaces 
1
Heating 
Natural GasForced AirZoned
Interior 
Kitchen IslandWalk-In Closet(s)Other
Window Features 
Insulated Windows
Bathroom 1 
Level - Second
Bathroom 2 
Level - Second
Bathroom 3 
Level - First
Bedroom 2 
Dimensions - 13 x 13Level - SecondArea - 169
Bedroom 3 
Dimensions - 19 x 22Level - ThirdArea - 418
Dining Room 
Dimensions - 12 x 14Level - FirstArea - 168
Kitchen 
Dimensions - 11 x 11Area - 121
LaundryRoom 
Dimensions - 5 x 4Level - SecondArea - 20
Living Room 
Dimensions - 14 x 17Area - 238
Master Bedroom 
Dimensions - 19 x 18Level - SecondArea - 342
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Brick
Lot Features 
Sloped
Patio And Porch 
DeckPatio
Roof 
ShingleMembrane
View 
City
Waterview 
City
Windows/Doors 
Insulated Windows
Community Features
MLS Area 
Hamilton-E01
School District 
Cincinnati City SD
Township 
Cincinnati City
Schools
School District
Cincinnati City SD
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of M. Doug Spitz of Coldwell Banker Realty



Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-06-13 11:28 AM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share