197 Bayview Trail, Lampe, MO 65681 (MLS# 60305005)

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

Overview

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?

Listing Details MLS# 60305005

Contract Information

Property Sub-Type: Single Family Residence
Vacation Rental: No
Begin Date: 2025-09-18
List Price/Total SqFt: 370.32
Foreclosure/Short Sale: No
Agreement Type: Exclusive Right To Sell
Sign on Property: Yes

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

Keywords

Stories: 2
Elementary School: Blue Eye
Middle School: Blue Eye
High School: Blue Eye

General Property Description

Total Bedrooms: 5
Baths - Full: 4
Baths - Half: Yes
Baths - Total: 5
Above Grade Fin SqFt: 2110
Below Grade Fin SqFt: 1769
Below Grade UnFin SqFt: 158
Total Finished SqFt (All Levels): 3879
Total SqFt: 4037
Aprx Year Built: 2016
Garage/Carport: Yes
Total Garage/Carport Stalls: 2
# Attached Garage Spaces: 2
Aprx Lot Size (Acres): 0.55
Basement: Yes
Dock Directions: Neighborhood Dock, Dock is below house. Dock on R, 3rd slip on R.
Waterfront/View: Front
Lake/River/Creek: Table Rock
Propane Tank: Yes
Above Grade UnFin SqFt: 0
# Detached Garage Spaces: 0
# Detached Carport Spaces: 0
View: Yes

Remarks Misc

Directions: Pinnacle Shores entrance, follow Pinnacle Shores to Left on Point Pinnacle to R on Bayview Trail to house on L

Status Change Info

Under Contract Date: 2025-11-11
Sold Date: 2025-12-12
Price Disclosed: Yes

More Information

Fireplace Features

Fireplace: Yes
Great Room: Yes
Propane: Yes
Stone: Yes

Shop Building Features

Shop Building: No

Docks

Dock/Slip Size: 12 x 30
Dock/Slip Permit No: 8220
Dock/Slip Type: Community
Dock/Slip Agreement: Yes
Dock/Slip Fee $: 600

Home Association Info

Home Owners/Condo Owners Association: HOA
HOA Dues: 1710
HOA Dues Period: Yearly
Other Details: Water & Sewer - $1575 yearly

Location, Tax and Other Information

Inside City Limits: No
RE Tax Provided By: Assessor Records

View

Lake: Yes

Basement

Full: Yes

Basement Type

Finished: Yes
Walk-Out Access: Yes

Utility Room

Main Floor: Yes

Dining

Island: Yes
Kitchen/Dining Combo: Yes
Living/Dining Combo: Yes

Interior Features

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

Cooling

Ceiling Fans: Yes
Central: Yes

Other Rooms

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

Appliances

Cooktop-Electric: Yes
Dishwasher: Yes
Microwave: Yes
Refrigerator: Yes
Wall Oven - Electric: Yes
Electric Water Heater: Yes

Equipment

Hot Tub: Yes

Heating

Central: Yes

Heating Source

Electric: Yes

Road Frontage

Private Road: Yes

Flooring

Carpet: Yes
Tile: Yes

Road Surface

Street - Asphalt: Yes
Drive - Concrete: Yes

Cooling Source

Electric: Yes

Architecture

Other: Yes

Roofing Material

Composition: Yes

Foundation

Crawl Space: Yes

Exterior Features

Water Access: Yes
Other: Yes

Parking Features

Driveway: Yes
Garage Faces Front: Yes

Patio and Porch Features

Covered Deck/Porch: Yes
Deck: Yes
Front Porch: Yes
Patio: Yes

Water

Community: Yes

Window Features

Blinds: Yes
Double Pane Windows: Yes

Sewer

Community: Yes

Lot Features

Adjoins Government Land: Yes
Lake Front: Yes
Lake View: Yes
Landscaping: Yes
Water Front: Yes
Water View: Yes

Association Includes

Clubhouse: Yes
Exercise Room: Yes
Gated Community: Yes
Outdoor Pool: Yes
Sewer: Yes
Snow Removal: Yes
Water: Yes

Boat Dock

1 Slip: Yes
Swim Platform Attached: Yes

Easements & Restrict

Subdivision: Yes

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 ›

Aerial ›

Measurement Disclaimer ›

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.