Skip main navigation
Active under contract
    • Listed by: Coldwell Banker Realty - Gundaker • Brigita Keene • 314-713-1179
    $699,000

    817 W Gray Friar, Lake Sherwood, MO 63357

    5beds
    5,400sqft
    : 
    $4,550/mo
    Get pre-qualified
    Single Family Residence
    Built in 1980
    0.39 Acres Lot
    $-- Zestimate®
    $129/sqft
    $208/mo HOA

    What's special

    Oversized two-car garageBreathtaking main lake viewsIncredible waterfront settingExceptional waterfront homeDistinctive point locationImpressive great roomMultiple decks
    Located within the sought-after 24-hour gated Lake Sherwood community, this exceptional waterfront home is perfectly nestled among the trees on a scenic 0.30-acre point lot, offering over 5,000 square feet of living space with breathtaking main lake views. Featuring 5 bedrooms, 4 full baths, space for everyone this home is designed to accommodate large families, weekend gatherings, or year-round lake living. The thoughtfully designed floor plan includes three finished levels—main, upper, and lower—along with two full kitchens, multiple living areas, and an impressive great room, providing incredible flexibility for entertaining or multi-generational living. Step outside onto multiple decks where you can relax and enjoy the peaceful wooded surroundings with natures wildlife and lake views. Your private dock on the main lake offers easy access to boating, fishing, swimming, and everything lake life has to offer. Additional highlights include zoned heating and cooling, an oversized two-car garage, and a private wooded setting that offers both tranquility and beauty. Properties like this are rarely available. With its distinctive point location, expansive floor plan, incredible waterfront setting, and endless possibilities, this is a truly unique piece of property. This lake community offers boating, fishing, beaches, a marina, clubhouse, pool, campground, A Lakeside Grill with a full menu and year-round community events. This is more than a home—it's a lifestyle. Come experience what waterfront living is all about at Lake Sherwood.
    30 days
    |
    1,895
    |
    131
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Brigita Keene 314-713-1179,

    Coldwell Banker Realty - Gundaker

    Source: MARIS,MLS#: 26041552MLS LogoOriginating MLS: St. Charles County Association of REALTORS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 4
      • Main level bathrooms: 2
      • Main level bedrooms: 4
      Heating
      • Electric, Forced Air, Zoned
      Cooling
      • Ceiling Fan(s), Central Air, Dual, Zoned
      Features
      • Basement: Full,Walk-Out Access
      • Number of fireplaces: 2
      • Fireplace features: Bedroom, Great Room
      Interior area
      • Total structure area: 5,400
      • Total interior livable area: 5,400 sqft
      • Finished area above ground: 5,400

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage - Attached
      • Attached garage spaces: 2
      Features
      • Levels: Multi/Split
      • On waterfront: Yes
      • Waterfront features: Waterfront
      Lot
      • Size: 0.39 Acres
      • Features: Waterfront
      Details
      • Parcel number: 1211.0117037.000.000
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Rustic,Split Level,Traditional
      • Property subtype: Single Family Residence
      Materials
      • Cement Siding
      Condition
      • Year built: 1980

      Utilities & green energy

      • Electric: 220 Volts
      • Sewer: Public Sewer
      • Water: Community, Public
      • Utilities for property: Propane

      Community & HOA

      Community
      • Subdivision: Lake Sherwood Estates
      HOA
      • Has HOA: Yes
      • Amenities included: Basketball Court, Beach Access, Beach Rights, Boating, Clubhouse, Common Ground, Lake, Marina, Picnic Area, Playground, Pool, Recreation Facilities, Security
      • Services included: Clubhouse, Maintenance Grounds, Maintenance Parking/Roads, Common Area Maintenance, Pool Maintenance, Recreational Facilities, Security
      • HOA fee: $208 monthly
      • HOA name: Lake Sherwood Estates
      Location
      • Region: Lake Sherwood

      Financial & listing details

      • Price per square foot: $129/sqft
      • Tax assessed value: $430,990
      • Annual tax amount: $5,207
      • Date on market: 7/16/2026
      • Cumulative days on market: 30 days
      • Listing terms: Cash,Conventional

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/5/2026Contingent$699,000$129/sqft
        Source: MARIS #26041552 Report a problem
        7/16/2026Listed for sale$699,000$129/sqft
        Source: MARIS #26041552 Report a problem
        6/26/2023Listing removed--
        Source: Zillow Rentals Report a problem
        6/7/2023Listed for rent$3,500$1/sqft
        Source: Zillow Rentals Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$5,207 +9.6%$81,888 +13%
        2024$4,751 +3.9%$72,468
        2023$4,572 +7%$72,468 +8%
        2022$4,274 $67,100
        2021-- $67,100
        2020-- $67,100
        2019-- $67,100
        2017-- $67,100
        2016-- $67,100
        2015-- $67,100
        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.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 63357

        Getting around

        0 / 100
        Car-Dependent

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Augusta Elem.
        • Middle: Washington Middle
        • High: Washington High

        Source: MARIS. 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.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Marthasville Topics

              Search
              Updates
              Favorites
              Plan
              Inbox