197 Bayview Trail, Lampe, MO 65681
$1,495,000
Property Type:
Residential For Sale
Bedrooms:
5
Baths:
5
Square Footage:
4,037
Lot Size (sq. ft.):
23,958
Status:
Closed
Current Price:
$1,495,000
List Date:
9/18/2025
Last Modified:
12/12/2025
Description
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?
More Information MLS# 60305005
Contract Information
Vacation Rental: No
List Price/Total SqFt: 370.32
Foreclosure/Short Sale: No
Agreement Type: Exclusive Right To Sell
Property Sub-Type: Single Family Residence
Begin Date: 2025-09-18
List Price: $1,495,000
Sign on Property: 1
Location, Tax and Other Information
Inside City Limits: No
RE Tax Provided By: Assessor Records
Keywords
Stories: 2
Elementary School: Blue Eye
Middle School: Blue Eye
High School: Blue Eye
General Property Description
Above Grade UnFin SqFt: 0
Below Grade UnFin SqFt: 158
Dock Directions: Neighborhood Dock, Dock is below house. Dock on R, 3rd slip on R.
Waterfront/View: Front
Basement: Yes
Lake/River/Creek: Table Rock
# Attached Garage Spaces: 2
# Detached Garage Spaces: 0
# Detached Carport Spaces: 0
View: Yes
Propane Tank: Yes
Total Bedrooms: 5
Baths - Full: 4
Baths - Half: 1
Baths - Total: 5
Above Grade Fin SqFt: 2110
Below Grade Fin SqFt: 1769
Total Finished SqFt (All Levels): 3879
Total SqFt: 4037
Aprx Year Built: 2016
Garage/Carport: 1
Total Garage/Carport Stalls: 2
Aprx Lot Size (Acres): 0.55
Status Change Info
Price Disclosed: Yes
Status: Closed
Under Contract Date: 2025-11-11
Sold Date: 2025-12-12
View
Lake: 1
Basement
Full: 1
Basement Type
Finished: 1
Walk-Out Access: 1
Utility Room
Main Floor: 1
Dining
Island: 1
Kitchen/Dining Combo: 1
Living/Dining Combo: 1
Interior Features
W/D Hookup: 1
Walk-In Closet(s): 1
Walk-In Shower: 1
Wet Bar: 1
High Ceilings: 1
Vaulted Ceiling(s): 1
Granite Counters: 1
Cooling
Ceiling Fans: 1
Central: 1
Other Rooms
2nd Kitchen: 1
Bedroom (Basement): 1
Bedroom-Master (Main Floor): 1
Bonus Room: 1
Family Room (Basement): 1
Great Room: 1
Living Areas (2): 1
Pantry: 1
Appliances
Cooktop-Electric: 1
Dishwasher: 1
Microwave: 1
Refrigerator: 1
Wall Oven - Electric: 1
Electric Water Heater: 1
Equipment
Hot Tub: 1
Fireplace Features
Fireplace: Yes
Great Room: 1
Propane: 1
Stone: 1
Heating
Central: 1
Heating Source
Electric: 1
Road Frontage
Private Road: 1
Flooring
Carpet: 1
Tile: 1
Road Surface
Street - Asphalt: 1
Drive - Concrete: 1
Cooling Source
Electric: 1
Architecture
Other: 1
Docks
Dock/Slip Size: 12 x 30
Dock/Slip Permit No: 8220
Dock/Slip Type: Community
Dock/Slip Agreement: Yes
Dock/Slip Fee $: 600
Roofing Material
Composition: 1
Home Association Info
Home Owners/Condo Owners Association: HOA
HOA Dues: 1710
HOA Dues Period: Yearly
Other Details: Water & Sewer - $1575 yearly
Foundation
Crawl Space: 1
Exterior Features
Water Access: 1
Other: 1
Parking Features
Driveway: 1
Garage Faces Front: 1
Patio and Porch Features
Covered Deck/Porch: 1
Deck: 1
Front Porch: 1
Patio: 1
Shop Building Features
Shop Building: No
Water
Community: 1
Window Features
Blinds: 1
Double Pane Windows: 1
Sewer
Community: 1
Lot Features
Adjoins Government Land: 1
Lake Front: 1
Lake View: 1
Landscaping: 1
Water Front: 1
Water View: 1
Association Includes
Clubhouse: 1
Exercise Room: 1
Gated Community: 1
Outdoor Pool: 1
Sewer: 1
Snow Removal: 1
Water: 1
Boat Dock
1 Slip: 1
Swim Platform Attached: 1
Easements & Restrict
Subdivision: 1
Location Tax and Other Information
Street #: 197
Street Name/Route: Bayview
Suffix: Trail
County: Stone
State/Province: MO
Zip Code: 65681
Section: 28
Township: 22
Parcel ID: 14-8.0-28-000-000-003.032
Subdivision: Pinnacle Shores
Real Estate Tax: 3492.66
Tax Year: 2025
Legal Description: Pinnacle Shores Lot 32
Remarks Misc
Directions: Pinnacle Shores entrance, follow Pinnacle Shores to Left on Point Pinnacle to R on Bayview Trail to house on L
Property Features
View: Lake
Basement: Full
Basement Type: Finished; Walk-Out Access
Utility Room: Main Floor
Dining: Island; Kitchen/Dining Combo; Living/Dining Combo
Other Rooms: 2nd Kitchen; Bedroom (Basement); Bedroom-Master (Main Floor); Bonus Room; Family Room (Basement); Great Room; Living Areas (2); Pantry
Appliances: Cooktop-Electric; Dishwasher; Microwave; Refrigerator; Wall Oven - Electric; Electric Water Heater
Equipment: Hot Tub
Fireplace Features: Great Room; Propane; Stone
Interior Features: W/D Hookup; Walk-In Closet(s); Walk-In Shower; Wet Bar; High Ceilings; Vaulted Ceiling(s); Granite Counters
Flooring: Carpet; Tile
Cooling: Ceiling Fans; Central
Cooling Source: Electric
Heating: Central
Heating Source: Electric
Architecture: Other
Patio and Porch Features: Covered Deck/Porch; Deck; Front Porch; Patio
Exterior Features: Water Access; Other
Parking Features: Driveway; Garage Faces Front
Window Features: Blinds; Double Pane Windows
Foundation: Crawl Space
Roofing Material: Composition
Lot Features: Adjoins Government Land; Lake Front; Lake View; Landscaping; Water Front; Water View
Water: Community
Sewer: Community
Road Frontage: Private Road
Road Surface: Street - Asphalt; Drive - Concrete
Association Includes: Clubhouse; Exercise Room; Gated Community; Outdoor Pool; Snow Removal; Water
Boat Dock: 1 Slip; Swim Platform Attached
Documents
C&R's ›
Listing Office:
Keller Williams Tri-Lakes
Last Updated: December - 12 - 2025
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 the website owner are marked with the IDX logo and detailed information about them includes the name of the listing Brokers. The information being provided is not guaranteed and should be verified by the consumer and is for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers wish to purchase. Any representation that a web site contains all listings shall only mean that the web site contain all listing available to the public through the IDX data feed and other available properties may not be displayed on this site. © 2023 Southern Missouri Regional MLS, LLC All rights reserved.