Pending355d on market
4736 Alpine Ave
Cincinnati, OH, 45242 • 45242 • Hamilton County
$898,600
Down payment assistance available
5Beds
5Baths
0.25 acLot
Property DNA
Traditional Style
Traditional architecture
Outdoor Living
Patio
1 Fireplace
Gas · Great Room
2-Car Garage
Off Street · Driveway
Market activity
Demand and pricing signals for this listing
139 views
People checking out this listing
2 saves
Buyers have saved this home
355 days on market
Established listing
About this home
Single Family
Welcome to The Logan by John Henry Homes, not far from downtown Blue Ash and close to Montgomery and Kenwood. This 8 year tax abatement eligible new build is approximately 3,670 finished sf including 5 bedrooms and 4 & 1/2 baths. On the main level you can expect wainscoting in foyer, fireplace in great room, gourmet kitchen, quartz countertops, full overlay Aristokraft cabinets with quiet close doors and drawers, stainless steel appliances and hardwood throughout the first floor. Upstairs is the laundry room, 3 full baths and 4 bedrooms including the primary suite w/ a luxurious walk-in shower & raised tray ceiling. The 9' ceiling lower level has a 5th bedroom, 4th full bath, a versatile media/family room as well as ample storage. Construction complete late summer 2026.
Standout features identified
Our analysis highlights raised tray ceiling, full overlay aristokraft cabinets, and stainless steel appliances as key attractions of this home.
Estimated monthly payment
Based on current rates
$5,619/month
Principal & Interest$4,421
Property Tax$899
Insurance$300
Down payment20% ($179,720)
3%50%
Est. 6.24% rate · 30yr fixed · $718,880 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
HeatingGas
CoolingCentral Air
Parking2 Garage spaces
Lot0.25 Acres
Days on Zillow355 Days
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleTraditional
Stories2
Systems
HeatingGas
CoolingCentral Air
RoofShingle
ConstructionFiber Cement
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingOff Street, Driveway
Garage2 spaces
BasementFull,Finished
Fireplaces1
Lot0.25 Acres
Location & Tax
Neighborhood45242
Annual tax$3,900
Parcel6120060047200
Bathrooms & Fees
Full baths4
Features & details
10 categories of property features
Interior Features
Interior
High Ceilings
Recessed Lighting
Appliances
Dishwasher
Microwave
Oven/Range
Gas Water Heater
Heating
Gas
Cooling
Central Air
Fireplace
Gas
Great Room
Windows
Insulated Windows
Exterior Features
Parking
Off Street
Driveway
Construction
Fiber Cement
Patio & Porch
Patio
Gas
Natural
Room details
16 rooms detailed
Master Bedroom
Second20×14 ft280 sqft
Walk-In Closet(s)Wall-to-Wall Carpet
Bedroom2
Second13×12 ft156 sqft
Bedroom3
Second13×12 ft156 sqft
Bedroom4
Second13×13 ft169 sqft
Bedroom5
Lower12×16 ft192 sqft
Master Bathroom
ShowerDouble Vanity
Listing insights
Market data and value estimates
StatusPending
Days on market355
Tax rate1.45%
On marketMar 28, 2025
PostedApr 18, 2025
Last sold$140,000
MLS updatedMar 23, 2026
Tour days6
Views139
Favorites2
How are the schools in Cincinnati?
3 schools rated nearby
Location
Cincinnati, OH, 45242
Price history
8 events
DateEventPrice$/sqftSource
Mar 11, 2026Pending Sale$898,600—Cincy MLS
Mar 28, 2025Listed For Sale$898,600—Cincy MLS
Apr 18, 2016Sold$140,000—Cincy MLS
Mar 9, 2016Pending Sale$150,000—Comey & Shepherd
Jan 19, 2016Price Change$150,000—Comey & Shepherd
Oct 30, 2015Price Change$157,900—Comey & Shepherd
Sep 24, 2015Price Change$162,900—Comey & Shepherd
Aug 24, 2015Listed For Sale$169,900—Comey & Shepherd
Pending Sale$898,600
Mar 11, 2026•Cincy MLS
Listed For Sale$898,600
Mar 28, 2025•Cincy MLS
Sold$140,000
Apr 18, 2016•Cincy MLS
Pending Sale$150,000
Mar 9, 2016•Comey & Shepherd
Price Change$150,000
Jan 19, 2016•Comey & Shepherd
Price Change$157,900
Oct 30, 2015•Comey & Shepherd
Price Change$162,900
Sep 24, 2015•Comey & Shepherd
Listed For Sale$169,900
Aug 24, 2015•Comey & Shepherd
Tax history
24 years of records
YearTax paidAssessed value
Apr 8, 2024$3,900$91,718
Apr 8, 2023$3,914$91,718
Apr 8, 2022$2,894$56,350
Apr 8, 2021$2,997$56,350
Apr 8, 2020$2,854$56,350
Apr 8, 2019$2,709$49,000
Apr 8, 2018$2,846$49,000
Apr 8, 2017$2,424$49,000
Apr 8, 2016$2,540$53,568
Apr 8, 2015$2,419$53,568
Apr 8, 2014$2,427$53,568
Apr 8, 2013$2,425$52,007
Apr 8, 2012$2,430$52,007
Apr 8, 2011$2,390$52,007
Apr 8, 2010$2,486$56,312
Apr 8, 2009$2,401$56,312
Apr 8, 2008$2,342$56,312
Apr 8, 2007$2,353$55,755
Apr 8, 2006$2,345$55,755
Apr 8, 2005$2,341$55,755
Apr 8, 2003$1,820$43,820
Apr 8, 2002$1,836$43,820
Apr 8, 2001$1,785$39,620
Apr 8, 2000$1,727$39,620
Nearby homes
Neighborhood details
Local context around this listing
Cincinnati, OH • Hamilton County
Nearby cities
Blue AshBridgetownCincinnatiClevesForest ParkHarrisonLovelandMontgomery
Nearby zip codes
452364524145242
Similar homes
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 Zillow, Inc. 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. Zillow, Inc. 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
No obligation · Same-day response