Horanrosenhagen.com Search Results

$849,800

This Spectacular 2,320 SQ FT High Rise Unit Has It All! Stunning 11th-Floor Residence in the Iconic Ascent Offers a Rare Blend of Architectural Significance & Luxury Living. This Exceptional 2 Bedroom, 2.5 Bath Condo with an Additional Room That Can Be Used as a Den or Third Bedroom Is Located in the Coveted 06 Stack & Showcases Soaring Ceilings and Dramatic Floor-to-Ceiling Windows on 3 Sides, Flooding the Space with Natural Light and Framing Breathtaking Panoramic Views of the Roebling Bridge, Cincinnati Skyline, Covington, and the Kentucky Hills. The Open Great Room Design Creates a Seamless Flow, Ideal for Both Entertaining & Everyday Living. The Chef's Kitchen Is Beautifully Updated with Quartz Countertops, a Stainless Gas Range, High-End Appliances, & a Large Island with Generous Seating. A Sophisticated Interior Palette, Bamboo Floors, Built-Ins, and Remote-Controlled Blinds Enhance the Space with Both Style and Convenience. Step Out to the Expansive Private Terrace & Experience True Indoor-Outdoor Living-Perfect for Morning Coffee, Evening Cocktails, or Taking in Spectacular Western & Southern/WEBN Fireworks at Riverfest & Cincinnati Reds Friday Night Fireworks Over the River & City Skyline. This Is Elevated Living at Its Finest. The Primary Suite Offers a Peaceful Retreat with Generous Space & a Luxury Bath, While the Additional Bedroom & Flexible Bonus Room Provide Options for Guests, a Home Office, or a Third Bedroom. A Dedicated Laundry Area Adds Everyday Ease. The Ascent, Designed by Daniel Libeskind, Offers Over 20,000 Sq Ft of Upscale Amenities Including 24/7 Concierge, Fitness Center, Pool/Spa, Theater, Wine Room, Business Center, Library, & Guest Suites. HOA Includes All Utilities Except Electric. Two Reserved Garage Spaces (C048 & C049) & Storage Unit (AS50). Walk to Dining, Parks, the Riverfront, & Professional Sporting Events-Home to the Cincinnati Reds and Cincinnati Bengals. Experience a Lifestyle That Blends Design, Comfort, & Unmatched Views

3 Beds ⋅ 3 Baths ⋅ 644789 MLS

This Spectacular 2,320 SQ FT High Rise Unit Has It All! Stunning 11th-Floor Residence in the Iconic Ascent Offers a Rare Blend of Architectural Significance & Luxury Living. This Exceptional 2 Bedroom, 2.5 Bath Condo with an Additional Room That Can Be Used as a Den or Third Bedroom Is Located in the Coveted 06 Stack & Showcases Soaring Ceilings and Dramatic Floor-to-Ceiling Windows on 3 Sides, Flooding the Space with Natural Light and Framing Breathtaking Panoramic Views of the Roebling Bridge, Cincinnati Skyline, Covington, and the Kentucky Hills. The Open Great Room Design Creates a Seamless Flow, Ideal for Both Entertaining & Everyday Living. The Chef's Kitchen Is Beautifully Updated with Quartz Countertops, a Stainless Gas Range, High-End Appliances, & a Large Island with Generous Seating. A Sophisticated Interior Palette, Bamboo Floors, Built-Ins, and Remote-Controlled Blinds Enhance the Space with Both Style and Convenience. Step Out to the Expansive Private Terrace & Experience True Indoor-Outdoor Living-Perfect for Morning Coffee, Evening Cocktails, or Taking in Spectacular Western & Southern/WEBN Fireworks at Riverfest & Cincinnati Reds Friday Night Fireworks Over the River & City Skyline. This Is Elevated Living at Its Finest. The Primary Suite Offers a Peaceful Retreat with Generous Space & a Luxury Bath, While the Additional Bedroom & Flexible Bonus Room Provide Options for Guests, a Home Office, or a Third Bedroom. A Dedicated Laundry Area Adds Everyday Ease. The Ascent, Designed by Daniel Libeskind, Offers Over 20,000 Sq Ft of Upscale Amenities Including 24/7 Concierge, Fitness Center, Pool/Spa, Theater, Wine Room, Business Center, Library, & Guest Suites. HOA Includes All Utilities Except Electric. Two Reserved Garage Spaces (C048 & C049) & Storage Unit (AS50). Walk to Dining, Parks, the Riverfront, & Professional Sporting Events-Home to the Cincinnati Reds and Cincinnati Bengals. Experience a Lifestyle That Blends Design, Comfort, & Unmatched Views

