Skip main navigation
Sold for $1,300,000
Street View
  • $1,300,000

    117 Stearns Ave, Cincinnati, OH 45215

    4beds
    4,398sqft
    Single Family Residence
    Built in 2018
    0.5 Acres Lot
    $1,346,800 Zestimate®
    $296/sqft
    $4,498 Estimated rent

    Home value

    $1,346,800

    $1.23M - $1.48M

    $4,498/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,498/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,498/mo

    Rent Zestimate®

    Refinance and save

    $7,067/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $7,067/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Built-in dresserIron fenceAmish custom wood cabinetsSubzero oversized refrigSs appliancesStone patioEnclosed porch
    Better than new! Exquisite transitional in the heart of the Village. Over 4300 sq ft of living space on 1/2 acre lot. SS appliances, deluxe kitchen w/quartz CC, 6 burner Wolf cooktop, farm sink, subzero oversized refrig. Amish custom wood cabinets, walk-in pantry, planning desk. 3 car garage (one extra tall for trucks). 1st fl primary suite, built-in dresser, walk-in closet, quartz vanity, 2 sinks, walk-in oversized shower. 1st fl study w/French doors. HWFs throughout! Cathedral ceiling in Great room w/gas FP, beam ceilings opens to 25x16 porch w/WBFP, cathedral ceiling, slate floor, 4 skylights overlooking picturesque backyard w/iron fence. Stone patio & enclosed porch are perfect for entertaining! 1st fl laundry w/cabinets, 10 ft ceiling, coat room w/storage cubbies, zone heating. 2nd fl offers 3 large BRs & 2 full baths w/granite countertops & tile floor. LL has deluxe 41x20 FR/entertainment! Carpet, wet bar w/dishwasher, refrig., storage cabinets, full bath and so much more!

    Zillow last checked:

    Listing updated:

    Listed by:

    Sue S Lewis 513-324-8095,

    Sibcy Cline, Inc. 513-931-7700

    Bought with:

    Sue S Lewis, 0000323199

    Sibcy Cline, Inc.

    Source: Cincy MLS,MLS#: 1840110MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Bath Adjoins, Walk-In Closet(s), Dressing Area, Wood Floor
    • Level: First
    • Area: 238
    • Dimensions: 14 x 17
    Bedroom 2
    • Level: Second
    • Area: 169
    • Dimensions: 13 x 13
    Bedroom 3
    • Level: Second
    • Area: 156
    • Dimensions: 13 x 12
    Bedroom 4
    • Level: Second
    • Area: 210
    • Dimensions: 14 x 15
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
    Bathroom 1
    • Features: Full
    • Level: First
    Bathroom 2
    • Features: Full
    • Level: Second
    Bathroom 3
    • Features: Full
    • Level: Lower
    Bathroom 4
    • Features: Full
    • Level: Second
    Dining room
    • Features: Wood Floor, Formal, Other
    • Level: First
    • Area: 252
    • Dimensions: 18 x 14
    Family room
    • Features: Wall-to-Wall Carpet, Wet Bar
    • Area: 820
    • Dimensions: 41 x 20
    Great room
    • Features: Walkout, Fireplace, Wood Floor
    • Level: First
    • Area: 462
    • Dimensions: 21 x 22
    Kitchen
    • Features: Butler's Pantry, Pantry, Planning Desk, Quartz Counters, Counter Bar, Solid Surface Ctr, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor
    • Area: 360
    • Dimensions: 18 x 20
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Office
    • Features: Bookcases, French Doors, Wood Floor
    • Level: First
    • Area: 110
    • Dimensions: 10 x 11
    Heating
    • Gas Furn EF Rtd 95%+, Geothermal, Zoned
    Cooling
    • Central Air
    Appliances
    • Included: Convection Oven, Dishwasher, Double Oven, Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Gas Water Heater
    Features
    • High Ceilings, Beamed Ceilings, Cathedral Ceiling(s), Crown Molding, Ceiling Fan(s), Recessed Lighting, Central Vacuum
    • Doors: Multi Panel Doors
    • Windows: Picture, Double Hung
    • Basement: Full,Partially Finished,WW Carpet
    • Number of fireplaces: 2
    • Fireplace features: Gas, Great Room
    Interior area
    • Total structure area: 4,398
    • Total interior livable area: 4,398 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Off Street, On Street, Garage Door Opener
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Enclosed Porch, Patio, Porch
    • Exterior features: Yard Lights
    • Fencing: Metal
    Lot
    • Size: 0.5 Acres
    • Features: .5 to .9 Acres
    Details
    • Parcel number: 5920012003300
    • Zoning description: Residential
    • Other equipment: Sump Pump

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Transitional
    • Property subtype: Single Family Residence
    Materials
    • Brick, Wood Siding
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: No
    • Year built: 2018

    Utilities & green energy

    • Electric: 220 Volts
    • Gas: At Street
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Connected

    Community & HOA

    Community
    • Security: Security System, Smoke Alarm
    HOA
    • Has HOA: No
    Location
    • Region: Cincinnati

    Financial & listing details

    • Price per square foot: $296/sqft
    • Tax assessed value: $1,174,190
    • Annual tax amount: $2,560
    • Date on market: 5/8/2025
    • Listing terms: No Special Financing,Conventional

    Price history

    DateEventPrice
    6/3/2025Sold$1,300,000-10.3%$296/sqft
    Source: Cincy MLS #1840110 Report a problem
    5/8/2025Pending sale$1,450,000$330/sqft
    Source: Cincy MLS #1840110 Report a problem
    5/8/2025Listed for sale$1,450,000+603.9%$330/sqft
    Source: Cincy MLS #1840110 Report a problem
    3/6/2017Sold$206,000$47/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$25,617 +9.7%$410,967
    2023$23,347 +0.2%$410,967 +23.7%
    2022$23,292 +0.8%$332,332
    2021$23,104 $332,332
    2020$23,104 +676.3%$332,332 +743.5%
    2019$2,976 +3%$39,400
    2018$2,889 $39,400
    2017$2,889 +6.7%$39,400 -6.3%
    2016$2,708 $42,042
    2015$2,708 -0.1%$42,042
    2014$2,710 +6.2%$42,042 +11%
    2013$2,551 +0.2%$37,877
    2012$2,546 +7.1%$37,877
    2011$2,376 -7.8%$37,877 -15.1%
    2010$2,576 +0.4%$44,594
    2009$2,567 +1.7%$44,594
    2008$2,523 +5.4%$44,594 +6%
    2007$2,393 +0.6%$42,070
    2006$2,379 -1.3%$42,070
    2005$2,409 +44.7%$42,070 +34.9%
    2003$1,665 -1.8%$31,185
    2002$1,696 +151.1%$31,185 +131.4%
    2001$676 +12.8%$13,475
    2000$599 $13,475
    Find assessor info on the county website

    Neighborhood: 45215

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,346,800
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,346,800