Skip main navigation
Sold for $1,300,000 on 06/03/25
  • $1,300,000

    117 Stearns Ave, Cincinnati, OH 45215

    4beds
    4,398sqft
    Single Family Residence
    Built in 2018
    0.5 Acres Lot
    $1,300,500 Zestimate®
    $296/sqft
    $5,397 Estimated rent

    What's special

    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: 7 hours ago

    Listing updated: June 04, 2025 at 05:36am

    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.50 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 & neighborhood

    Security
    • Security features: Security System, Smoke Alarm
    Location
    • Region: Cincinnati

    HOA & financial

    HOA
    • Has HOA: No

    Other

    Other facts
    • Listing terms: No Special Financing,Conventional
    Services availability
    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,300,500

    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,300,500