1 Roebling Way, Covington

$769,000

Welcome to THE ASCENT! Covington's premier residential building. Starchitect Daniel Libeskind has designed a unique and livable oasis. It's all about the VIEWS! This 2 bed, 2 1/2 bath stunner is situated at the prime center of the building overlooking the Roebling Bridge, Downtown Covington and onwards to Cincinnati. NEW oak flooring throughout and freshly painted. Kitchen with Sub-Zero fridge, Wolf range and large counter bar. This open living concept condo is ready for entertaining. If you are living in an oasis you need amenities! At the Ascent you will enjoy the gym, pool, sauna, massage room, library, theatre room, outdoor grill and patio with firepit, private dining room, climate-controlled wine tasting room, entertaining spaces, 2 guest suites, 24 hr security & concierge. Walkable location for all that downtown Covington has to offer with easy access across the bridge to sports and concert venues. 2 assigned garage parking spaces. Assigned storage unit.

2 Beds ⋅ 3 Baths ⋅ 644545 MLS

Welcome to THE ASCENT! Covington's premier residential building. Starchitect Daniel Libeskind has designed a unique and livable oasis. It's all about the VIEWS! This 2 bed, 2 1/2 bath stunner is situated at the prime center of the building overlooking the Roebling Bridge, Downtown Covington and onwards to Cincinnati. NEW oak flooring throughout and freshly painted. Kitchen with Sub-Zero fridge, Wolf range and large counter bar. This open living concept condo is ready for entertaining. If you are living in an oasis you need amenities! At the Ascent you will enjoy the gym, pool, sauna, massage room, library, theatre room, outdoor grill and patio with firepit, private dining room, climate-controlled wine tasting room, entertaining spaces, 2 guest suites, 24 hr security & concierge. Walkable location for all that downtown Covington has to offer with easy access across the bridge to sports and concert venues. 2 assigned garage parking spaces. Assigned storage unit.

1 Roebling Way, Covington

$249,900

Welcome to 1245 Highway Ave. Covington Ky. Where modern upgrades meet Comfort and Convenience. This Beautifully remodeled home. Offers approximately 2000 Sq Feet of living space with 3 Bedrooms and 2 fully updated Bathrooms! A 65 inch new color TV with 3 year warranty is included on a 70 inch TV stand with a 36'' Fireplace 12 color Electric fireplace with 5 dimmer levels and 12 Led color combos for a customizable viewing and heating experience. No detail has been overlooked in this complete transformation. Enjoy relaxing on the newly renovated front porch, with seasonal views then step inside to discover spacious rooms featuring new Lighting, flooring, doors, Carpeting and fresh paint throughout. Both Bathrooms have been completely remodeled with stylish finishes and MODERN FIXTURES. The stunning new kitchen is the heart of the Home. Featuring all new stainless steel appliances, Custom Cabinetry, Quartz countertops and plenty of space for cooking and entertaining. Additional major improvements include: New Roof Fresh interior Paint Two brand new HVAC systems with zoning capabilities Allowing separate temperature controls in different areas of the home for enhanced comfort and energy efficiency New Deck and Fencing All new Plumbing Countless additional updates Throughout This Beautiful Home 'Riverfront Commons' 11.5 miles of bicycle & walking trails along the Banks of the Ohio River is only blocks away. Enjoy being only Minutes from Downtown Cincinnati / Main Strausse Village/ Newport on the Levy and many more destinations. With convenient access to Everything. This truly move in ready property combines the charm of an established Neighborhood with the peace of mind that comes from extensive renovations and New Systems. Schedule your private showing today and see everything this exceptional home has to offer!

