$1,650,000
Counce, TN 38326
MLS# 26-3525
4 beds | 3 baths | 3888 sqft
1 / 78
Property Description
WATER FRONT HOME WITH SPECTACULAR WATER VIEWS OF TN, MS, & AL. Experience Pickwick Lake living in this 4-BD, 3-b, 3,888 heated SF in gated Shiloh Falls, 0.65 ac lot, w/deed boat slip #11B. Main level has open living & dining, soaring ceilings, dramatic windows, amazing views, & a cozy gas fireplace. The kitchen offers granite, abundant cabinetry, updated appliances, ice maker, & trash compactor. A luxurious master suite w/jetted tub & walk-in Shower. Second Bed/bath, & mudroom. Upstairs is an office with built-ins. Down stairs is game/recreation room, w /wet bar, ice maker, & gas fireplace. Two Bed & bath. Outside two-tier composite back decks provide space for relaxing, dining, & enjoying the views. A double garage. Amenities include Community Clubhouse, Pool, tennis, & Golf.
Details
Maps
Documents
Contract Information
Directions: MS-15 TO WALNUT, RIGHT ONTO US-72, LEFT ONTO HWY 2, RIGHT ONTO HWY 350, LEFT ONTO HWY 25, RIGHT ONTO HOLIDAY HILLS, LEFT ONTO SANDPIPER.
Vacant: N
Lease Purchase: No
HOA/ Other Required Fees: Yes
HOA Fee Amount: 2400
HOA Fee Frequency: Annually
Current Price: $1,650,000
Status: Active
Begin Date: 2026-09-21
List Price: $1,650,000
General Property Description
Realtor.COM Type: Single Family Home
1st Floor SqFt: 2542
Style: Traditional
2nd Floor SqFt: 156
Lot Size Dimensions: 41X286x63x222x30x255
Basement SqFt: 1190
Lot Acres: 0.65
Year Built: 1996
Basement: Finished
3rd Floor SqFt: 196
Waterfront: Yes
Stories: 2
Total Rooms: 12
Total Bedrooms: 4
Total Bathrooms: 3
Garage Type: Double Detached
Carport: None
School District: Hardin
Book Section: Residential
Total SqFt.: 3888
Total Full Baths: 3
Location, Tax & Legal
Zoning: Residential
Total Taxes: 5692
Legal: MAP 155N, PARCEL 023.00,
BOOK 2 PAGE 134
Tax Parcel Number: 155N 023.00
PPIN: 023.00
Flood Zone: NO
Homestead: NO
Area: Hardin County
House Number: 1197
Street Name: Sandpiper
State/Province: TN
Postal Code: 38326
County: Hardin
Subdivision: Shiloh Falls
Miscellaneous
Investment Property: 1
Lock Box: 1
Amenities
Deck: 2
Fireplace: 2
Gas Logs: 2
Storage Room: 1
Financial
Mortgage: Non-Assume
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Range: 1
Refrigerator: 1
Construction
Construction: stone/wood
Countertops: Granite
Flooring: Cpt/Wood/Tile
Foundation: Slab
Roof: Architectural
Utilities
Heat: Central Gas
Water: Public
Sewer: PUBLIC
Air: Central
Water Heater: 2
Water Heater Type: Electric
Electric: 1
Gas: 1
Energy Savers
Insulation: 1
Thermopane Windows: 1
Documents
Disclosure 1: PCD
Flooring
Carpet: 1
Ceramic Tile: 1
Marble: 1
Wood: 1
Other Structures
Other: 1
Property Features
Amenities: Storage Room
Appliances: Dishwasher; Disposal; Microwave; Range; Refrigerator
Miscellaneous: Investment Property; Lock Box
Flooring: Carpet; Ceramic Tile; Marble; Wood
Utilities: Electric; Gas
Other Structures: Other
Energy Savers: Insulation; Thermopane Windows
PCD 
Listing Office: 1ST Class Realty, LLC
Last Updated: September - 22 - 2026
Information deemed reliable but not guaranteed.
Broker Attribution:
cdhillhomes@yahoo.com