Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$585,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1 Partial Bath
  • 2,320 Sq. Ft.
  • 0.055 Acres
  • 2 Car Garage
  • Updated 8 hours ago
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 1797 Sycamore St

General

  • Price: $585,000
  • Status: Active
  • Type: Single Family
  • Source: Cincinnati
  • MLS ID: 1873884
  • Updated: 4/8/2026
  • Added to Site: 6 day(s) ago

Interior

  • Number of Rooms: 6
  • Rooms/Areas: Media Room, Bedroom
  • Interior Features: High Ceiling (9 Feet or More), French Doors, Other
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Stone, Gas
  • Appliances: Garbage Disposal, Microwave, Oven/Range, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Primary Bathroom: Built-In Shower Seat, Shower, Double Vanity, Jetted Tub, Marb/Gran/Slate
  • Bathroom 1: Full, Level 2
  • Bathroom 2: Full, Level 2
  • Bathroom 3: Partial, Level 1

Bedrooms

  • Total Bedrooms: 3
  • Primary Bedroom: Adjoining Bathroom, Walk-In Closet, Wall-to-Wall Carpet, 19 x 18, Level 2, 342 Sq. Ft.
  • Bedroom 2: 13 x 13, Level 2, 169 Sq. Ft.
  • Bedroom 3: 19 x 22, Level 3, 418 Sq. Ft.

Other Rooms

  • Living Room: Fireplace, Wood Floor, 14 x 17, Level 1, 238 Sq. Ft.
  • Kitchen: Counter Bar, Walk-Out, Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate, 11 x 11, 11x11, 121 Sq. Ft.
  • Dining Room: Chandelier, Wood Floor, 12 x 14, Level 1, 168 Sq. Ft.
  • Laundry: 5 x 4, Level 2, 20 Sq. Ft.

Additional Information

  • Other Features: Bus Line Nearby, Ceiling Fan, Recessed Lights, Other

Exterior

  • Exterior Features: Deck, Patio, Yard Lights

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking: Driveway
  • Garage Description: Built-In, Tandem

Location

  • Area: Mt. Auburn
  • County: Hamilton
  • Township: Cincinnati City
  • Suburb: Mt. Auburn
  • Driving Directions: E. Liberty to Sycamore

School Information

  • School District: Cincinnati City SD
  • High School District: Cincinnati City SD

Community

  • Home Owners Assn.: False

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Forced Air, Gas, Zoned
  • Heating Fuel: Natural
  • Water Heater: Gas

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Three Story Transitional
  • Description/Design: Single Family
  • Exterior Const.: Brick
  • Basement: Yes
  • Basement Desc.: Full, Concrete Floor, Other
  • Foundation: Poured
  • Roof: Shingle, Membrane
  • Windows: Double-Hung, Double Pane, Insulated
  • Stories/Levels: Three
  • Square Feet: 2,320
  • Year Built: 2006

Lot Features

  • Property View: City
  • Lot Size (Acres): 0.055
  • Frontage: City Street
  • Topography: Sloped
  • Zoning: Residential
  • Lot Description: Less than .5 Acre
  • Fencing (Description): Metal

Financial Considerations

  • Semi-Annual Taxes: $4835

Disclosures and Reports

  • APN: 094-0006-0279-00
Buyer's Brokerage Compensation: Contact Listing Agent
Not binding unless confirmed by separate agreement among applicable parties.

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Meet the listing agent

Meet the listing agent
— 1797 Sycamore St —

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 1797 Sycamore St

School District:Cincinnati City School District
NameGradesDistance
Rothenberg Preparatory Academy
241 East Clifton Avenue, Cincinnati, OH 45202
PK-60.2 mi
Walnut Hills High School
3250 Victory Parkway, Cincinnati, OH 45207
7-122.3 mi
Withrow University High School
2488 Madison Road, Cincinnati, OH 45208
7-123.5 mi
Robert A. Taft Information Technology High School
420 Ezzard Charles Drive, Cincinnati, OH 45214
7-120.9 mi
Hughes STEM High School
2515 Clifton Avenue, Cincinnati, OH 45219
7-121 mi
Clark Montessori High School
3030 Erie Avenue, Cincinnati, OH 45208
7-124.7 mi
Riverview East Academy
3555 Kellogg Avenue, Cincinnati, OH 45226
9-123.7 mi
Woodward Career Technical High School
7005 Reading Road, Cincinnati, OH 45237
7-125.5 mi
Aiken New Tech High School
5641 Belmont Avenue, Cincinnati, OH 45224
7-125.6 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 1797 Sycamore St Get Price Alerts and Save Property

Date
Details
Price
Change
Source
4/08/2026
Listed
$585,000
8.84%
MLS
10/17/2023
Sold
$537,500
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 1797 Sycamore St

