Date
Details
Price
Change
Source
7/10/2026
Listed
$1,275,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/50
$1,275,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/50
Property Description
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.
Full Property Details
Full Property Details for 617A Mary Ingles Hwy
General
- Price: $1,275,000
- Status: Active
- Type: Single Family
- Source: Northern_Kentucky
- MLS ID: 644547
- Updated: 7/18/2026
- Added to Site: 10 day(s) ago
Interior
- Number of Rooms: 10
- Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Sound System, Pantry, Granite Counters, Eat-in Kitchen, Crown Molding, Bookcases, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), Elevator, High Ceilings, Multi-Panel Doors, Natural Woodwork, Recessed Lighting
- Fireplace: Yes
- Number of Fireplaces: 3
- Fireplace(s): Gas, Wood Burning
- Appliances: Other, Gas Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Microwave, Refrigerator, Washer
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 4
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: Laundry Room, Main Level
Additional Information
- Security/Safety: Smoke Detector(s)
Exterior
- Porch/Patio/Deck: Enclosed, Patio
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
Location
- County: Campbell
- Driving Directions: I-471 S to Exit 2 (US-27/Alexandria Pike). Left on US-27, left on Mary Ingles Hwy.
School Information
- Elementary School: Johnson Elementary
- Middle School: Highlands Middle School
- High School: Highlands High
Community
- Community Name: K16 - Ft Thomas/S Gate
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Geothermal
Utilities
- Sewer: Public Sewer
- Water: Cistern
- Utility Description: Propane
Structural Information
- Architectural Style: Ranch
- Construction: Brick
- Basement Desc.: Full Finished Bath, Crawl Space, Full, Finished, Storage Space, Walk-Out Access
- Roof: Slate
- Windows: Insulated Windows, Double-Hung, Wood Frames
- Square Feet: 4,823
- Living Area: 4,823 Sq. Ft.
- Year Built: 2012
- Property Condition: Existing Structure
Lot Features
- Lot Size (Acres): 1.04
- Lot Size (Sq. Ft.): 45,346
- Lot Size: 1.04
- Lot Size Source: Assessor
- Lot Dimensions: IRR
- Lot Features: Wooded
- Zoning: Residential
- Fencing (Description): Metal
Disclosures and Reports
- Property ID: 999-99-12-680.00
Buyer's Brokerage Compensation: Contact Listing Agent
Not binding unless confirmed by separate agreement among applicable parties.
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Meet the listing agent
Meet the listing agent
— 617A Mary Ingles Hwy —
(513) 319-7312 mobile
(513) 922-9400 office
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 617A Mary Ingles Hwy
School District:Fort Thomas Independent School District
| Name | Grades | Distance |
|---|---|---|
Woodfill Elementary School 1025 Alexandria Pike, Fort Thomas, KY 41075 | K-5 | 1.3 mi |
Highlands Middle School 2350 Memorial Parkway, Fort Thomas, KY 41075 | 6-8 | 1 mi |
Highlands High School 2400 Memorial Parkway, Fort Thomas, KY 41075 | 9-12 | 0.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 617A Mary Ingles Hwy
Estimate the Cost
Estimate the Cost for 617A Mary Ingles Hwy
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 22 hours ago
- 3Beds
- 3Total Baths
- 1,404Sq. Ft.
- Condo
- Active
- Updated 5 days ago
- 3Beds
- 2Total Baths
- 1,987Sq. Ft.
- Condo
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,210Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 2Beds
- 1Total Bath
- 1,255Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
617 A Mary Ingles Hwy, Highland Heights, KY 41075 (MLS# 644547) is a Single Family property with 4 bedrooms, 4 full bathrooms and 1 partial bathroom. 617 A Mary Ingles Hwy is currently listed for $1,275,000 and was received on July 10, 2026. This property is listed by The Cagney Group from our Ohio Indiana West Regional Office.Want to learn more about 617 A Mary Ingles Hwy? Do you have questions about finding other Single Family real estate for sale in Highland Heights? You can browse all Highland Heights real estate or contact a Coldwell Banker agent to request more information.