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

17040 Highland Rdg, Loch Lloyd, MO, 64012

5beds
9baths
7,106sqft
$3,999,000
$563price/sqft
$26,524/moest. monthly cost
$1,060,960/yrincome needed

About This Home

This stunning Modern Mediterranean lakefront estate is nestled among mature trees and showcases breathtaking lake views from every window. Featuring exceptional designer details and luxurious finishes, this fully renovated home has been completely transformed inside and out — with no surface left untouched. Updates include all-new stucco, landscaping, exterior lighting, entry wall, and driveway. The resort-style backyard offers a pool with sun deck and automatic cover, putting green, fire pit, expansive patio, and elevated deck — creating the ultimate setting for relaxation, entertaining, and unforgettable sunsets. The chef’s kitchen is a showpiece, highlighted by a custom iron hood over a 60” Ilve range, Fisher & Paykel refrigerator and freezer, dual dishwashers, oversized island, walk-in pantry with custom built-ins, Advantium oven, beverage refrigerator, and a bright breakfast area. The living room features a dramatic wall of windows overlooking the lake and a striking fireplace with a full marble surround. The private owner’s suite includes glass doors opening to the deck and a spa-inspired bath with heated floors, dual showers, and a soaking tub. The lower level offers a fifth bedroom, cigar/bourbon room, living room, glass-enclosed temperature-controlled wine room, distinctive round bar, and a sun-filled exercise/sauna room with direct pool access. Additional highlights include multiple patio spaces, a dedicated pool bath with exterior access, and four laundry rooms conveniently located in the mudroom, primary closet, upper level, and pool area. Situated on a fully fenced, beautifully landscaped, one-acre wooded lot, this extraordinary property is truly a one-of-a-kind renovation on a highly sought-after lakefront setting.

Getting Around

0
WalkingCar-Dependent
0
TransitVery Limited Transit
10
BikeSomewhat Bikeable

Schools

5/10
Belton High SchoolGrades 9-122.8 mi

Construction

Condition

  • Year built: 1996

Materials

  • Roof: Metal,Tile
  • Construction materials: Stucco

Other

  • Builder name: Joel Fritzel

Type & Style

  • Home type: SingleFamily
  • Architectural style: Spanish,Traditional
  • Property subType: Single Family Residence

Interior

Appliances

  • Appliances included: Dishwasher,Disposal,Double Oven,Freezer,Exhaust Fan,Microwave,Refrigerator,Gas Range
  • Laundry features: Bedroom Level,Main Level

Basement

  • Has basement: Yes
  • Basement: Finished,Full,Walk-Out Access

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 9
  • Full bathrooms: 6
  • 1/2 bathrooms: 3

Features

  • Central Vacuum,Custom Cabinets,Kitchen Island,Pantry,Smart Thermostat,Walk-In Closet(s),Wet Bar
  • Window features: Thermal Windows
  • Flooring: Tile,Wood
  • Number of fireplaces: 1
  • Fireplace features: Great Room
  • Fireplace: Yes
  • Finished area below ground: 2,476
  • Finished area above ground: 4,630

Heating & Cooling

  • Heating features: Forced Air,Radiant Floor,Zoned
  • Cooling features: Electric,Zoned

Interior Area

  • Total structure area: 7,106
  • Total interior livable area: 7,106 sqft

Property

Details

  • Parcel number: 8000406
  • Special condition: Standard
  • Other equipment: Back Flow Device

Features

  • Private pool: Yes
  • Pool features: In Ground
  • Patio & porch: Deck,Patio
  • Exterior features: Fire Pit
  • Fencing: Metal
  • On waterfront: Yes
  • Waterfront features: Lake Front

Lot

  • Lot size: 1.20 Acres
  • Features: Acreage,Estate Lot

Parking

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

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

  • Cold Wave
    Cold WaveRelatively High
  • Hail
    HailRelatively High
  • Strong Wind
    Strong WindRelatively High
  • Tornado
    TornadoRelatively High
  • Winter Weather
    Winter WeatherRelatively High
  • Heat Wave
    Heat WaveModerate
  • Ice Storm
    Ice StormModerate
  • Lightning
    LightningModerate

How This Home’s Risks Compare

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

FEMA Declared Disasters Across Missouri Counties

Flood

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 $20,221$242,652
Home Insurance *$2,996$35,952
Property Taxes $2,765$33,180
Electricity $542$6,511
Total$26,524$318,288
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$909,394/yr
40% on housing$795,720/yr
45% on housing$707,306/yr

Missouri FAIR Plan Programs

Missouri Property Insurance Placement Facility

Covered
WildfireWildfire
HailHail
WindWind
Visit Website →
Current Policies
Residential: 2,041Commercial: 84
Total Premiums$2.35M
Total Exposure$198.26M

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: 10.0%
10.0%
0%30.0%
Electricity Growth Rate10-year average: 2.9%
2.9%
0%15.0%
Property Taxes Growth Rate2-year average: 2.7%
2.7%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$563This listing

vs Other Active Listings

Avg $/sqft

ZIP 64012$163
Cass County$207

vs Homes Sold Last Month

Median $/sqft

ZIP 64012$176
Cass County$175

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)

No zestimate history available

Price History

DateEventPrice
2026-04-13Price change$4,750,000
2026-04-02Listed for sale$5,000,000
2023-11-21Sold--
2023-10-25Pending sale$4,500,000
2023-10-16Contingent$4,500,000
2023-08-24Listed for sale$4,500,000
2021-09-30Sold--
2012-02-03Sold--
2011-12-02Listed for sale$1,750,000
2011-10-12Listing removed$1,750,000
2011-03-15Price change$1,750,000
2011-01-11Listed for sale$1,875,000

For Sale by Agent

AgentRebekah Schaaf
BrokerageReeceNichols - Overland Park

Similar Homes