1247 Ida St, Cincinnati, OH 45202
Property image
Property image
OFF MARKET

$1,107,200

Trulia Estimate
  • 4 Beds
  • 3.5 Baths
  • 3,155 sqft

1247 Ida St, Cincinnati, OH 45202

Mt. Adams
Est. Refi. Payment $7,111/mo*
Refinance Your Home
Currently Off Market - Sold Sep 15, 2023 for $1,025,000

Home Value

Trulia Estimate
$1.11M
Since last month
Decreased$23K (-2%)
Since last year
Increased$27K (+2.5%)
Since last sale
Increased$80K (+7.8%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +64% in the last 10 years
MonthEstimated value
2026
August 2026$1.11M
July 2026$1.13M
June 2026$1.16M
May 2026$1.16M
April 2026$1.14M
March 2026$1.12M
February 2026$1.08M
January 2026$1.06M
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
961 Hatch St, Cincinnati, OH
0.18
Single-Family Home
$740,000
03/06/26
3
2.5
2,520
981 Hatch St, Cincinnati, OH
0.21
Single-Family Home
$2,275,000
10/07/25
4
4
4,074
1000 Paradrome St, Cincinnati, OH
0.23
Single-Family Home
$1,310,000
03/27/26
3
3.5
3,395
426 E 12th St, Cincinnati, OH
0.43
Single-Family Home
$899,900
06/04/26
4
2.5
3,114
1273 Ida St, Cincinnati, OH
0.04
Single-Family Home
$605,000
05/13/26
4
3
2,400
408 Boal St, Cincinnati, OH
0.54
Single-Family Home
$925,000
01/26/26
3
4.5
3,470
1005 Parkside Pl, Cincinnati, OH
0.26
Single-Family Home
$550,000
03/03/26
4
2.5
1,764
428 Oregon St, Cincinnati, OH
0.30
Single-Family Home
$1,075,000
07/02/26
3
3.5
2,850
913 Paradrome St, Cincinnati, OH
0.05
Single-Family Home
$485,000
12/11/25
4
2.5
2,087

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
1255 Ida St, Cincinnati, OH 45202
0.02
-
4
4
2,750
Off Market
1271 Ida St, Cincinnati, OH 45202
0.04
-
4
3
2,880
Off Market
1273 Ida St, Cincinnati, OH 45202
0.04
$605,000
4
3
2,400
Recently Sold
1235 Ida St, Cincinnati, OH 45202
0.03
-
3
2.5
2,621
Off Market
1240 Elsinore Ave, Cincinnati, OH 45202
0.03
$300,000
6
3
2,712
Recently Sold
907 Paradrome St, Cincinnati, OH 45202
0.04
$502,700
3
2.5
2,392
Off Market
913 Paradrome St, Cincinnati, OH 45202
0.05
$485,000
4
2.5
2,087
Recently Sold
1238 Elsinore Ave, Cincinnati, OH 45202
0.04
$697,000
3
3.5
3,718
For Sale
905 Paradrome St, Cincinnati, OH 45202
0.05
$540,000
3
2
1,969
Recently Sold
919 Paradrome St, Cincinnati, OH 45202
0.06
$455,200
4
2
2,128
Off Market
1236 Elsinore Ave, Cincinnati, OH 45202
0.04
$1,051,000
3
3.5
3,530
Off Market

Local Information

  • Map ViewExplore the area around 1247 Ida St.
  • Schools2 Preschool Schools3 Elementary Schools12 Middle Schools12 High Schools
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
1985
Living Area
3,155 sqft
Price/Sqft
$351
Parking
2 Car Garage
HOA
None

About this House

Views for days!4 levels of living w/aprox 3600+sq ft!2 structures connected by breezeways! 2 primary suites!2 kitchens!2 laundries!2 car gar!2FP's! 2 staircases! Perfect for possible short term rentals!Lap pool, fountain, gazebo, &blue stone along with multiple outdoor living spaces!1st floor suite w/kitchenette and original field stone walls, library, walkout,& built-ins!Close to shopping & dining!Across from The Playhouse in the Park!This home has been in Architectural Digest & House Beautiful
1247 Ida St, Cincinnati, OH 45202 is a 4 bedroom, 4 bathroom, 3,155 sqft single-family home in Mt. Adams, built in 1985. It last sold for the $1,025,000 asking price on Sep 15, 2023. More recently, it was listed as a rental in July 2026 with an asking price of $2,000 per month. That rental listing was removed on July 29, 2026. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $1,107,200, with a rent estimate of $4,313/month.
Contact this Building
Property Website
Last check for updates: about 1 hour ago
Listed by Julia Packer P Wesselkamper, (513) 720-4496
Coldwell Banker Realty, (513) 891-8500
Bought with: Lee G. Robinson, (513) 470-7700, Robinson Sotheby's Internat'l, (513) 321-6000
Originating MLS: Cincinnati Area Multiple Listing Service
Source: Cincy MLS, MLS#1756079
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 Zillow, Inc. 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. Zillow, Inc. 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

Home Details for 1247 Ida St

Interior Features

Interior Details
Basement: Full,Finished,Walk-Out Access,OtherNumber of Rooms: 15Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Master Bathroom, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Dining Room, Family Room, Kitchen, Living Room, Office
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 3155 Square Feet
Appliances & Utilities
Utilities: Cable ConnectedAppliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Gas Water HeaterDishwasherDryerMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: GasHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Gas
Fireplace & Spa
Number of Fireplaces: 2Fireplace: Gas, Family Room, Living RoomHas a Fireplace
Gas & Electric
Gas: Natural
Windows, Doors, Floors & Walls
Window: Wood FramesDoor: French Doors, Multi Panel Doors
Levels, Entrance, & Accessibility
Stories: 3
View
Has a ViewView: City, Trees/Woods
Security
Security: Security System

Exterior Features

Exterior Home Features
Roof: ShinglePatio / Porch: Covered Deck/Patio, Deck, PatioVegetation: Heavily WoodedOther Structures: GazeboExterior: Balcony, Yard Lights, OtherFoundation: Concrete Perimeter, StoneHas a Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 2Parking: On Street,Garage Door Opener
Pool
Pool: In Ground, LapPool
Frontage
Road Frontage: City Street
Water & Sewer
Sewer: Public Sewer

Property Information

Year Built
Year Built: 1985
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: HistoricalArchitecture: Transitional
Building
Construction Materials: Wood SidingNot a New Construction
Property Information
Parcel Number: 0730003022400

Price & Status

Price
List Price: $1,025,000Price Range: $0 - $1,025,000
Status Change & Dates
Possession Timing: Close Of Escrow

Active Status

MLS Status: Sold

Location

Direction & Address
City: Cincinnati
School Information
High School District: Cincinnati City SD

Building

Building Area
Building Area: 3155 Square Feet

HOA

Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOA

Lot Information

Lot Area: 9583.2 sqft

Documents

Disclaimer: Information has not been verified, is not guaranteed and subject to change.<BR>Copyright</A> &copy;2026 <A name="trans">MLS of Greater Cincinnati, Inc. All rights reserved.</A><BR>

Offer

Listing Terms: No Special Financing

Energy

Energy Efficiency Features: No

Miscellaneous

BasementMls Number: 1756079Listing Url

Price and Tax history

DateEventPrice
Jul 29, 2026
Source: Zillow Rentals
ListingRemoved
$2,000
Jul 27, 2026
Source: Zillow Rentals
Listed For Rent
$2,000
Sep 15, 2023
Source: Cincy MLS #1756079
Sold
$1,025,000
Jul 30, 2023
Source: Cincy MLS #1756079
Pending
$1,049,900
Jul 21, 2023
Source: Cincy MLS #1756079
Listed For Sale
$1,049,900

Market trends in Cincinnati

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$258K
$4.33KMoM
Sale-to-List Price
100.0%
Price per sq ft
$174
$3MoM
Available listings
1537
20MoM

Around this home

Neighborhood Overview

Mt. Adams
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Mt. Adams

At least 31 Trulia users voted on each feature.

  • 100 % Say it's dog friendly

  • 97 % Say there are sidewalks

  • 94 % Say it's walkable to restaurants

  • 90 % Say people would walk alone at night

  • 79 % Say streets are well-lit

  • 79 % Say car is needed

  • 65 % Say neighbors are friendly

  • 63 % Say there's holiday spirit

  • 62 % Say yards are well-kept

  • 58 % Say parking is easy

  • 57 % Say there's wildlife

  • 57 % Say there are community events

  • 47 % Say they plan to stay for at least 5 years

  • 39 % Say kids play outside

  • 34 % Say it's quiet

  • 25 % Say it's walkable to grocery stores

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "This is a great location with tons of local shops, bars, & restaurants. Very walkable and dog friendly. "
    0
    Flag
  • Rebecca V.
    "Mt Adams is a charming neighborhood full of green spaces, the arts, cafes, restaurants and bars. Pretty much everything you need is within walking distance. Its close to downtown and great access to 71/75 making it easy to get places. "
    1
    Flag
  • Kris M.
    "My neighborhood is within walking distance to downtown. The public transportation is easily accessible. I topically walk to my job downtown and occasionally ride my bike to near by neighborhoods and stores downtown. "
    1
    Flag
  • Nicholas
    "Great neighborhood for kids: safe, walkable, friendly neighbors, neighborhood events (outdoor movies, concerts, holidays) and easy access to great resources for kids (pool, museum, downtown). Increasing number of young families committed to raising their kids on the Hill, PLUS you can live adjacent to downtown, reducing your commute, maximizing your time at home."
    0
    Flag
  • Charles
    "Mt. Adams is a Cincinnati gem - great for families, singles, and empty nesters alike. This neighborhood is an artistic hub for the city - boasting both the Art Museum and the Playhouse (both embarking on major updates), as well as one of the city’s finest parks and the Krohn Conservatory. Charming streets, amazing views and one of the lowest crime rates in the city make Mt. Adams a truly special place to live. Not least of all is the convenience for work and play: downtown, The Banks and OTR are a 20 minute walk or a 3 minute drive."
    0
    Flag
  • Seaven C
    "The neighborhood has easy access to both major highways and quick to get downtown or over the river. "
    0
    Flag
  • katz
    "There are always events happening at the top of Mt Adams. My street has a coordinator and people are always getting together. There is a great art and music scene here as well."
    0
    Flag
  • Cleaningtaylor92
    "i enjoy dogs, no complaints. just pick up poop, make sure they are leashed or contained to yard. my dog barks alot but is also always in our home. so noise wont be a neighborhood issue "
    0
    Flag
  • Smelcerash
    "Mt.Adams is great because it has plenty of green space as well as businesses. It has restaurant and bars. It also has a UDF for those items you forgot at the grocery store. "
    9
    Flag
  • alisonnugent75
    "Not great if you have children. Loud bars in the area and traffic barreling down the street. I moved my children out to the suburbs. "
    4
    Flag

LGBTQ Local Legal Protections

Frequently asked questions about 1247 Ida St

  • What is 1247 Ida St estimated to be worth?
    Trulia's estimated value for 1247 Ida St in Cincinnati, OH is $1,107,200.
  • What is the price history for 1247 Ida St?
    1247 Ida St in Cincinnati, OH last sold for $1,025,000 in September 2023.
  • Is Cincinnati a buyer's or seller's market?
    Cincinnati is currently a buyer's market, based on recent for-sale activity.
  • What's the median sale price in Cincinnati?
    The median sale price in Cincinnati is $258K. That is up $4.33K from the prior month.
  • Does 1247 Ida St have air conditioning?
    Yes, 1247 Ida St in Cincinnati, OH has air conditioning.
  • Does 1247 Ida St have a pool?
    Yes, 1247 Ida St in Cincinnati, OH has a pool.

Explore by feature - Pet Friendly

1094 pet-friendly rentals in Cincinnati, OH

Explore by feature - Garage

278 rentals with a garage in Cincinnati, OH

Explore by feature - Air Conditioning

1087 rentals with air conditioning in Cincinnati, OH

Explore by feature - Pool

122 rentals with a pool in Cincinnati, OH

Explore by feature - Washer/dryer

945 rentals with a washer/dryer in Cincinnati, OH

Explore by feature - Outdoor Space

137 rentals with an outdoor space in Cincinnati, OH

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 1247 Ida St

Skip to last item
Skip to first item

Homes for sale near 1247 Ida St

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item