Lisa Slay
Plum Tree Realty
(513) 866-2573
33 Total Sales
2 in Saint Clair
$263K - $305K Price Range
671 Warwick Rd Hamilton, OH 45013
Saint Clair AreaEstimated Value: $530,815
3
Beds
2.5
Baths
2,369
Sq Ft
$224/Sq Ft
Est. Value
Highlights
- Open-Concept Dining Room
- Transitional Architecture
- Wood Flooring
- 2.54 Acre Lot
- Cathedral Ceiling
- Pole Barn
About This Home
As of August 2025Tucked away on a level 2.54-acre lot in a serene rural setting, this immaculate brick ranch boasts 3281 sf living space including one-level living with an open layout, 9' and cathedral ceilings throughout. View Drone Video!! The gourmet kitchen shines with granite counters, stainless appliances, 42'' cabinets, and a walk-in pantry, flowing seamlessly into a spacious great room with a dramatic gas stone fireplace. The luxurious primary suite features a walk-in closet, whirlpool tub and an oversized walk-in tiled shower. Enjoy views from the full-length front porch or the expanded rear covered patio. With 3 bedrooms, 2.5 baths, a main-floor study and laundry, plus a bright finished lower level with dry bar and flex room, this home offers both style and functionality. A 576 sq ft pole barn completes the picturejust minutes from downtown Hamilton!
Last Agent to Sell the Property
Comey & Shepherd License #0000350623 Listed on: 07/09/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,024
Year Built
- Built in 2004
Lot Details
- 2.54 Acre Lot
- Lot Dimensions are 200x628
- Level Lot
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2,369 Sq Ft Home
- 1-Story Property
- Dry Bar
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Stone Fireplace
- Gas Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Window Treatments
- Panel Doors
- Entrance Foyer
- Living Room with Fireplace
- Open-Concept Dining Room
- Home Gym
- Fire and Smoke Detector
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Electric Cooktop
- Microwave
- Dishwasher
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Laminate
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- Jetted Tub in Primary Bathroom
Laundry
- Dryer
- Washer
Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump
Outdoor Features
- Covered Deck
- Pole Barn
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heat Pump System
- Propane
- Electric Water Heater
- Septic Tank
- Cable TV Available
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 9, 2025
Closed on
Aug 5, 2025
Sold by
Harmon Mike D and Harmon Lori A
Bought by
Seller's Agent
Barry Kaplan
Comey & Shepherd
Buyer's Agent
Michelle Brubacher
Howard Hanna Real Estate Serv
List Price
$489,900
Sold Price
$489,900
Views
39
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$40,915
Avg. Annual Appreciation
7.56%
Original Mortgage
$464,550
Outstanding Balance
$459,523
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$71,292
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Hamilton, OH
-
Lisa Slay
-
Brandi Howell
Brandi Howell
Keller Williams Community Part
(513) 224-5293
286 Total Sales
2 in Saint Clair
$120K - $285K Price Range
-
Nicole Peters
Nicole Peters
The Six Realty, LLC
(513) 657-0716
108 Total Sales
3 in Saint Clair
$127K - $690K Price Range
-
Dawnitta Ollis
Dawnitta Ollis
Plum Tree Realty
(513) 713-0495
220 Total Sales
5 in Saint Clair
$225K - $325K Price Range
-
Arthur Greenlee IV
Arthur Greenlee IV
eXp Realty
(866) 835-4716
111 Total Sales
1 in Saint Clair
$300,000 Price
-
Varun Varma
Varun Varma
Coldwell Banker Realty FM
(513) 866-5856
242 Total Sales
2 in Saint Clair
$275,000 Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $489,900 | First Ohio Title |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $464,550 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 08/08/2025 08/08/25 | Sold | $489,900 | 0.0% | $207 / Sq Ft |
| 07/10/2025 07/10/25 | Pending | -- | -- | -- |
| 07/09/2025 07/09/25 | For Sale | $489,900 | -- | $207 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $5,997 | $157,110 | $19,220 | $137,890 |
| 2024 | $5,997 | $140,680 | $19,220 | $121,460 |
| 2023 | $5,970 | $140,680 | $19,220 | $121,460 |
| 2022 | $4,941 | $100,160 | $19,220 | $80,940 |
| 2021 | $4,754 | $100,160 | $19,220 | $80,940 |
| 2020 | $5,053 | $100,160 | $19,220 | $80,940 |
| 2019 | $5,519 | $75,230 | $19,220 | $56,010 |
| 2018 | $3,807 | $75,230 | $19,220 | $56,010 |
| 2017 | $3,827 | $75,230 | $19,220 | $56,010 |
| 2016 | $3,688 | $70,530 | $19,220 | $51,310 |
| 2015 | $3,301 | $70,530 | $19,220 | $51,310 |
| 2014 | $3,151 | $70,530 | $19,220 | $51,310 |
| 2013 | $3,151 | $59,440 | $17,390 | $42,050 |
Source: Public Records
Agents Affiliated with this Home
-
Barry Kaplan
Seller's Agent in 2025
Barry Kaplan
Comey & Shepherd
(513) 368-9000
54 Total Sales
-
Michelle Brubacher
Buyer's Agent in 2025
Michelle Brubacher
Howard Hanna Real Estate Serv
(513) 373-3429
35 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1847282
APN: L5210-007-000-044
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 2160 Pumpkin Ridge Ct
- 2156 Pumpkin Ridge Ct
- 72 Beissinger Rd
- 1970 Redbud Dr
- 458 Hamilton View
- 751 Bristol View Dr
- 2244 W Elkton Rd
- 670 Orient Way
- 303 N Main St
- 5612 Birch Ct
- 5544 Birch Ct
- 1022 Golden Oak Dr
- 1908 Gardner Rd
- 273 Livingston Ct
- 1021 Golden Oak Dr
- 315 Mill St
- 110 Laura Ct
- 3871 W Elkton Rd
- 1474 Woodridge Dr
- 12 Brittany Ct
Your Personal Tour Guide
Ask me questions while you tour the home.