Horanrosenhagen.com Search Results

$429,000

Step Into a Lifestyle of Sophistication and Luxury with This One-of-a-Kind Italianate Masterpiece Spanning Three Levels of Meticulously Renovated Living Space (2,245 Sq. Ft.), This 4-Bedroom, 4-Bathroom (3-FULL BATHS, 1-HALF BATH) Residence Optimally Blends Timeless Architectural Character with Premium Modern Conveniences. Ideally Located Just Minutes From the Best of Downtown Cincinnati, Newport On The Levee, Newport Pavilion, Ovation, and the Fairfield Ave Entertainment District, This Home Offers The Pinnacle of Elegant Urban Living. Architectural Excellence & Modern Comfort Abound. This ''Timeless Jewel'' Boasts a Stately All-Brick Exterior, Thoughtful Design, High Ceilings, Custom Railings, Cased Windows, Exquisite Finishes and State-of-the-Art Improvements Throughout. The Welcoming Living Room Features a Gorgeous Stone Fireplace, While the Spectacular Kitchen is a Cook's Paradise Complete with Upscale White Cabinetry, Expansive Granite Counters and Island, Stainless Steel Appliances, Gas Range, Handcrafted Bookcase, and a Side Walkout Leading to a Partially Covered Patio, Offering Indoor-Outdoor Living, Perfect For Hosting. Beyond, Discover a Park-Like Oasis Enclosed by a Secure Privacy Fence--a Rare, Tranquil Retreat in the Heart of the City. The Primary Suite: A Spacious Escape Featuring a Flexible Bonus Area--Perfect for a Sitting Area, Nursery, Dressing Area, or a Home Office--and in Addition a Private Adjoining Full Bath. Luminous Spaces are Abundant with Oversized Windows Providing Natural Light, Complemented by a Wealth of Recessed and Remarkable Overhead Lighting. Modern Amenities Include All-New Contemporary Bathrooms, Generously Sized Rooms, First-Floor Laundry, and a Fresh Neutral Palette. The Ultimate Perk: Desirable Off-Street Parking--a Total Game-Changer for the Area! This Move-in-Ready Sanctuary is Designed for Those Who Appreciate Open, Light-Filled, Spaces, Luxurious Finishes and Want to be Minutes From the City's Best Attractions.

4 Beds ⋅ 4 Baths ⋅ 646567 MLS

Step Into a Lifestyle of Sophistication and Luxury with This One-of-a-Kind Italianate Masterpiece Spanning Three Levels of Meticulously Renovated Living Space (2,245 Sq. Ft.), This 4-Bedroom, 4-Bathroom (3-FULL BATHS, 1-HALF BATH) Residence Optimally Blends Timeless Architectural Character with Premium Modern Conveniences. Ideally Located Just Minutes From the Best of Downtown Cincinnati, Newport On The Levee, Newport Pavilion, Ovation, and the Fairfield Ave Entertainment District, This Home Offers The Pinnacle of Elegant Urban Living. Architectural Excellence & Modern Comfort Abound. This ''Timeless Jewel'' Boasts a Stately All-Brick Exterior, Thoughtful Design, High Ceilings, Custom Railings, Cased Windows, Exquisite Finishes and State-of-the-Art Improvements Throughout. The Welcoming Living Room Features a Gorgeous Stone Fireplace, While the Spectacular Kitchen is a Cook's Paradise Complete with Upscale White Cabinetry, Expansive Granite Counters and Island, Stainless Steel Appliances, Gas Range, Handcrafted Bookcase, and a Side Walkout Leading to a Partially Covered Patio, Offering Indoor-Outdoor Living, Perfect For Hosting. Beyond, Discover a Park-Like Oasis Enclosed by a Secure Privacy Fence--a Rare, Tranquil Retreat in the Heart of the City. The Primary Suite: A Spacious Escape Featuring a Flexible Bonus Area--Perfect for a Sitting Area, Nursery, Dressing Area, or a Home Office--and in Addition a Private Adjoining Full Bath. Luminous Spaces are Abundant with Oversized Windows Providing Natural Light, Complemented by a Wealth of Recessed and Remarkable Overhead Lighting. Modern Amenities Include All-New Contemporary Bathrooms, Generously Sized Rooms, First-Floor Laundry, and a Fresh Neutral Palette. The Ultimate Perk: Desirable Off-Street Parking--a Total Game-Changer for the Area! This Move-in-Ready Sanctuary is Designed for Those Who Appreciate Open, Light-Filled, Spaces, Luxurious Finishes and Want to be Minutes From the City's Best Attractions.

