0 ft
Distance
Hap's Irish Pub is a popular nightlife spot located at 3510 Erie Avenue in Cincinnati, Ohio. This pub is known for its lively atmosphere and authentic Irish charm. Whether you're looking to enjoy a few drinks with friends or catch up over a pint of Guinness, Hap's Irish Pub is the place to be. With its convenient location and welcoming ambiance, it's no wonder why locals and visitors alike flock to this establishment. The pub can be contacted at +1-513-871-6477. Hap's Irish Pub is open from Sunday to Friday, from 12:00 PM to 2:30 AM, and on Saturdays from 9:00 AM to 2:30 AM. Don't miss out on the fun and vibrant experience that Hap's Irish Pub has to offer!
| Address | Bed / Bath | Listing Price |
|---|---|---|
3635 Ault Park Avenue
Less than five minutes from Ault Park, this beautifully designed home by Classic Living Homes fits seamlessly into Hyde Park while offering all the advantages of brand new construction. The lower level features a two-car garage, a versatile family room or home office, a full bath, and a wet bar, wit
Living Area:
3267 Sqft.
|
3
Beds,
5
Baths
|
$1,289,000 |
5087 Bouchaine Way
Nestled in a peaceful, scenic setting with sweeping valley views, this beautifully updated home offers timeless elegance, exceptional space and effortless comfort. A grand open entry welcomes you into rich hardwood floors with custom inlay, leading to inviting living and dining areas with a wet bar
Living Area:
3620 Sqft.
|
3
Beds,
4
Baths
|
$850,000 |
3615 Old Red Bank Road
A must-see, adorable renovated home offering 3-4 bedrooms, 2 full baths, and over 1,600 sq. ft. of living space. Step into the open floor plan featuring beautiful wood floors. The completely updated kitchen includes granite countertops and newer stainless steel appliances. The main floor offers a be
Living Area:
1291 Sqft.
|
3
Beds,
2
Baths
|
$334,900 |
3161 Niles Street
Open House Sunday 12- 1! Incredible home in Mt. Lookout! Perfectly situated on a quiet, tree-lined street just moments from Mt. Lookout Square, Ault Park and Hyde Park Square, this residence blends timeless charm with modern sophistication. The kitchen boasts quartz countertops, stainless steel appl
Living Area:
1861 Sqft.
|
4
Beds,
3
Baths
|
$575,000 |
4213 Thirty Third Avenue
Truly a one of a kind gem in the heart of Oakley. Steps to Oakley square, Rookwood, Factory 52, Homearama, etc. Minutes to downtown. Fully remodeled home ready for a new owner! Original hardwood flooring and trim work. Original built in butler's pantry. New wiring, plumbing, HVAC, ductless. Brand ne
Living Area:
Sqft.
|
3
Beds,
3
Baths
|
$589,000 |
1065 Delta Avenue
Walkability! One block to the Square! New hardwood floors on main floor, new kitchen with quartz and new appliances. Half bath and laundry added by current owner on 1st floor. Both full baths updated. Fresh paint everywhere. Previous owner took care of all the big items. Roof, HVAC, chimney, windows
Living Area:
1923 Sqft.
|
4
Beds,
3
Baths
|
$550,000 |
4153 Paxton Woods Lane
Welcome home to this beautifully maintained cape cod that offers 3 bedrooms, 3 full baths* The updated kitchen features sleek granite countertops, stainless steel appliances and flows seamlessly into the main living areasideal for entertaining*Gorgeous deck, and fully fenced yard*Partially finished
Living Area:
1727 Sqft.
|
3
Beds,
3
Baths
|
$465,000 |
3414 Oak Lane
Great location on a dead end street that ends at the Country Club golf course. Beautiful large updated kitchen that opens to the dining room and family room. Very nice hardwood floors and large deck updated with new flooring and railing in 2024. Widened driveway and new retaining wall to the gara
Living Area:
1584 Sqft.
|
3
Beds,
2
Baths
|
$485,000 |
3110 Kinmont Street
Beautiful and charming Hyde Park Tudor just a short walk to Mt. Lookout Square shops, salons and restaurants including new a Italian cafe, and a wine bar. This home features a fully installed first-floor bathroom, an updated kitchen with granite countertops and stainless-steel appliances, plus the o
Living Area:
1330 Sqft.
|
2
Beds,
2
Baths
|
$498,900 |
3524 Brotherton Road
Welcome to modern new construction living in Oakley. LEED GOLD TAX ABATEMENT offering Sleek finishes & thoughtfully designed. The second level features an open concept gourmet kitchen, dining area, and great room with walkout to private fenced yard. The great room is anchored by a sleek fireplace, f
Living Area:
2229 Sqft.
|
3
Beds,
4
Baths
|
$639,000 |
3702 Brotherton Road
Fall in love with this cozy, light-filled 3-bedroom home offering classic cottage charm in a wonderfully friendly neighborhood! Hardwood floors flow through the main living spaces, complemented by a formal dining room and an updated kitchen with newer appliances and stylish butcher block counters. E
Living Area:
1344 Sqft.
|
3
Beds,
1
Bath
|
$315,000 |
3645 Russell Avenue
Fantastic living with wonderful updates including newly renovated kitchen, new fixtures, new appliances, new windows, new roof, new HVAC & so much more. Lovely hardwood floors throughout, new kitchen flooring, and a new 1st floor full bathroom. Enjoy the open concept kitchen with Quartz countertops
Living Area:
2290 Sqft.
|
4
Beds,
2
Baths
|
$475,000 |
2922 Utopia Place
Wow - check this out! Quiet cul-de-sac just blocks to HP or ML Square! Rare first floor 20' primary bedroom with luxury skylit bath and walk-in double closet - exceptional stainless and granite entertainers kitchen with counter bar opens to back yard - home office - private fenced rear lawn with spa
Living Area:
1888 Sqft.
|
3
Beds,
2
Baths
|
$469,900 |
3785 Drake Avenue
Quintessential Oakley charmer on one of Oakley's premier streets, featuring a spacious front porch with tree-lined views of Oakley's most walkable part of its neighborhood. Lovingly maintained, this home is truly move-in ready with an upgraded kitchen, stunning natural woodwork, Rookwood fireplace,
Living Area:
1663 Sqft.
|
4
Beds,
1
Bath
|
$419,000 |
3917 Paxton Avenue
Beautiful new construction 4 bed, 2/2 bath, 3,200sqft home located in a highly walkable neighborhood. The gourmet kitchen boasts an impressive 11' island, ideal for cooking and entertaining. Elegant hardwood floors run throughout the open, spacious living room with a cozy fireplace. Additional highl
Living Area:
3200 Sqft.
|
4
Beds,
4
Baths
|
$1,050,000 |
4515 Camberwell Road
Welcome Home to this 1600 sqft 4 bedroom home. 2 renovated full baths on 1st floor. 2025 updates include: New HAVC & Water Heater, Gleaming refinished hardwood floors, 2nd floor window A/C. Primary bedroom on 1st Floor is a house addition w/separate, entry door and the full bath renovati
Living Area:
1600 Sqft.
|
4
Beds,
2
Baths
|
$375,000 |
4515 Camberwell Road
Welcome Home to this 1600 sqft 4 bedroom home. 2 renovated full baths on 1st floor. 2025 updates include: New HAVC & Water Heater, Gleaming refinished hardwood floors, 2nd floor window A/C. Primary bedroom on 1st Floor is a house addition w/separate, entry door and the full bath renovati
Living Area:
1600 Sqft.
|
4
Beds,
2
Baths
|
$375,000 |
4120 Maple Drive
Welcome home to this super cute 2-bedroom, 1-bath charmer tucked away on a quiet cul-de-sac with a wooded, private lot! Step inside to find beautiful hardwood floors, a bright open living and family room, and an updated kitchen featuring granite counters and fully applianced kitchen. Enjoy peace of
Living Area:
1123 Sqft.
|
2
Beds,
1
Bath
|
$343,900 |
5754 Nightingale Court
Welcome home to this over 1,400 sq ft brick ranch featuring 2 FULL bathrooms, kitchen with granite and stainless steel appliances, an inviting family room with fireplace, walk out and plenty of natural light. The versatile study or dressing area offers flexibility for your lifestyle ? perfect for
Living Area:
1429 Sqft.
|
3
Beds,
2
Baths
|
$259,900 |
2853 Markbreit Avenue
Heart of Oakley - this updated 4 bedroom, 1.5 bathroom offers warmth, coziness and charm! Hardwood floors, large windows with tons of natural light, expansive outside entertaining area with composite decking, fully finished third floor bedroom/bonus room with mini split for constant comfort, spaciou
Living Area:
1552 Sqft.
|
4
Beds,
2
Baths
|
$460,000 |
4214 Marburg Avenue
Welcome to this 2 bedroom, 2 bathroom single family home just minutes from Oakley Square & Rookwood Commons. Featuring hardwood floors, updated kitchen with granite countertops & stainless steel appliances, tastefully updated bathrooms, finished basement & 2-car garage!
Living Area:
995 Sqft.
|
2
Beds,
2
Baths
|
$299,000 |
4214 Marburg Avenue
Welcome to this 2 bedroom, 2 bathroom single family home just minutes from Oakley Square & Rookwood Commons. Featuring hardwood floors, updated kitchen with granite countertops & stainless steel appliances, tastefully updated bathrooms, finished basement & 2-car garage!
Living Area:
995 Sqft.
|
2
Beds,
2
Baths
|
$299,000 |
1227 Corbett Street
Stunning new construction in heart of Hyde Park! 2,764 sqft finished. LEED Gold tax abatement eligible(15 years)! One of the last 15 year tax abatements (new starts now only 5 years). Save estimated $1k/month. Open flr plan w/natural light & spacious rooms!High end finishes!LL recreation room & bedr
Living Area:
1981 Sqft.
|
4
Beds,
4
Baths
|
$1,150,000 |
3460 Custer Avenue
Impeccably maintained & architecturally distinctive, this home enjoys a premier location with Ault Park as your neighbor. The first floor primary bedroom & bath adjoined by cozy sitting room/den with a gas fireplace. Great flow for entertaining, the generous living spaces connect to a beautiful land
Living Area:
1944 Sqft.
|
3
Beds,
3
Baths
|
$695,000 |
5112 Shattuc Avenue
Stunning Little Miami valley views from this custom-built one-owner villa! Soaring ceiling height throughout, filled with natural light. Inviting 28x16 screened porch. LEED Platinum construction with geothermal heating and cooling, solar panels, rain collection lawn sprinkler system. Elevator. Panel
Living Area:
4816 Sqft.
|
4
Beds,
3
Baths
|
$1,695,000 |
3255 Linwood Avenue
This beautiful home is situated a short walk to all the amazing options in Mount Lookout Square, like Delwood and VV Italian. The new exterior paint, roof, gutters, and various interior updates make this a space you will love to call home! The abundant outdoor and interior living spaces make it grea
Living Area:
2721 Sqft.
|
4
Beds,
2
Baths
|
$690,000 |
3847 Drake Avenue
Gold LEED Tax Abatement through 2038. Step into this beautifully updated end-unit townhome offering 4 bedrooms, 3.5 bathrooms, and modern finishes throughout-all new in 2023. Designed with space and light in mind, this home features soaring ceilings and oversized Pella windows that create a bright,
Living Area:
2042 Sqft.
|
4
Beds,
4
Baths
|
$765,000 |
3847 Drake Avenue
Gold LEED Tax Abatement through 2038. Step into this beautifully updated end-unit townhome offering 4 bedrooms, 3.5 bathrooms, and modern finishes throughout-all new in 2023. Designed with space and light in mind, this home features soaring ceilings and oversized Pella windows that create a bright,
Living Area:
2042 Sqft.
|
4
Beds,
4
Baths
|
$765,000 |
3122 Kinmont Street
Just blocks from Mt. Lookout Square, this home offers hardwood floors, a full basement, and additional off-street parking. The fenced yard and deck are perfect for outdoor entertaining. Low-maintenance with plenty of character, it's an ideal starter home or investment!
Living Area:
748 Sqft.
|
2
Beds,
1
Bath
|
$279,900 |
5581 Nightingale Court
Welcome to this stunning ranch in the Mariemont School district! Beautifully renovated with attention to detail, this 3-bedroom, 2-bathroom home is perfect for those seeking a comfortable and stylish living space. Refinished hard wood floors throughout. The finished basement and new expansive back d
Living Area:
1525 Sqft.
|
3
Beds,
2
Baths
|
$284,900 |
3655 Brotherton Road
Save $893 per month according to the County Auditor with a tax abatement through 2032, making this LEED Gold-certified home both a smart financial and sustainable choice. Save even more on utilities. Built with superior insulation and eco-friendly systems, it delivers healthier air and drastically r
Living Area:
2424 Sqft.
|
3
Beds,
4
Baths
|
$629,900 |
3211 Bach Avenue
4.5% interest rate available for qualified buyers. 15 yr LEED Gold tax abatement eligible ($180,000 in prop tax savings)! Brand new home just seconds from everything in Oakley! You can have it all: 2,544 finished sqft, great rm w/ fireplace, gourmet kitchen, formal dining rm, primary suite w/ walk-i
Living Area:
2544 Sqft.
|
3
Beds,
3
Baths
|
$825,000 |
3309 Bach Avenue
4.5% interest rate available for qualified buyers. Brand new home just seconds from everything in Oakley! You can have it all: 1,759 finished sqft (w/ option to finish LL), hardwood flrs, great rm w/ fireplace, gourmet kitchen, primary suite w/ walk-in clst, high end finishes, 2 car garage, rear de
Living Area:
1783 Sqft.
|
3
Beds,
3
Baths
|
$765,000 |
3410 Brotherton Avenue
4.5% interest rate available for qualified buyers. Brand new home just seconds from everything in Oakley! You can have it all: 1,783 finished sqft (w/ option to finish LL), hardwood flrs, great rm w/ fireplace, gourmet kitchen, primary suite w/ walk-in clst, high end finishes, 2 car garage, rear de
Living Area:
1783 Sqft.
|
3
Beds,
3
Baths
|
$765,000 |
3259 Berwyn Place
4.5% interest rate available for qualified buyers. 15 yr LEED Gold tax abatement eligible! Brand new home just seconds from everything in Oakley! You can have it all: 2,590 finished sqft (w/ option to finish LL), hardwood flrs, great rm w/ fireplace, gourmet kitchen, formal dining rm, primary suite
Living Area:
2590 Sqft.
|
3
Beds,
3
Baths
|
$859,000 |
3550 Linwood Avenue
Black Friday sale - $10,000 off through end of the year! Discover the perfect blend of modern style and smart investment in this brand new home built by Ashford Homes. Enjoy 15 years of tax abatement, making ownership even more affordable. At 1878 sqft enjoy 3 spacious bedrooms, 2.5 bathrooms, and a
Living Area:
1878 Sqft.
|
3
Beds,
3
Baths
|
$800,000 |
4926 Le Blond Avenue
Come see this charming home now on the market! This home has Fresh Interior Paint. A fireplace and a soft neutral color palette create a solid blank canvas for the living area. Step into the kitchen, complete with an eye catching stylish backsplash.The primary bathroom features plenty of under sink
Living Area:
1280 Sqft.
|
2
Beds,
2
Baths
|
$400,000 |