Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1409 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1409 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1409 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

147 Lake Shore Terrace
Ashland, MS 38603
Bill Stone with Bill Stone and Associates, original listing - (662) 278-0111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $229,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1644 Square Feet
Agency: Bill Stone and Associates
Agency Phone: (662) 278-0111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Cabin
Year Built: 2006
Notes: Nestled in the tranquil community of Snow Lake Shores surrounded by rural Benton County and the Holly Springs National Forest, this charming ranch-style home offers a peaceful retreat with all the conveniences of modern living. Built in 2006, the home features over 1,600 square feet of well-designed living space on a generous half-acre lot. With three bedrooms and two bathrooms, the residence boasts an open floor plan that includes a cozy sunroom-perfect for relaxing or entertaining guests. The kitchen is thoughtfully equipped with a gas range, with an electric connection available, if you prefer, and laminate countertops that balance functionality with style. A spacious master suite includes the convenience of an in-suite laundry area, making daily routines a breeze. The home's interior features a variety of flooring materials, including carpet, cork, tile, bamboo, hardwood, and laminate, adding texture and warmth to each room. Step outside to enjoy the fenced backyard and beautifully landscaped grounds, which include mature perennials and a paved driveway. An attached single carport provides secure parking and storage, and wide doors and hallways ensure accessibility throughout the home. Living in Snow Lake Shores means access to a wealth of community amenities. Residents can take advantage of the lake for boating and fishing, enjoy the community center, relax on sandy beaches, or spend active afternoons at the tennis courts and parks. The natural beauty of the surrounding pine forests and open meadows makes it an ideal setting for outdoor enthusiasts. Community events and gatherings foster a warm, welcoming atmosphere year-round. Practical features include a forced air system with an electric heat pump for year-round comfort, a metal roof installed six years ago with a lifetime warranty, and an updated electrical system with breakers, rewired in 2015. The Snow Lake Property Owners Corporation oversees community maintenance, with modest annual dues of $575 and low property taxes make this home not only desirable but also affordable. Whether you're looking for a full-time residence or a weekend getaway, this home offers the perfect blend of comfort, accessibility, and community living. Don't miss the opportunity to own a piece of paradise at beautiful Big Snow Lake.
MlsNumber: --
ListingId: 11471844


Listing Provided By: Bill Stone and Associates, original listing
Phone: (662) 224-3300
Office Phone: (662) 278-0111
Agent Name: Bill Stone
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App