See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

617 Mary Ingles Hwy, Newport, KY, 41076

4beds
5baths
4,823sqft
$1,275,000
$264price/sqft
$8,567/moest. monthly cost
$342,680/yrincome needed

About This Home

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.

Getting Around

0
WalkingCar-Dependent
0
TransitVery Limited Transit
9
BikeSomewhat Bikeable

Schools

10/10
8/10
Highlands Middle SchoolGrades 6-81.0 mi
10/10
Highlands High SchoolGrades 9-120.9 mi

Construction

Condition

  • Property condition: Existing Structure
  • Year built: 2012

Materials

  • Foundation: Poured Concrete
  • Roof: Slate
  • Construction materials: Brick

Type & Style

  • Home type: SingleFamily
  • Architectural style: Ranch
  • Property subType: Single Family Residence,Residential

Interior

Appliances

  • Appliances included: Other,Gas Cooktop,Dishwasher,Disposal,Double Oven,Dryer,Microwave,Refrigerator,Washer
  • Laundry features: Laundry Room,Main Level

Basement

  • Has basement: Yes
  • Basement: Crawl Space,Full

Bathroom2

  • Features: Hardwood Floors
  • Level: First
  • Area: 56
  • Dimensions: 8 x 7

Bathroom3

  • Features: Full Finished Bath,Shower,Tile Flooring
  • Level: First
  • Area: 54
  • Dimensions: 9 x 6

Bathroom4

  • Features: Full Finished Bath,Tub With Shower,Tile Flooring
  • Level: Lower
  • Area: 50
  • Dimensions: 10 x 5

Bedroom2

  • Features: Carpet Flooring,Ceiling Fan(s)
  • Level: First
  • Area: 182
  • Dimensions: 14 x 13

Bedroom3

  • Features: Carpet Flooring
  • Level: Lower
  • Area: 221
  • Dimensions: 17 x 13

Bedroom4

  • Features: Carpet Flooring
  • Level: Lower
  • Area: 169
  • Dimensions: 13 x 13

Bedrooms & Bathrooms

  • Bedrooms: 4
  • Bathrooms: 5
  • Full bathrooms: 4
  • 1/2 bathrooms: 1

Breakfast Room

  • Features: Tile Flooring
  • Level: First
  • Area: 100
  • Dimensions: 10 x 10

Dining Room

  • Features: Chandelier,Hardwood Floors
  • Level: First
  • Area: 270
  • Dimensions: 18 x 15

Entry

  • Features: Closet(s),Entrance Foyer,Hardwood Floors
  • Level: First
  • Area: 144
  • Dimensions: 18 x 8

Family Room

  • Features: Walk-Out Access,Carpet Flooring,Wet Bar
  • Level: Lower
  • Area: 1188
  • Dimensions: 36 x 33

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,Natural Woodwork,Recessed Lighting
  • Door features: Multi Panel Doors
  • Window features: Double Hung,Wood Frames
  • Number of fireplaces: 3
  • Fireplace features: Gas,Wood Burning
  • Fireplace: Yes

Game Room

  • Level: Lower
  • Area: 308
  • Dimensions: 28 x 11

Heating & Cooling

  • Heating features: Geothermal
  • Cooling features: Central Air

Interior Area

  • Total structure area: 4,823
  • Total interior livable area: 4,823 sqft

Kitchen

  • Features: Walk-Out Access,Kitchen Island,Gourmet Kitchen,Eat-in Kitchen,Pantry,Wood Cabinets,Recessed Lighting,Tile Flooring
  • Level: First
  • Area: 513
  • Dimensions: 27 x 19

Laundry

  • Features: Built-in Features,Utility Sink,Tile Flooring
  • Level: First
  • Area: 88
  • Dimensions: 11 x 8

Library

  • Features: Bookcases,Hardwood Floors
  • Level: Second
  • Area: 192
  • Dimensions: 16 x 12

Living Room

  • Features: Walk-Out Access,Fireplace(s),Recessed Lighting,Hardwood Floors
  • Level: First
  • Area: 810
  • Dimensions: 30 x 27

Office

  • Features: Bookcases,Hardwood Floors
  • Level: First
  • Area: 192
  • Dimensions: 16 x 12

Other

  • Level: Lower
  • Area: 640
  • Dimensions: 32 x 20

Primary Bath

  • Features: Shower With Bench,Shower,Tub,Tile Flooring
  • Level: First
  • Area: 156
  • Dimensions: 13 x 12

Primary Bedroom

  • Features: Fireplace(s),Carpet Flooring,Walk-In Closet(s),Bath Adjoins,Ceiling Fan(s)
  • Level: First
  • Area: 324
  • Dimensions: 18 x 18

Property

Accessibility

  • Accessibility features: Accessible Elevator Installed

Details

  • Parcel number: 9999912680.00
  • Attached to another structure: Yes
  • Zoning description: Residential

Features

  • Levels: One
  • Stories: 1
  • Patio & porch: Enclosed,Patio
  • Fencing: Metal

Lot

  • Lot size: 1.04 Acres
  • Features: Wooded
  • Lot size dimensions: IRR

Parking

  • Total spaces: 3
  • Parking features: Attached,Driveway,Garage,Garage Door Opener,Garage Faces Side
  • Has garage: Yes
  • Attached garage spaces: 3
  • Covered spaces: 3
  • Has uncovered spaces: Yes

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Lightning
    LightningRelatively High
  • Tornado
    TornadoRelatively High
  • Cold Wave
    Cold WaveModerate
  • Heat Wave
    Heat WaveModerate
  • Ice Storm
    Ice StormModerate
  • Strong Wind
    Strong WindModerate
  • Winter Weather
    Winter WeatherModerate

How This Home’s Risks Compare

Lightning
Tornado
Cold Wave
Heat Wave
Ice Storm
Strong Wind
Winter Weather

FEMA Declared Disasters Across Kentucky Counties

Flood
Mud Landslide
Severe Storm
Straight Line Winds
Tornado
Winter Storm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $6,447$77,364
Home Insurance *$614$7,368
Property Taxes $1,126$13,512
Electricity $380$4,570
Total$8,567$102,804
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$293,725/yr
40% on housing$257,010/yr
45% on housing$228,453/yr

Kentucky FAIR Plan Programs

Kentucky FAIR Plan Reinsurance Association

Covered
WildfireWildfire
Add-on available
HailHail
WindWind
Visit Website →
Current Policies
Residential: 4,102Commercial: 175
Total Premiums$2.55M
Total Exposure$206.09M

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 5.5%
5.5%
0%30.0%
Electricity Growth Rate10-year average: 6.0%
6.0%
0%15.0%
Property Taxes Growth Rate2-year average: -0.6%
-0.6%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$264This listing

vs Other Active Listings

Avg $/sqft

ZIP 41076$122
Campbell County$190

vs Homes Sold Last Month

Median $/sqft

ZIP 41076$180
Campbell County$190

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

Price History

DateEventPrice
2026-07-10Listed for sale$1,275,000

For Sale by Agent

AgentPatrick Cagney
BrokerageColdwell Banker Realty

Similar Homes