Sign in
Home
    • Browse
    • Browse A-Z
    • Coming Soon
    • New Listings
    • Price Changes
    • Open Houses
    • New Construction
    • Premier Builders
    • National Search
    • View All Properties
    • Premier Collection
    • Luxury Homes
    • Find a Builder
    • Explore Developments
    • Get Help
    • Get Pre-Approved
    • Buyer’s Guide
    • Find an Agent
    • Find a Loan Officer
    • Sell your Home
    • Seller’s Guide
    • Find an Agent
    • Home Services
    • School Links
    • Community Guide
    • Buyer’s Guide
    • Seller’s Guide
    • Regional Guide
    • What's Your Home Worth?
    • Utility Connection
    • Blog
    • Overview
    • Mortgage
    • Insurance
    • Title
    • Relocation
    • U.S. Military on the Move
    • Home Services
    • Home Warranty
    • Earnest Money Payment
    • Offices
    • Find an Agent
    • Find a Loan Officer
    • Becoming an Agent
Sign in

617 A Mary Ingles HWY Highland Heights, KY 41075

4
Bed
4/1
Bath
4,823
Sq. Ft
1.04
Acres
$1,275,000
MLS# 644547
4 BR
4/1 BA
4,823 Sq. Ft
1.04 AC
1/50
    2/50
    3/50
    Photos
    Map
    Photos
    Map

    More About 617 A Mary Ingles HWY

    Experience exceptional luxury in this custom-built ranch offering over 7,000 square feet of thoughtfully designed living space on more than an acre overlooking the scenic Ohio River. Timeless craftsmanship and premium finishes are showcased throughout, including geothermal heating, a slate roof, copper gutters and downspouts, extensive crown molding, and the convenience of an elevator. The gourmet kitchen is designed for both everyday living and entertaining, featuring custom cabinetry, granite countertops, an oversized island with seating, a spacious walk-in pantry, and a hidden bar. The open living room is anchored by a beautiful fireplace and complemented by a charming crow's nest and private library, creating inviting spaces to relax or gather. The luxurious first-floor primary suite offers comfort and convenience, along with first-floor laundry for effortless one-level living. Step onto the elevated enclosed porch and enjoy breathtaking panoramic views of the Ohio River year-round. A separate enclosed wellness retreat features a steam shower and swim spa, creating a true at-home sanctuary. The expansive lower level is perfectly suited for entertaining with a wet bar, spacious game room, and two additional bedrooms, providing ample space for guests. This extraordinary estate seamlessly blends elegant design, modern efficiency, and resort-style amenities in a truly one-of-a-kind riverfront setting.

    Connect with a loan officer to get started!

    Directions to this Listing

    : I-471 S to Exit 2 (US-27/Alexandria Pike). Left on US-27, left on Mary Ingles Hwy.

    Information Refreshed: 7/18/2026 10:37 AM

    Ask a Question

    Contact our Customer Care team or
    513-985-4010
    CallText

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    Call us now at 513-985-4010

    Property Details

    • MLS#:

      644547
    • Type:

      Single Family
    • Sq. Ft:

      4,823
    • County:

      Campbell
    • Age:

      14
    • Appliances:

      Dishwasher, Dryer, Disposal, Microwave, Other, Refrigerator, Washer, Double Oven, Gas Cooktop
    • Architecture:

      Ranch
    • Basement:

      Finished, Full, Crawl Space, Full Finished Bath, Storage Space, Walk-Out Access
    • Construction:

      Brick
    • Cooling:

      Central Air
    • Fireplace:

      Wood Burning, Gas
    • Garage Spaces:

      3
    • Heating:

      Geothermal
    • Inside Features:

      Bookcases, Built-in Features, Cathedral Ceiling, Crown Molding, Elevator, Multi Panel Doors, Natural Woodwork, Sound System, Walk-In Closet(s), Wet Bar, Ceiling Fan(s), Eat-in Kitchen, High Ceilings, Kitchen Island, Pantry, Granite Counters, Recessed Lighting
    • Levels:

      1 Story
    • Lot Description:

      IRR
    • Parking:

      Driveway, Garage, Door Opener, Attached, Garage Faces Side
    • School District:

      Fort Thomas Independent
    • Sewer:

      Public Sewer
    • Water:

      Cistern

    Rooms

    • Bathroom 1:

      13x12 (Level: First)
    • Bathroom 2:

      8x7 (Level: First)
    • Bathroom 3:

      9x6 (Level: First)
    • Bathroom 4:

      10x5 (Level: Lower)
    • Bedroom 1:

      18x18 (Level: First)
    • Bedroom 2:

      14x13 (Level: First)
    • Bedroom 3:

      17x13 (Level: Lower)
    • Bedroom 4:

      13x13 (Level: Lower)
    • Breakfast Room:

      10x10 (Level: First)
    • Dining Room:

      18x15 (Level: First)
    • Entry:

      18x8 (Level: First)
    • Family Room:

      36x33 (Level: Lower)
    • Game Room:

      28x11 (Level: Lower)
    • Kitchen:

      27x19 (Level: First)
    • Library:

      16x12 (Level: Second)
    • Living Room:

      30x27 (Level: First)
    • Office:

      16x12 (Level: First)
    • Other Room 1:

      32x20 (Level: Lower)
    This listing courtesy of Patrick Cagney (513) 319-7312 , Coldwell Banker Realty (513) 922-9400

    Explore Highland Heights & Surrounding Area

    Highland Heights KY

    Highland Heights

    Highland Heights prides itself on being the home of Northern Kentucky University, which is a focal point for the Northern Kentucky community and is making a significant impact on the economic and intellectual climate of the entire metropolitan area.

    View Community
    Cold Spring

    Cold Spring

    Cold Spring is the home of the National Headquarters of the Disabled American Veterans, a charity that provides support to veterans and their families. Crestview is a small, residential community tucked away behind Cold Spring, and was originally develo...

    View Community
    Wilder KY

    Wilder

    Wilder was the first settlement in Campbell County. Once known as Leitch’s Station, Wilder was named after Covington doctor, William Hamlin Wilder. The city’s Licking River frontage is home to the Northern Kentucky Port Authority. Wilder’s recent g...

    View Community
    Fort Thomas

    Ft. Thomas

    You won’t find industry here, but you will find a closely-knit community of over 16,000 residents. Virtually all prices and styles of homes are offered. They share the common trait of being well-kept. Lovely older homes as well as newer ones along tree-...

    View Community
    KY•41075•Campbell County•Highland Heights•617 A Mary Ingles HWY

    Ask a Question

    Contact our Customer Care team or
    513-985-4010
    CallText

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    Call us now at 513-985-4010

    Monthly Cost

    Mortgage Calculator

    Enter your details for an estimated monthly payment. See how much house you can afford

    %
    LEGAL DISCLAIMERS▼

    Your estimated payment

    $6,481
    per month
    PRINCIPAL & INTEREST
    $6,481
    CHAT WITH A LOAN OFFICER

    Sell with Sibcy Cline

    Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.

    Must reads

    The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the Northern Kentucky Multiple Listing Service, Inc.Those listings held by brokerage firms other than Sibcy Cline, 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. Copyright© 2026 Northern Kentucky Multiple Listing Service, Inc. / All Information is believed accurate, but is NOT guaranteed.