This impressive custom-built home spans 8225 square feet in a picturesque 3.8-acre setting with a fully stocked pond that feels like a country estate, yet in a super convenient location! Enjoy private views of the entire property from the grand front & rear covered porches. Chef's kitchen with walk-in pantry is open to the great room & den with fireplace. Huge 1stfloor laundry with pet wash. Expansive 1st floor primary suite wing features a private study, two walk-in closets, and an amazing spa bath. 2nd floor features 3 bedrooms, all with en-suite bathrooms attached. Walk-out LL features an indoor sport court with 23-foot-high ceiling, exercise room, 2ndbar/kitchen, theater rm, billiards, craft room, full bath, and ample storage! Fun continues with full-size golf simulator and relax in the 4-person sauna. Vacation at home year-round! No HOA.
Sold for $2,195,000
$2,195,000
9544 Union Cemetery Rd, Loveland, OH 45140
4beds
8,225sqft
Single Family Residence
Built in 2017
3.77 Acres Lot
$2,249,900 Zestimate®
$267/sqft
$4,505 Estimated rent
Home value
$2,249,900
$2.05M - $2.47M
$4,505/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$4,505/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,505/mo
Rent Zestimate®
Refinance and save
$11,932/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$11,932/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 startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: June 27, 2025 at 07:25am
Listed by:
Robert J Mahoney 513-313-4245,
Sibcy Cline, Inc. 513-793-2700,
Elizabeth R Mahoney 513-477-6520,
Sibcy Cline, Inc.
Bought with:
Judith C. Warren, 2024000416
Home Information Network, Inc.
Source: Cincy MLS,MLS#: 1837587
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 7
- Full bathrooms: 5
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet, Sitting Room
- Level: First
- Area: 464
- Dimensions: 29 x 16
Bedroom 2
- Level: Second
- Area: 224
- Dimensions: 16 x 14
Bedroom 3
- Level: Second
- Area: 210
- Dimensions: 15 x 14
Bedroom 4
- Level: Second
- Area: 210
- Dimensions: 15 x 14
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Shower, Tile Floor, Double Vanity, Tub, Heated Floors, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Second
Bathroom 4
- Features: Full
- Level: Second
Dining room
- Features: Chandelier
- Level: First
- Area: 195
- Dimensions: 15 x 13
Family room
- Area: 0
- Dimensions: 0 x 0
Great room
- Features: Fireplace, Wood Floor
- Level: First
- Area: 399
- Dimensions: 21 x 19
Kitchen
- Features: Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
- Area: 468
- Dimensions: 26 x 18
Living room
- Features: Walkout, Wood Floor
- Area: 182
- Dimensions: 14 x 13
Office
- Features: Walkout, Wood Floor
- Level: First
- Area: 169
- Dimensions: 13 x 13
Heating
- Forced Air, Other
Cooling
- Central Air
Appliances
- Included: Dishwasher, Double Oven, Dryer, Disposal, Gas Cooktop, Microwave, Refrigerator, Warming Drawer, Washer, Humidifier, Electric Water Heater
Features
- High Ceilings, Crown Molding, Vaulted Ceiling(s), Ceiling Fan(s), Recessed Lighting
- Doors: French Doors
- Windows: Casement, Double Hung
- Basement: Full,Finished
- Number of fireplaces: 3
- Fireplace features: Stone, Gas, Wood Burning, Great Room
Interior area
- Total structure area: 8,225
- Total interior livable area: 8,225 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio, Patio, Porch
- Fencing: Metal
- Has view: Yes
- View description: Lake/Pond, Trees/Woods
- Has water view: Yes
- Water view: Lake/Pond
- Waterfront features: Lake/Pond
Lot
- Size: 3.77 Acres
- Features: 1 to 4.9 Acres, Fountain
Details
- Parcel number: 6200070005700
- Zoning description: Residential
- Other equipment: Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Stone, Fiber Cement, Wood Siding
- Foundation: Concrete Perimeter
- Roof: Metal,Shingle
Condition
- New construction: No
- Year built: 2017
Utilities & green energy
- Electric: 220 Volts
- Gas: Propane
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Location
- Region: Loveland
HOA & financial
HOA
- Has HOA: No
Other
Other facts
- Listing terms: No Special Financing,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 6/26/2025 | Sold | $2,195,000-3.5%$267/sqft |
Source:  Cincy MLS #1837587 Report a problem | ||
| 5/13/2025 | Pending sale | $2,275,000$277/sqft |
Source: Cincy MLS #1837587 Report a problem | ||
| 4/30/2025 | Price change | $2,275,000-3.2%$277/sqft |
Source: Cincy MLS #1837587 Report a problem | ||
| 4/25/2025 | Listed for sale | $2,350,000$286/sqft |
Source: Cincy MLS #1837587 Report a problem | ||
| 4/22/2025 | Pending sale | $2,350,000$286/sqft |
Source: Cincy MLS #1837587 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $38,393 -1.4% | $717,500 |
| 2023 | $38,920 +58.2% | $717,500 +90.9% |
| 2022 | $24,605 -6.1% | $375,844 |
Find assessor info on the county website
Neighborhood: 45140
Nearby schools
GreatSchools rating
- 7/10Loveland Intermediate SchoolGrades: 5-6Distance: 1.5 mi
- 7/10Loveland Middle SchoolGrades: 7-8Distance: 1.6 mi
- 9/10Loveland High SchoolGrades: 9-12Distance: 1 mi
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
$2,249,900
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
$2,249,900
- Ohio
- Hamilton County
- Loveland
- 45140
- 9544 Union Cemetery Rd