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!
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
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#: 1840110
Originating 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