Year
Property Taxes
Change
Tax Assessment
Change
2025
$9,670
3%
$157,255
—
2024
$9,375
-2%
$157,255
—
2023
$9,588
-14%
$157,255
-4%
2022
$11,177
1%
$164,465
—
2021
$11,079
—
$164,465
—
2020
$11,079
36%
$164,465
49%
2019
$8,132
—
$110,432
—
2018
$8,145
5%
$110,432
—
2017
$7,738
469%
$110,432
10%
2016
$1,360
11%
$100,216
—
2015
$1,226
-1%
$100,216
—
2014
$1,235
7%
$100,216
9%
2013
$1,152
—
$91,942
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 1797 Sycamore St

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Similar Properties near 1797 Sycamore St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

112 Ward Ave, Bellevue, KY 41073 - Photo 1 Price Reduced
-$5,100 (-0.86%)
$589,900

112 Ward Ave  Bellevue, KY 41073

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 3
    Total Baths
3121 Hackberry St, Cincinnati, OH 45207 - Photo 1
$595,000

3121 Hackberry St  Cincinnati, OH 45207

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,960
    Sq. Ft.
Listed by Patrick Gunning (513) 300-6929
3129 Hackberry St, Cincinnati, OH 45207 - Photo 1
$599,000

3129 Hackberry St  Cincinnati, OH 45207

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,334
    Sq. Ft.
Listed by Draznik Group (513) 616-0409
4614 Simpson Ave, Cincinnati, OH 45227 - Photo 1
$575,000

4614 Simpson Ave  Cincinnati, OH 45227

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,959
    Sq. Ft.
Listed by The LIVIN IN CIN Experience (513) 957-3019

Just Listed near 1797 Sycamore St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

105 W 13th St, Newport, KY 41071 - Photo 1 Just Listed
$645,000
Open House

105 W 13th St  #10  Newport, KY 41071

  • Townhouse
  • Active
  • Updated 7 hours ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,384
    Sq. Ft.
Listed by Patrick Gunning (513) 300-6929
199 Grandview Ave, Newport, KY 41071 - Photo 1 Just Listed
$275,000

199 Grandview Ave  Newport, KY 41071

  • Single Family
  • Active
  • Updated 6 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,990
    Sq. Ft.
Listed by Traci Nestheide (859) 409-8815
836 Flint Ridge, Newport, KY 41076 - Photo 1 Just Listed
$205,000

836 Flint Ridge  Newport, KY 41076

  • Condo
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,140
    Sq. Ft.
937 Putnam St, Newport, KY 41071 - Photo 1 Just Listed
$435,000

937 Putnam St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,082
    Sq. Ft.

Price Reduced near 1797 Sycamore St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

799 Slate View, Newport, KY 41076 - Photo 1 Price Reduced
-$5,000 (-2.34%)
$209,000

799 Slate View  Newport, KY 41076

  • Condo
  • Active
  • Updated 5 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,140
    Sq. Ft.
Listed by Nicole Rankin (859) 394-4930 and Maliah Ware (513) 314-2649
101 Watch Hill Ln, Newport, KY 41071 - Photo 1 Price Reduced
-$65,100 (-4.16%)
$1,499,900

101 Watch Hill Ln  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 5
    Total Baths
  • 3,688
    Sq. Ft.
59 Ohio Ave, Newport, KY 41071 - Photo 1 Price Reduced
-$5,000 (-12.53%)
$34,900

59 Ohio Ave  Newport, KY 41071

  • Lots/Land
  • Active
  • Updated 8 hours ago
  • 0.36
    Acres
241 E 10th St, Newport, KY 41071 - Photo 1 Price Reduced
-$95,000 (-11.95%)
$700,000

241 E 10th St  Newport, KY 41071

  • Multi-Family
  • Active
  • Updated 4 days ago
  • 8
    Total Beds

Recent Sales near 1797 Sycamore St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

26 E McMicken Ave, Cincinnati, OH 45202 - Photo 1 Sold
$525,711

26 E McMicken Ave  Cincinnati, OH 45202

  • Multi-Family
  • Closed
541 Ringgold St, Cincinnati, OH 45202 - Photo 1 Sold
$575,000

541 Ringgold St  Cincinnati, OH 45202

  • Single Family
  • Closed
  • 3
    Beds
  • 4
    Total Baths
  • 2,239
    Sq. Ft.
Listed by The Pitzer Group
548 Slack St, Cincinnati, OH 45202 - Photo 1 Sold
$595,000

548 Slack St  Cincinnati, OH 45202

  • Single Family
  • Closed
  • Updated 6 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,056
    Sq. Ft.
Sold by Drew & Ingrid Group
522 E 12th St, Cincinnati, OH 45202 - Photo 1 Sold
$585,000

522 E 12th St  Cincinnati, OH 45202

  • Triplex
  • Closed

1797 Sycamore Street, Cincinnati, OH 45202 (MLS# 1873884) is a Single Family property with 3 bedrooms, 2 full bathrooms and 1 partial bathroom. 1797 Sycamore Street is currently listed for $585,000 and was received on April 02, 2026. This property is listed by Doug Spitz from our Hyde Park Regional Office.Want to learn more about 1797 Sycamore Street? Do you have questions about finding other Single Family real estate for sale in Mount Auburn? You can browse all Mount Auburn real estate or contact a Coldwell Banker agent to request more information.

Tour this property