Viewing Listing MLS# 60305005

$1,495,000 No Recent Price Change
197 Bayview Trail
Lampe, MO 65681
  • 5Beds
  • 4Full Baths
  • 1Half Baths
  • 3,879SqFt
  • 2016Year Built
  • 0.55Acres
  • MLS# 60305005
  • Residential
  • Single Family Residence
  • Active

  • Approx Time on MarketN/A
  • AreaStone
  • CountyStone
  • Subdivision Pinnacle Shores

Overview

Spectacular lakefront estate in a highly sought-after lake community, Pinnacle Shores! There's even a boat slip available located directly behind the home for ultimate convenience! This lodge-style 5BR/4.5BA home features massive lake views from nearly every room, soaring vaulted ceilings, floor to ceiling rock fireplace, a bright and open floorplan, and the heart of the home is a spacious chef's kitchen featuring rich granite countertops, custom cabinetry, and plenty of prep space--perfect for entertaining or hosting family gatherings. Enjoy panoramic views of your boat slip from all main-level windows. Designed for entertaining with 2 expansive decks, a cozy firepit area, hot tub and generous indoor/outdoor spaces. The perfect blend of luxury, comfort, and convenience in a premier lakefront location! This coveted gated community includes clubhouse, exercise room & pool! What more do you need?



Association Fees / Info

Hoa Fees Frequency:  Yearly

Hoa Fees:  1710

Association Type:  HOA

Bathroom Info

Halfbaths:  1

Fullbaths:  4

Total Baths:  5.00

Building Info

New Or Under Construction:  No

Roofing Material:  Composition

Foundation:  Crawl Space

Amenities:  Great Room, Propane, Stone

Year Built:  2,016

Architecture:  Other

Basement Type:  Walk-Out Access, Finished

Exterior Features

Patio and Porch:  Patio, Deck, Front Porch, Covered Deck/Porch

Exterior Extras:  Other, Water Access

Fees / Restrictions

Easements Restrict:  Subdivision

Garage / Parking

Garage:  Yes

Garage Type:  Driveway, Garage Faces Front

Handicap

Interior Features

Interior Amenities:  Wet Bar, High Ceilings, Granite Counters, Vaulted Ceiling(s), Walk-In Closet(s), W/D Hookup, Walk-In Shower

Window:  Blinds, Double Pane Windows

Appliances:  Cooktop-Electric, Wall Oven - Electric, Refrigerator, Microwave, Electric Water Heater, Dishwasher

Basement:  Yes

Flooring:  Carpet, Tile

Basement:  Full

Lot Info

Township:  22

Lot:  Landscaping, Adjoins Government Land, Water Front, Lake Front, Lake View, Water View

Acres:  0.55

Marina Info

Dock Directions:  Neighborhood Dock, Dock is below house. Dock on R, 3rd slip on R.

Docks Slip:  Yes

Boat Dock:  1 Slip, Swim Platform Attached

Boat Slip Type:  Community

Docks Dock Slip Perm Num:  8220

Dock Slip Size:  12 x 30

Dock Slip Fee:  600

Dock Slip Agreement:  Yes

Misc

Section:  28

Inside City Limits:  No

Other

Foreclosure:  No

Other Rooms Info

Other Rooms:  Bedroom (Basement), 2nd Kitchen, Pantry, Bonus Room, Living Areas (2), Great Room, Family Room (Basement), Bedroom-Master (Main Floor)

Beds:  5

Property Info

Road Frontage:  Private Road

Road Surface:  Street - Asphalt, Drive - Concrete

View:  Yes

Equipment:  Hot Tub

County:  Stone

View:  Lake

Rental Info

Vacation Rental:  No

Room Info

Utility Room:  Main Floor

Dining:  Kitchen/Dining Combo,Island,Living/Dining Combo

Sale / Lease Info

Association Includes:  Gated Community, Clubhouse, Outdoor Pool, Sewer, Water, Exercise Room, Snow Removal

Special Features

SqFt Info

Above Grade Unfin Sqft:  0

Below Grade Unfin Sqft:  0

Below Grade Fin Sqft:  1,769

Price Per Sqft:  385

Sqft:  3,879

Tax Info

Tax Year:  2,025

Re Tax Provided By:  Assessor Records

Unit Info

Efficiency Units:  2110.

Utilities / HVAC

Sewer:  Community

Heating:  Central

Cooling:  Central, Ceiling Fans

Cooling Source:  Electric

Heating Source:  Electric

Water:  Community

Waterfront / Water

Waterfront View:  Front

Lake River:  Table Rock

Schools

Elem:  Blue Eye

Middle:  Blue Eye

High:  Blue Eye

Courtesy of listing office Keller Williams Tri-Lakes 

Mortgage Calculator

%
$
%
Dollars per $1000
$
Approximate Monthly Payment 0.0
On bransontothelake.com since Thu, Sep 18th 2025
No Property History recorded for this listing.

Broker Reciprocity The data relating to real estate for sale on this web page comes in part from the Internet Data Exchange (IDX) of the Southern Missouri Regional MLS, LLC, Inc. Real estate listings held by Brokerage firms other than Mayhew Realty Group LLC are marked with the IDX logo and detailed information about them includes the name of the listing Brokers. The information being provided is for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information being provided is not guaranteed, and all information should be verified by the consumer. Any representation that a web site contains all listings shall only mean that the website contains all listing available to the public through the IDX data feed. There may be other properties offered through a REALTOR© Copyright that have not been displayed on this site. © 2025 Southern Missouri Regional MLS, LLC. All rights reserved. More...

The MLS Data on this Real Estate Website was last updated on 09-18-2025 6:01 PM EST . Any MLS images related to data from the MLS is the sole property of the MLS and not the responsibility of the owner of this website. This real estate website and IDX data is hosted by IDX data is Powered & Hosted by Dynamic IDX, LLC Real Estate Web Solutions