Don't miss the Logan by John Henry Homes, offering approximately 3,519 finished square feet with 5 bedrooms, 4.5 baths plus an 8 year tax abatement in Blue Ash. The main level features elegant wainscoting in the foyer, a cozy fireplace in the great room, and a gourmet kitchen with quartz countertops, Aristokraft soft-close cabinetry, stainless steel appliances, a walk-in pantry, and hardwood floors. Upstairs includes four spacious bedrooms, highlighted by a primary suite with a tray ceiling and walk-in shower, plus two other full baths and a convenient laundry room. The finished lower level offers 9-ft ceilings, a fifth bedroom, full bath, media/family room, and ample storage. Enjoy a covered patio off the dining area. Ideally located just minutes from the restaurants and shops of downtown Blue Ash, this home is only a block from the YMCA and offers quick, convenient access to Cross County Highway for an easy commute anywhere you need to go. Estimated completion early 2027.
New construction
$924,900
4722 Alpine Ave, Cincinnati, OH 45242
5beds
3,519sqft
Single Family Residence
Built in ----
10,367 Square Feet Lot
$-- Zestimate®
$263/sqft
$-- HOA
What's special
Four spacious bedroomsAristokraft soft-close cabinetryStainless steel appliancesWalk-in pantryHardwood floorsAmple storageConvenient laundry room
- 79 days |
- 343 |
- 7 |
Zillow last checked:
Listing updated:
Listed by:
Robert Hines 513-260-0428,
Coldwell Banker Realty 513-321-9944,
Michael P Hines 513-260-0424,
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1872729
Originating MLS: Cincinnati Area Multiple Listing Service

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet
- Level: Second
- Area: 280
- Dimensions: 20 x 14
Bedroom 2
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 3
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 5
- Level: Lower
- Area: 132
- Dimensions: 12 x 11
Primary bathroom
- Features: Built-In Shower Seat, Shower, Tile Floor, Double Vanity
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Second
Bathroom 4
- Features: Full
- Level: Lower
Dining room
- Features: Walkout, Wood Floor
- Level: First
- Area: 165
- Dimensions: 15 x 11
Family room
- Area: 0
- Dimensions: 0 x 0
Great room
- Features: Fireplace, Wood Floor
- Level: First
- Area: 360
- Dimensions: 20 x 18
Kitchen
- Features: Pantry, Quartz Counters, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Floor
- Area: 288
- Dimensions: 18 x 16
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Features: French Doors, Wood Floor
- Level: First
- Area: 110
- Dimensions: 11 x 10
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Oven/Range, Gas Water Heater
Features
- High Ceilings, Recessed Lighting
- Doors: Multi Panel Doors
- Basement: Full,Finished
- Number of fireplaces: 1
- Fireplace features: Insert, Gas, Great Room
Interior area
- Total structure area: 3,519
- Total interior livable area: 3,519 sqft
Property
Parking
- Total spaces: 2
- Parking features: Off Street, Driveway, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio
Lot
- Size: 10,367 Square Feet
- Dimensions: 52 x 188 IRR
- Features: Less than .5 Acre
Details
- Parcel number: NEW/UNDER CONST/TO BE BUILT
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Fiber Cement
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: Yes
Details
- Builder name: John Henry Homes
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: $263/sqft
- Tax assessed value: $217,830
- Annual tax amount: $3,236
- Date on market: 4/2/2026
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 4/2/2026 | Listed for sale | $924,900+718.5%$263/sqft |
Source: | ||
| 4/14/2022 | Sold | $113,000$32/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $3,236 -0.4% | $76,241 |
| 2023 | $3,250 +13.4% | $76,241 +40.5% |
| 2022 | $2,867 +1.8% | $54,264 |
| 2021 | $2,817 | $54,264 |
| 2020 | $2,817 +10.2% | $54,264 +15% |
| 2019 | $2,557 +9.8% | $47,187 |
| 2018 | $2,327 | $47,187 |
| 2017 | $2,327 +11.9% | $47,187 +2.1% |
| 2016 | $2,080 | $46,200 |
| 2015 | $2,080 -0.3% | $46,200 |
| 2014 | $2,087 +0.1% | $46,200 +3% |
| 2013 | $2,085 -0.2% | $44,856 |
| 2012 | $2,089 +1.8% | $44,856 |
| 2011 | $2,053 -1.7% | $44,856 -5.4% |
| 2010 | $2,089 +3.6% | $47,404 |
| 2009 | $2,016 +2.5% | $47,404 |
| 2008 | $1,966 -0.5% | $47,404 +1% |
| 2007 | $1,976 +0.3% | $46,935 |
| 2006 | $1,969 +0.2% | $46,935 |
| 2005 | $1,966 +26.8% | $46,935 +25.6% |
| 2003 | $1,550 -0.9% | $37,380 |
| 2002 | $1,564 +2.8% | $37,380 +10.7% |
| 2001 | $1,521 +3.3% | $33,775 |
| 2000 | $1,472 | $33,775 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 45242
Nearby schools
GreatSchools rating
- 7/10Edwin H Greene Intermediate Middle SchoolGrades: 5-7Distance: 1.1 mi
- 9/10Sycamore High SchoolGrades: 9-12Distance: 3.3 mi
- 8/10Sycamore Junior High SchoolGrades: 7-8Distance: 0.7 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Ohio
- Hamilton County
- Blue Ash
- 45242
- 4722 Alpine Ave






