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 = 1461 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1461 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1461 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

1094 Pine Cone Ln
Summit, MS 39666
Tyler Smith with Betsy Smith Properties, original listing - (601) 833-6305

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2450 Square Feet
Agency: Betsy Smith Properties
Agency Phone: (601) 833-6305

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Presenting an exceptional opportunity in Pike County, this meticulously maintained 2,450 square foot 3 bedroom, 2.25 bathroom brick home epitomizes serene country living on a sprawling 5-acre lot with scattered trees and views for days. Nestled at the end of a tranquil dead-end street, the property boasts a fenced yard encompassing a recently stocked pond and a charming gazebo, complete with electricity. Upon entering the property via a fully paved driveway leading to an attached two-car garage, residents and guests are welcomed by a spacious enclosed brick courtyard/patio area featuring a hot tub, ideal for evening gatherings with convenient electrical hookups. Inside, the residence exudes warmth and comfort with new laminate flooring throughout, complemented by plush carpeting within the closets. The expansive layout includes a sunroom/game room adjacent to the breakfast area. The kitchen, designed for both functionality and enjoyment, offers views of the front yard and a seamless flow to the dining room and large living area, highlighted by a wood-burning brick fireplace and a tastefully traced ceiling with abundant lighting. Additional highlights include a versatile bonus room above the garage, accessible via a separate staircase inside the home, and a well-appointed primary suite complete with a generous walk-in closet and an adjoining bathroom. Two additional sizable bedrooms, both featuring walk-in closets and one featuring a powder room, ensure ample space for family or guests. For added convenience, the laundry area is strategically located near all bedrooms. The property further includes two storage sheds, enhancing storage options amidst the expansive grounds. Secluded yet conveniently located just minutes from the local community college and city limits, this move-in ready home promises a lifestyle of tranquility and convenience. For those seeking the perfect blend of privacy and accessibility, we invite you to schedule your private viewing today.
MlsNumber: --
ListingId: 141671


Listing Provided By: Betsy Smith Properties, original listing
Phone: (601) 754-7205
Office Phone: (601) 833-6305
Agent Name: Tyler Smith
Disclaimer: Copyright © 2024 Southwest Mississippi Board of Realtors. 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