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,261,700 Zestimate®
$267/sqft
$3,731 Estimated rent
Home value
$2,261,700
$2.04M - $2.51M
$3,731/mo
Zestimate® history
Owner options
List your home for rent
$3,731/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,731/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.
$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
Exercise roomIndoor sport courtFully stocked pondPrivate studyCraft roomWalk-in pantryTwo walk-in closets
Zillow last checked:
Listing updated:
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 & HOA
HOA
- Has HOA: No
Location
- Region: Loveland
Financial & listing details
- Price per square foot: $267/sqft
- Tax assessed value: $2,050,000
- Annual tax amount: $38,414
- Date on market: 4/17/2025
- 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 | ||
| 4/17/2025 | Listed for sale | $2,350,000+14.6%$286/sqft |
Source: Cincy MLS #1837587 Report a problem | ||
| 6/3/2022 | Sold | $2,050,000-6.8%$249/sqft |
Source: Cincy MLS #1737186 Report a problem | ||
| 4/29/2022 | Pending sale | $2,199,000+972.7%$267/sqft |
Source: Cincy MLS #1737186 Report a problem | ||
| 3/7/2014 | Sold | $205,000-31.4%$25/sqft |
Source: Cincy MLS #1379559 Report a problem | ||
| 1/24/2014 | Pending sale | $299,000$36/sqft |
Source: Coldwell Banker West Shell - Union Centre Regional Office #1379559 Report a problem | ||
| 10/25/2013 | Listed for sale | $299,000$36/sqft |
Source: Coldwell Banker West Shell #1379559 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 |
| 2021 | $26,191 +5% | $375,844 |
| 2020 | $24,944 +64.6% | $375,844 +70.7% |
| 2019 | $15,154 +364.4% | $220,220 +390.5% |
| 2018 | $3,263 +10.5% | $44,895 |
| 2017 | $2,953 -37.9% | $44,895 -37.4% |
| 2016 | $4,755 | $71,751 |
| 2015 | $4,755 -5.4% | $71,751 |
| 2014 | $5,028 +19.7% | $71,751 -4.4% |
| 2013 | $4,202 -0.3% | $75,090 |
| 2012 | $4,213 +2.4% | $75,090 |
| 2011 | $4,115 +21.9% | $75,090 +10.9% |
| 2010 | $3,375 +4.1% | $67,701 |
| 2009 | $3,242 +2.3% | $67,701 |
| 2008 | $3,169 +1.2% | $67,701 +3% |
| 2007 | $3,132 -2.8% | $65,730 |
| 2006 | $3,222 +1% | $65,730 |
| 2005 | $3,190 -2.9% | $65,730 -1.8% |
| 2003 | $3,286 -7.6% | $66,955 |
| 2002 | $3,556 +2.6% | $66,955 +5.7% |
| 2001 | $3,464 +2.8% | $63,350 |
| 2000 | $3,371 | $63,350 |
Find assessor info on the county website
Neighborhood: 45140
Nearby homes
- $220,0001 Acres9550 Union Cemetery Rd, Loveland, OH 45140Sold
- $1,485,7514 bd4 ba-- sqft9558 Union Cemetery Rd, Loveland, OH 45140Sold
- $928,6004 bd4 ba3.4k sqft9552 Stonemasters Dr, Loveland, OH 45140Off Market
- $675,0004 bd4 ba3.6k sqft9554 Stonemasters Dr, Loveland, OH 45140Sold
- $705,1004 bd4 ba2.8k sqft9550 Stonemasters Dr, Loveland, OH 45140Off Market
- $587,200-- bd3 ba1.7k sqft9550 Union Cemetery Rd, Loveland, OH 45140Off Market
- $1,069,3005 bd6 ba4k sqft9556 Stonemasters Dr, Loveland, OH 45140Off Market
- $604,9004 bd2 ba2.7k sqft11916 Antietam Dr, Loveland, OH 45140Off Market
Nearby schools
GreatSchools rating
- 8/10Loveland Intermediate SchoolGrades: 4-6Distance: 1.5 mi
- 8/10Loveland Middle SchoolGrades: 7-8Distance: 1.6 mi
- 9/10Loveland High SchoolGrades: 9-12Distance: 1.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,261,700
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,261,700
- Ohio
- Hamilton County
- Loveland
- 45140
- 9544 Union Cemetery Rd
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Loveland Topics
