LKV Realty
Logo
549 Church Street photo 1
Loading image549 Church Street photo 2
Loading image549 Church Street photo 3
Loading image549 Church Street photo 4
Loading image549 Church Street photo 5
Loading image549 Church Street photo 6
Loading image549 Church Street photo 7
Loading image549 Church Street photo 8
Loading image549 Church Street photo 9
Loading image549 Church Street photo 10
Loading image549 Church Street photo 11
Loading image549 Church Street photo 12
Loading image549 Church Street photo 13
Loading image549 Church Street photo 14
Loading image549 Church Street photo 15
Loading image549 Church Street photo 16
Loading image549 Church Street photo 17
Loading image549 Church Street photo 18
Loading image549 Church Street photo 19
Loading image549 Church Street photo 20
Loading image549 Church Street photo 21
Loading image549 Church Street photo 22
Loading image549 Church Street photo 23
Loading image549 Church Street photo 24
Loading image549 Church Street photo 25
$175,000
$900Reward *
549 Church Street, St Bernard, OH 45217Listing ID 1883754

549 Church Street, St Bernard, OH 45217

Active
Time on site: 60 days • Last updated: Aug 5, 2026
Property Type
Property Type
Residential Income
Property Sub Type
Property Sub Type
Multi Fam 2-4 units
Square Feet
Square Feet
2,002
Acres
Acres
0.11
Days on Site
Days on Site
59
Cooling
Cooling
Window Unit, None
Heating
Heating
Forced Air
Year Built
Year Built
1925
Parking
Parking
Driveway

Excellent value-add duplex opportunity featuring two spacious units and strong upside potential. The first unit offers a large one-bedroom (with one room currently used as a second bedroom). The second unit features two bedrooms with a loft. Both units are large and offer flexible floor plans, making this a great option for investors or an owner-occupant looking to build equity. The property includes an oversized tandem garage and a large unfinished basement. The building does need updating and improvements, giving the next owner the opportunity to add value. Loft area not pictured. Both tenants are currently month-to-month.

Property Information

Property Details

Location

Address
549 Church Street
County
Hamilton
City
St Bernard
Zip Code
45217
School District
St Bernard Elmwood P
MLS Area
Hamilton-W01

Interior Features

Heating and Cooling

Cooling
Window Unit, None
Heating
Forced Air
Fireplace
None

Building

Building Information

Square Feet
2,002
Year Built
1925
Construction
Block
Foundation
Block
Roof
Shingle
Michael J Slafka • Plum Tree Realty, (513) 443-5060

Market Report for 45217

* The market data shown is based on available information from Multiple Listing Service (MLS) and/or public records. Data provided is for informational and educational purposes only and may not represent the full housing market. For more accurate information, consumers should consult a certified appraiser or licensed real estate agent.

*Average of $2,150 in rewards is calculated based on the purchase or sale of a home between $400,000 to $449,000. The median home price for all housing types is in the United States is $405,400 as of 2025 as reported by the National Association of Realtors® (NAR). The actual reward amount may vary depending on the purchase or sales price of the home. Please see the Lakeview Home Rewards program terms and conditions for more details. The National Association of Realtors® is a registered trademark of the National Association of Realtors®.

Source: MLS of Greater Cincinnati
MLS of Greater Cincinnati logo

IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

For corrections to this data please contact Brytecore MLS Support.

260132