3 Beds ⋅ 2 Baths ⋅ 643833 MLS

Welcome to 1245 Highway Ave. Covington Ky. Where modern upgrades meet Comfort and Convenience. This Beautifully remodeled home. Offers approximately 2000 Sq Feet of living space with 3 Bedrooms and 2 fully updated Bathrooms! A 65 inch new color TV with 3 year warranty is included on a 70 inch TV stand with a 36'' Fireplace 12 color Electric fireplace with 5 dimmer levels and 12 Led color combos for a customizable viewing and heating experience. No detail has been overlooked in this complete transformation. Enjoy relaxing on the newly renovated front porch, with seasonal views then step inside to discover spacious rooms featuring new Lighting, flooring, doors, Carpeting and fresh paint throughout. Both Bathrooms have been completely remodeled with stylish finishes and MODERN FIXTURES. The stunning new kitchen is the heart of the Home. Featuring all new stainless steel appliances, Custom Cabinetry, Quartz countertops and plenty of space for cooking and entertaining. Additional major improvements include: New Roof Fresh interior Paint Two brand new HVAC systems with zoning capabilities Allowing separate temperature controls in different areas of the home for enhanced comfort and energy efficiency New Deck and Fencing All new Plumbing Countless additional updates Throughout This Beautiful Home 'Riverfront Commons' 11.5 miles of bicycle & walking trails along the Banks of the Ohio River is only blocks away. Enjoy being only Minutes from Downtown Cincinnati / Main Strausse Village/ Newport on the Levy and many more destinations. With convenient access to Everything. This truly move in ready property combines the charm of an established Neighborhood with the peace of mind that comes from extensive renovations and New Systems. Schedule your private showing today and see everything this exceptional home has to offer!

1245 Highway Avenue, Covington

$275,000

River Road parcel with existing structure, offered only as part of a larger contiguous 9-parcel development package with outstanding Ohio River and Cincinnati skyline views. This assemblage totals approximately 3.348 acres per available records and creates a rare opportunity for a builder, developer, or investor to pursue a larger redevelopment concept in Covington. Seller has never occupied the home and believes the structure is likely best suited for demolition. Value is primarily in the land, views, utilities at the street, and overall assemblage. Seller will not sell this parcel separately. Buyer to verify zoning, utilities, buildability, acreage, boundaries, floodplain status, access, and intended use. Full portfolio price is $275,000.

3 Beds ⋅ 2 Baths ⋅ 643377 MLS

River Road parcel with existing structure, offered only as part of a larger contiguous 9-parcel development package with outstanding Ohio River and Cincinnati skyline views. This assemblage totals approximately 3.348 acres per available records and creates a rare opportunity for a builder, developer, or investor to pursue a larger redevelopment concept in Covington. Seller has never occupied the home and believes the structure is likely best suited for demolition. Value is primarily in the land, views, utilities at the street, and overall assemblage. Seller will not sell this parcel separately. Buyer to verify zoning, utilities, buildability, acreage, boundaries, floodplain status, access, and intended use. Full portfolio price is $275,000.

103 River Road, Covington

$625,000

Luxury living in a premier Covington location offered at an incredible value. This 2-bedroom, 2.5-bath condo with flex space features upgraded finishes, beautiful views, wood floors in the living and kitchen areas, granite countertops, and a spacious primary suite with a thoughtfully designed bath. Expansive windows provide abundant natural light, enhancing the unit's warm and sophisticated feel. Enjoy resort-style amenities including an outdoor pool, fitness center, sauna, locker rooms, media room, wine lockers, and entertaining spaces. Walkable to Covington events, restaurants, and entertainment, this property offers an ideal blend of luxury and convenience. Schedule your showing today.

2 Beds ⋅ 3 Baths ⋅ 640816 MLS

