Beautiful stone front 2-story with over 3500 square feet of living space. Covered front porch on cul-de-sac street. Cozy living room with woodburning stove insert, walks out to covered back patio. Spacious kitchen exits to 4-season room with new heat & air and newer windows. Large level yard too! Front room would make convenient office space. Hardwood floors throughout. Large bedrooms. Full finished basement waiting for your finishing touches. 2 car garage with triple-wide driveway for plenty of parking. Fabulous heating and cooling systems are all <3 years old.
For sale
Price cut: $5K (12/1)
$335,000
3724 Yellowstone Dr, Cincinnati, OH 45251
4beds
2,934sqft
Est.:
Single Family Residence
Built in 1961
0.46 Acres Lot
$-- Zestimate®
$114/sqft
$-- HOA
What's special
Large bedroomsFull finished basementCul-de-sac streetTriple-wide drivewayStone frontLarge level yardCovered back patio
- 34 days |
- 1,019 |
- 107 |
Likely to sell faster than
Zillow last checked: 8 hours ago
Listing updated: December 01, 2025 at 08:43am
Listed by:
Kathie L. Smith 513-509-9225,
Sibcy Cline, Inc. 513-385-3330
Source: Cincy MLS,MLS#: 1861201
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Wood Floor
- Level: Second
- Area: 225
- Dimensions: 15 x 15
Bedroom 2
- Level: Second
- Area: 234
- Dimensions: 18 x 13
Bedroom 3
- Level: Second
- Area: 143
- Dimensions: 13 x 11
Bedroom 4
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Tile Floor, Tub w/Shower
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Partial
- Level: First
Dining room
- Features: Chandelier, Wood Floor
- Level: First
- Area: 156
- Dimensions: 12 x 13
Family room
- Features: Tile Floor
- Area: 384
- Dimensions: 32 x 12
Kitchen
- Features: Eat-in Kitchen, Tile Floor, Walkout, Wood Cabinets
- Area: 143
- Dimensions: 13 x 11
Living room
- Features: Walkout, Fireplace, Wood Floor
- Area: 319
- Dimensions: 29 x 11
Office
- Level: First
- Area: 165
- Dimensions: 15 x 11
Heating
- Radiator, Forced Air, Gas, Heat Pump, Hot Water
Cooling
- Attic Fan, Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Oven/Range, Gas Water Heater
Features
- Ceiling Fan(s)
- Windows: Double Pane Windows, Vinyl
- Basement: Full,Finished,Other
- Number of fireplaces: 1
- Fireplace features: Brick, Insert, Wood Burning, Living Room
Interior area
- Total structure area: 2,934
- Total interior livable area: 2,934 sqft
Property
Parking
- Total spaces: 2
- Parking features: On Street, Driveway, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio, Porch
Lot
- Size: 0.46 Acres
- Dimensions: 100 x 200
- Features: Cul-De-Sac, Less than .5 Acre
Details
- Parcel number: 5100103000200
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1961
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $114/sqft
- Tax assessed value: $270,790
- Annual tax amount: $6,204
- Date on market: 11/6/2025
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/1/2025 | Price change | $335,000-1.5%$114/sqft |
Source:  Cincy MLS #1861201 Report a problem | ||
| 11/6/2025 | Listed for sale | $340,000-1.4%$116/sqft |
Source: Cincy MLS #1861201 Report a problem | ||
| 11/1/2024 | Listing removed | $345,000$118/sqft |
Source: Cincy MLS #1819349 Report a problem | ||
| 11/1/2024 | Price change | $345,000-2.8%$118/sqft |
Source: Cincy MLS #1819349 Report a problem | ||
| 9/25/2024 | Listed for sale | $355,000+273.7%$121/sqft |
Source: Cincy MLS #1819349 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,267 +1% | $94,777 |
| 2023 | $6,205 +7.7% | $94,777 +33.5% |
| 2022 | $5,761 +0.2% | $70,998 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$2,129/mo
Principal & interest
$1624
Property taxes
$388
Home insurance
$117
Climate risks
Neighborhood: 45251
Nearby schools
GreatSchools rating
- 5/10Colerain Elementary SchoolGrades: K-5Distance: 0.9 mi
- 6/10Colerain Middle SchoolGrades: 6-8Distance: 0.9 mi
- 6/10Colerain High SchoolGrades: 9-12Distance: 1.2 mi
- Loading
- Loading