139 Washington Avenue, Bellevue

$529,000

Experience one of Bellevue's most unique residences! Located in a beautifully converted historic St. Anthony church, this stunning second-floor condo blends incredible original character with an open, modern layout. Beautiful hardwood floors, soaring ceilings, massive stained-glass windows, and original church woodwork create a space unlike anything else on the market. The open kitchen flows seamlessly into the impressive main living area, while the loft-style bedroom features an en-suite bath and walk-in closet. One of the home's most remarkable features is the original bell tower--complete with a functional church bell! Additional amenities include a private basement storage unit, spacious common basement area, and detached garage. A truly one-of-a-kind opportunity to own a piece of Bellevue history while enjoying the convenience of condo living.

2 Beds ⋅ 2 Baths ⋅ 645957 MLS

Experience one of Bellevue's most unique residences! Located in a beautifully converted historic St. Anthony church, this stunning second-floor condo blends incredible original character with an open, modern layout. Beautiful hardwood floors, soaring ceilings, massive stained-glass windows, and original church woodwork create a space unlike anything else on the market. The open kitchen flows seamlessly into the impressive main living area, while the loft-style bedroom features an en-suite bath and walk-in closet. One of the home's most remarkable features is the original bell tower--complete with a functional church bell! Additional amenities include a private basement storage unit, spacious common basement area, and detached garage. A truly one-of-a-kind opportunity to own a piece of Bellevue history while enjoying the convenience of condo living.

320 Poplar Street, Bellevue

$339,000

Welcome to 310 Berry Street, an adorable, recently renovated home in the heart of Dayton! This charming 3 bedroom, 2 full bath home offers the perfect combination of character, modern updates, and a convenient location just steps from everything happening along the riverfront. Step inside to find spacious rooms filled with natural light and beautiful views of the Ohio hillsides. The first floor features a large bedroom and full bath, along with a generous living room that opens to an oversized eat-in kitchen with granite countertops, stainless steel appliances, and plenty of space for gathering and entertaining. Upstairs you'll find another spacious bedroom, a third bedroom perfect for a home office or guest room with a large closet, and a second full bath. Extensive renovations provide added peace of mind, including updated mechanicals, HVAC, plumbing, electrical, roof, and more. Outside is just as inviting, starting with the classic white picket fence and welcoming curb appeal. A new driveway and patio provide great outdoor space, while the existing carport with pergola offers excellent potential for conversion to a garage. Located just steps from Riverfront Commons Trail, parks, neighborhood amenities, restaurants, parks, and beautiful river and hillside views, 310 Berry offers move-in-ready living in one of Northern Kentucky's most exciting river cities. Cute, updated, and ready to make your own!

3 Beds ⋅ 2 Baths ⋅ 645605 MLS

Welcome to 310 Berry Street, an adorable, recently renovated home in the heart of Dayton! This charming 3 bedroom, 2 full bath home offers the perfect combination of character, modern updates, and a convenient location just steps from everything happening along the riverfront. Step inside to find spacious rooms filled with natural light and beautiful views of the Ohio hillsides. The first floor features a large bedroom and full bath, along with a generous living room that opens to an oversized eat-in kitchen with granite countertops, stainless steel appliances, and plenty of space for gathering and entertaining. Upstairs you'll find another spacious bedroom, a third bedroom perfect for a home office or guest room with a large closet, and a second full bath. Extensive renovations provide added peace of mind, including updated mechanicals, HVAC, plumbing, electrical, roof, and more. Outside is just as inviting, starting with the classic white picket fence and welcoming curb appeal. A new driveway and patio provide great outdoor space, while the existing carport with pergola offers excellent potential for conversion to a garage. Located just steps from Riverfront Commons Trail, parks, neighborhood amenities, restaurants, parks, and beautiful river and hillside views, 310 Berry offers move-in-ready living in one of Northern Kentucky's most exciting river cities. Cute, updated, and ready to make your own!

310 Berry Street, Dayton

$275,000