Luxury living in a premier Covington location offered at an incredible value. This 2-bedroom, 2.5-bath condo with flex space features upgraded finishes, beautiful views, wood floors in the living and kitchen areas, granite countertops, and a spacious primary suite with a thoughtfully designed bath. Expansive windows provide abundant natural light, enhancing the unit's warm and sophisticated feel. Enjoy resort-style amenities including an outdoor pool, fitness center, sauna, locker rooms, media room, wine lockers, and entertaining spaces. Walkable to Covington events, restaurants, and entertainment, this property offers an ideal blend of luxury and convenience. Schedule your showing today.

1 Roebling Way, Covington

$1,250,000

This Spectacular 2nd floor unit in the Verandas at The Views - Cutting Edge Condominium Development is a Must See! Tucked away in the Hills of Covington offering Spectacular Cincinnati Skyline Views. Luxury Ranch Style Living w/Spacious Open Concept Layout, 10'+ Ceilings, HDWD Floors, Modern Décor, Premium Finishes. End unit in the building allows for more windows and plenty of natural light. 3 full bedrooms and an Expansive Covered Terrace Perfect for Entertaining Family & Friends, Parking Garage with 2 premium spots and Private Entry Elevator Access Directly to Unit. Amenities include Clubhouse, Infinity Edge Pool, Fitness Center & more! Great Location just minutes to Downtown Dining & Entertainment. Simply Stunning...come take a look and see Our View!

3 Beds ⋅ 3 Baths ⋅ 639788 MLS

This Spectacular 2nd floor unit in the Verandas at The Views - Cutting Edge Condominium Development is a Must See! Tucked away in the Hills of Covington offering Spectacular Cincinnati Skyline Views. Luxury Ranch Style Living w/Spacious Open Concept Layout, 10'+ Ceilings, HDWD Floors, Modern Décor, Premium Finishes. End unit in the building allows for more windows and plenty of natural light. 3 full bedrooms and an Expansive Covered Terrace Perfect for Entertaining Family & Friends, Parking Garage with 2 premium spots and Private Entry Elevator Access Directly to Unit. Amenities include Clubhouse, Infinity Edge Pool, Fitness Center & more! Great Location just minutes to Downtown Dining & Entertainment. Simply Stunning...come take a look and see Our View!

1150 Shavano Drive, Covington

$734,900

Welcome to the new heart of Covington at Covington Central Riverfront. The Hundley floorplan by Drees Homes is a stunning three-story townhome offering 2,774 square feet of thoughtfully designed living space with soaring 10-foot ceilings. This home features two expansive suites, each with adjoining spa-like baths and generous walk-in closets, along with 3.5 baths total, creating 2 private and luxurious retreats. The first floor showcases stylish LVP flooring, a gourmet kitchen and glass enclosed wine bar, creating a modern, open flow ideal for everyday living and entertaining. The third floor adds exceptional versatility with a game room and media room—perfect for entertaining or relaxing at home. Located within a vibrant retail and entertainment district, this home blends comfort, style, and modern city living.

2 Beds ⋅ 4 Baths ⋅ 639683 MLS

Welcome to the new heart of Covington at Covington Central Riverfront. The Hundley floorplan by Drees Homes is a stunning three-story townhome offering 2,774 square feet of thoughtfully designed living space with soaring 10-foot ceilings. This home features two expansive suites, each with adjoining spa-like baths and generous walk-in closets, along with 3.5 baths total, creating 2 private and luxurious retreats. The first floor showcases stylish LVP flooring, a gourmet kitchen and glass enclosed wine bar, creating a modern, open flow ideal for everyday living and entertaining. The third floor adds exceptional versatility with a game room and media room—perfect for entertaining or relaxing at home. Located within a vibrant retail and entertainment district, this home blends comfort, style, and modern city living.

126 W 4th Street, Covington

$724,900

