This stunning Modern Mediterranean lakefront estate is nestled among mature trees and showcases breathtaking lake views. 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 room, media room, glass-enclosed wine room, distinctive round bar, and a sun-filled family/game 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.
Coming soon 04/02
$5,000,000
17040 Highland Rdg, Loch Lloyd, MO 64012
5beds
7,106sqft
Est.:
Single Family Residence
Built in 1996
1.2 Acres Lot
$2,994,500 Zestimate®
$704/sqft
$390/mo HOA
What's special
- --
- on Zillow |
- 3,600
- views |
- 154
- saves |
Zillow last checked: 7 hours ago
Listing updated: March 08, 2026 at 05:33pm
Listing Provided by:
Rebekah Schaaf 913-707-7957,
ReeceNichols - Overland Park
Source: Heartland MLS as distributed by MLS GRID,MLS#: 2597814
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 9
- Full bathrooms: 6
- 1/2 bathrooms: 3
Dining room
- Description: Breakfast Area,Formal
Heating
- Forced Air, Radiant Floor, Zoned
Cooling
- Electric, Zoned
Appliances
- Included: Dishwasher, Disposal, Double Oven, Freezer, Exhaust Fan, Microwave, Refrigerator, Gas Range
- Laundry: Bedroom Level, Main Level
Features
- Central Vacuum, Custom Cabinets, Kitchen Island, Pantry, Smart Thermostat, Walk-In Closet(s), Wet Bar
- Flooring: Tile, Wood
- Windows: Thermal Windows
- Basement: Finished,Full,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Great Room
Interior area
- Total structure area: 7,106
- Total interior livable area: 7,106 sqft
- Finished area above ground: 4,630
- Finished area below ground: 2,476
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage Door Opener
- Attached garage spaces: 3
Features
- Patio & porch: Deck, Patio
- Exterior features: Fire Pit
- Has private pool: Yes
- Pool features: In Ground
- Fencing: Metal
- On waterfront: Yes
- Waterfront features: Lake Front
Lot
- Size: 1.2 Acres
- Features: Acreage, Estate Lot
Details
- Parcel number: 8000406
- Special conditions: Standard
- Other equipment: Back Flow Device
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Spanish,Traditional
- Property subtype: Single Family Residence
Materials
- Stucco
- Roof: Metal,Tile
Condition
- Year built: 1996
Details
- Builder name: Joel Fritzel
Utilities & green energy
- Sewer: Grinder Pump, Private Sewer
- Water: Public
Community & HOA
Community
- Security: Gated Community, Security System, Smoke Detector(s)
- Subdivision: Loch Lloyd
HOA
- Has HOA: Yes
- Amenities included: Clubhouse, Exercise Room, Golf Course, Party Room, Pickleball Court(s), Play Area, Putting Green, Pool, Tennis Court(s), Trail(s)
- Services included: Curbside Recycle, Trash
- HOA fee: $390 monthly
- HOA name: www.lochlloydhoa.com
Location
- Region: Loch Lloyd
Financial & listing details
- Price per square foot: $704/sqft
- Tax assessed value: $1,934,800
- Annual tax amount: $26,142
- Date on market: 1/23/2026
- Ownership: Private
- Road surface type: Paved
Estimated market value
$2,994,500
$2.61M - $3.44M
$4,139/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 11/21/2023 | Sold | -- |
Source:  Heartland MLS as distributed by MLS GRID #2451126 Report a problem | ||
| 10/25/2023 | Pending sale | $4,500,000$633/sqft |
Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem | ||
| 10/16/2023 | Contingent | $4,500,000$633/sqft |
Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem | ||
| 8/24/2023 | Listed for sale | $4,500,000+157.1%$633/sqft |
Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem | ||
| 9/30/2021 | Sold | -- |
Source: Heartland MLS as distributed by MLS GRID #2334633 Report a problem | ||
| 2/3/2012 | Sold | -- |
Source: Heartland MLS as distributed by MLS GRID #45001_1685585 Report a problem | ||
| 12/2/2011 | Listed for sale | $1,750,000$246/sqft |
Source: Kristin Malfer & Associates #1685585 Report a problem | ||
| 10/12/2011 | Listing removed | $1,750,000$246/sqft |
Source: Kristin Malfer & Associates #1685585 Report a problem | ||
| 3/15/2011 | Price change | $1,750,000-6.7%$246/sqft |
Source: Kristin Malfer & Associates #1685585 Report a problem | ||
| 1/11/2011 | Listed for sale | $1,875,000$264/sqft |
Source: Neighbors Sells Kansas City #1685585 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $26,142 +128.6% | $367,620 +107.4% |
| 2024 | $11,434 +0.3% | $177,260 |
| 2023 | $11,398 +5.3% | $177,260 +6.8% |
| 2022 | $10,821 | $165,920 |
| 2021 | $10,821 | $165,920 +1.8% |
| 2020 | -- | $162,920 |
| 2019 | -- | $162,920 +3.5% |
| 2018 | $10,233 | $157,460 |
| 2017 | $10,233 -39.1% | $157,460 -38.9% |
| 2016 | $16,801 | $257,840 |
| 2015 | $16,801 -0.4% | $257,840 |
| 2014 | $16,876 | $257,840 |
| 2013 | $16,876 | $257,840 -0.1% |
| 2011 | -- | $257,990 -0.9% |
| 2010 | -- | $260,360 |
| 2009 | -- | $260,360 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$29,917/mo
Principal & interest
$25944
Property taxes
$3583
HOA Fees
$390
More affordability tools
Climate risks
Neighborhood: 64012
Nearby schools
GreatSchools rating
- 7/10Mill Creek Upper Elementary SchoolGrades: 5-6Distance: 2.9 mi
- 4/10Belton Middle School/Freshman CenterGrades: 7-8Distance: 3.8 mi
- 5/10Belton High SchoolGrades: 9-12Distance: 2.8 mi
Schools provided by the listing agent
- Elementary: Cambridge
- Middle: Yeokum
- High: Belton
Source: Heartland MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 64012
- Missouri
- Cass County
- Village of Loch Lloyd
- 64012
- 17040 Highland Rdg
Nearby cities
Nearby zip codes
Other Village of Loch Lloyd Topics
- Apartments for Rent in 64012
- Houses for Sale in 64012
- Houses for Rent in 64012
- 64012 Real Estate
- Village of Loch Lloyd Condos
- Houses for Sale in Village of Loch Lloyd
- Newest Listings in Village of Loch Lloyd
- Village of Loch Lloyd Home Values
- Village of Loch Lloyd Real Estate Agents
- Village of Loch Lloyd Refinance
- Village of Loch Lloyd Mortgage Rates