Opportunity is knocking with this spacious 3-bedroom, 2-bath home ! Whether you're looking for your next home to personalize or an investment property with great potential, this one offers a solid foundation and endless possibilities. The functional floor plan provides plenty of living space, while the home's character is still tact. Original hardwood floors are believed to be underneath the upstairs carpet, giving you the opportunity to restore their timeless beauty. The main level features durable vinyl and tile flooring for easy maintenance. Enjoy added peace of mind knowing the central air system was just replaced in 2025. The home is heated by two furnaces, allowing separate heating for the upstairs and downstairs for added comfort and efficiency. With generous room sizes, great bones, and so much potential, this property is the perfect blank canvas to create the home you've always envisioned. Conveniently laid out with three bedrooms and two full bathrooms, there's plenty of space for family, guests, or a home office.. Homes with this much potential don't come around often--schedule your showing today and imagine the possibilities!

3 Beds ⋅ 2 Baths ⋅ 645118 MLS

Opportunity is knocking with this spacious 3-bedroom, 2-bath home ! Whether you're looking for your next home to personalize or an investment property with great potential, this one offers a solid foundation and endless possibilities. The functional floor plan provides plenty of living space, while the home's character is still tact. Original hardwood floors are believed to be underneath the upstairs carpet, giving you the opportunity to restore their timeless beauty. The main level features durable vinyl and tile flooring for easy maintenance. Enjoy added peace of mind knowing the central air system was just replaced in 2025. The home is heated by two furnaces, allowing separate heating for the upstairs and downstairs for added comfort and efficiency. With generous room sizes, great bones, and so much potential, this property is the perfect blank canvas to create the home you've always envisioned. Conveniently laid out with three bedrooms and two full bathrooms, there's plenty of space for family, guests, or a home office.. Homes with this much potential don't come around often--schedule your showing today and imagine the possibilities!

311 6th Avenue, Dayton

$449,900

Bellevue homeowners, before you start touring subdivisions an hour away -- look at this first. 363 Berry Ave proves you can have the space your family needs without giving up the neighborhood you already love. Tucked in the historic Taylor's Daughters district, just three blocks from the Avenue, this 5-bedroom, 3-bath brick home spreads living space across three full stories -- with bedrooms on every level and a first-floor primary suite that makes multi-generational living or hosting guests effortless. No more fighting over square footage. No more choosing between ''more room'' and ''everything I love is a walk away.'' Inside, the kitchen is the heart of it: 42'' cabinets, granite counters, a spacious island, and stainless appliances. Beyond the kitchen, the home's bones tell a different story -- 8-foot mahogany doors, 10-foot ceilings, exposed original brick, pocket doors, and a staircase that's been part of this house since 1900. It's not a flip. It's a home that's been cared for, and it shows. Practical updates matter too: a 3-stage Everdry waterproofing system in the basement and a newer furnace mean the character comes without the headaches. Step outside to an enclosed porch and hot tub for the nights you just want to unwind at home instead of driving somewhere else to relax. Walk to Bellevue's restaurants, shops, and bars. Be in downtown Cincinnati in under five minutes. Stay rooted in the community you know -- with room to grow into. 363 Berry Ave. Bellevue living, without the compromise.

5 Beds ⋅ 3 Baths ⋅ 644772 MLS

Bellevue homeowners, before you start touring subdivisions an hour away -- look at this first. 363 Berry Ave proves you can have the space your family needs without giving up the neighborhood you already love. Tucked in the historic Taylor's Daughters district, just three blocks from the Avenue, this 5-bedroom, 3-bath brick home spreads living space across three full stories -- with bedrooms on every level and a first-floor primary suite that makes multi-generational living or hosting guests effortless. No more fighting over square footage. No more choosing between ''more room'' and ''everything I love is a walk away.'' Inside, the kitchen is the heart of it: 42'' cabinets, granite counters, a spacious island, and stainless appliances. Beyond the kitchen, the home's bones tell a different story -- 8-foot mahogany doors, 10-foot ceilings, exposed original brick, pocket doors, and a staircase that's been part of this house since 1900. It's not a flip. It's a home that's been cared for, and it shows. Practical updates matter too: a 3-stage Everdry waterproofing system in the basement and a newer furnace mean the character comes without the headaches. Step outside to an enclosed porch and hot tub for the nights you just want to unwind at home instead of driving somewhere else to relax. Walk to Bellevue's restaurants, shops, and bars. Be in downtown Cincinnati in under five minutes. Stay rooted in the community you know -- with room to grow into. 363 Berry Ave. Bellevue living, without the compromise.

363 Berry Avenue, Bellevue