Welcome to the new heart of Covington at Covington Riverfront Townhomes. The Hundley floor plan by Drees Homes is a stunning three-story townhome offering 2,819 square feet of thoughtfully designed living space with soaring 10-foot ceilings. This home features 3 spacious bedrooms and 3.5 baths, including a serene primary suite. The first floor showcases stylish LVP flooring and a gourmet kitchen, creating a modern, open flow ideal for everyday living and entertaining. The third floor adds exceptional versatility with a game room, media room, and wet bar—perfect for entertaining or relaxing at home. Located within a vibrant retail and entertainment district, this home blends comfort, style, and modern city living.

3 Beds ⋅ 4 Baths ⋅ 639672 MLS

Welcome to the new heart of Covington at Covington Riverfront Townhomes. The Hundley floor plan by Drees Homes is a stunning three-story townhome offering 2,819 square feet of thoughtfully designed living space with soaring 10-foot ceilings. This home features 3 spacious bedrooms and 3.5 baths, including a serene primary suite. The first floor showcases stylish LVP flooring and a gourmet kitchen, creating a modern, open flow ideal for everyday living and entertaining. The third floor adds exceptional versatility with a game room, media room, and wet bar—perfect for entertaining or relaxing at home. Located within a vibrant retail and entertainment district, this home blends comfort, style, and modern city living.

128 W 4th Street, Covington

$639,000

Welcome to The Ascent, Covington's premier luxury residential building—where it's all about the views. Spectacular and light-filled, this two-bedroom, two-and-a-half-bath residence showcases breathtaking river views of the Roebling Bridge, Downtown Covington, and the Cincinnati skyline beyond. An expansive open great room seamlessly connects the kitchen and dining areas, creating an ideal setting for entertaining. Walls of windows frame panoramic river views while flooding the home with natural light and a sense of infinite space. The chef's kitchen is outfitted with Sub-Zero refrigeration, a Wolf range, custom space-saving cabinetry, and a counter bar. The well-appointed primary suite offers a serene retreat with an en-suite bath, walk-in closet, and conveniently located laundry, and this residence has been thoughtfully reconfigured to maximize closet space in the primary suite. The second bedroom also features an en-suite bath, while a stylish powder room adds ease for entertaining. Every detail has been carefully curated. The home includes two deeded garage parking spaces, an assigned storage unit, and a private wine locker in the building's one-of-a-kind, climate-controlled wine tasting room. Residents enjoy access to The Ascent's unmatched amenities, including a pool, fitness center, sauna, massage room, theatre, library, private dining room, outdoor grilling terrace with firepit, multiple entertaining spaces, two guest suites, and 24-hour concierge and security. Walkable to all that downtown Covington has to offer, with easy access across the bridge to Cincinnati's sports and concert venues. An exceptional opportunity in a truly iconic building.

2 Beds ⋅ 3 Baths ⋅ 639622 MLS

Welcome to The Ascent, Covington's premier luxury residential building—where it's all about the views. Spectacular and light-filled, this two-bedroom, two-and-a-half-bath residence showcases breathtaking river views of the Roebling Bridge, Downtown Covington, and the Cincinnati skyline beyond. An expansive open great room seamlessly connects the kitchen and dining areas, creating an ideal setting for entertaining. Walls of windows frame panoramic river views while flooding the home with natural light and a sense of infinite space. The chef's kitchen is outfitted with Sub-Zero refrigeration, a Wolf range, custom space-saving cabinetry, and a counter bar. The well-appointed primary suite offers a serene retreat with an en-suite bath, walk-in closet, and conveniently located laundry, and this residence has been thoughtfully reconfigured to maximize closet space in the primary suite. The second bedroom also features an en-suite bath, while a stylish powder room adds ease for entertaining. Every detail has been carefully curated. The home includes two deeded garage parking spaces, an assigned storage unit, and a private wine locker in the building's one-of-a-kind, climate-controlled wine tasting room. Residents enjoy access to The Ascent's unmatched amenities, including a pool, fitness center, sauna, massage room, theatre, library, private dining room, outdoor grilling terrace with firepit, multiple entertaining spaces, two guest suites, and 24-hour concierge and security. Walkable to all that downtown Covington has to offer, with easy access across the bridge to Cincinnati's sports and concert venues. An exceptional opportunity in a truly iconic building.

1 Roebling Way, Covington