Skip main navigation
Active
    • Price cut: $301K (6/28)
    $4,099,000

    17040 Highland Rdg, Loch Lloyd, MO 64012

    5beds
    7,106sqft
    : 
    $28,103/mo
    Get pre-qualified
    Single Family Residence
    Built in 1996
    1.2 Acres Lot
    $3,882,000 Zestimate®
    $577/sqft
    $390/mo HOA

    What's special

    Putting greenResort-style backyardBeverage refrigeratorAll-new stuccoExterior lightingFire pitBright breakfast area
    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 renovated home has been completely transformed inside and out. 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.
    116 days
    |
    2,840
    |
    126
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Rebekah Schaaf 913-707-7957,

    ReeceNichols - Overland Park

    Source: Heartland MLS as distributed by MLS GRID,MLS#: 2597814MLS Logo

      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
      Video & virtual tour

      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: $577/sqft
      • Tax assessed value: $1,934,800
      • Annual tax amount: $26,142
      • Date on market: 4/2/2026
      • Ownership: Private
      • Road surface type: Paved

        Estimated market value

        $3,882,000

        $3.69M - $4.08M

        $3,741/mo

        Price history

        DateEventPrice
        6/28/2026Price change$4,099,000-6.8%$577/sqft
        Source: Heartland MLS as distributed by MLS GRID #2597814 Report a problem
        6/15/2026Price change$4,400,000-2.2%$619/sqft
        Source: Heartland MLS as distributed by MLS GRID #2597814 Report a problem
        5/17/2026Price change$4,500,000-5.3%$633/sqft
        Source: Heartland MLS as distributed by MLS GRID #2597814 Report a problem
        4/13/2026Price change$4,750,000-5%$668/sqft
        Source: Heartland MLS as distributed by MLS GRID #2597814 Report a problem
        4/2/2026Listed for sale$5,000,000+11.1%$704/sqft
        Source: Heartland MLS as distributed by MLS GRID #2597814 Report a problem
        11/21/2023Sold--
        Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem
        10/25/2023Pending sale$4,500,000$633/sqft
        Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem
        10/16/2023Contingent$4,500,000$633/sqft
        Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem
        8/24/2023Listed for sale$4,500,000+157.1%$633/sqft
        Source: Heartland MLS as distributed by MLS GRID #2451126 Report a problem
        9/30/2021Sold--
        Source: Heartland MLS as distributed by MLS GRID #2334633 Report a problem
        2/3/2012Sold--
        Source: Heartland MLS as distributed by MLS GRID #45001_1685585 Report a problem
        12/2/2011Listed for sale$1,750,000$246/sqft
        Source: Kristin Malfer & Associates #1685585 Report a problem
        10/12/2011Listing removed$1,750,000$246/sqft
        Source: Kristin Malfer & Associates #1685585 Report a problem
        3/15/2011Price change$1,750,000-6.7%$246/sqft
        Source: Kristin Malfer & Associates #1685585 Report a problem
        1/11/2011Listed for sale$1,875,000$264/sqft
        Source: Neighbors Sells Kansas City #1685585 Report a problem

        Public tax history

        YearProperty taxesTax 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

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 64012

        Getting around

        0 / 100
        Car-Dependent
        10 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Village of Loch Lloyd Topics

                Search
                Updates
                Favorites
                Plan
                Inbox