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 = 1466 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 = 1466 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 = 1466 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;

232 Scr 558
Pulaski, MS 39152
Tiffany Kinslow with Main Street Realty LLC, original listing - (601) 849-3226

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $164,500
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1600 Square Feet
Agency: Main Street Realty LLC
Agency Phone: (601) 849-3226

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: This 3-bedroom, 1.5-bath brick home is nestled on a beautiful one-acre lot surrounded by large oak trees. This property is in immaculate condition. There is an attached two-car carport with a large storage room. There is a large living room, featuring a cozy fireplace and large windows that provide tons of natural light. Off the living room, a huge walk-in closet provides the perfect space for a home office or a small study.The open-concept living and dining area is perfect for entertaining and family gatherings, with beautiful hardwood laminate floors throughout. The kitchen offers ample storage with plenty of cabinets and an inviting eat-in breakfast area, ideal for casual dining. The laundry room is located off of the kitchen and has built in cabinets providing great storage. There is a large sunroom, boasting large windows on every wall and custom pull-down blinds. This serene space is perfect for enjoying your morning coffee or unwinding with a book in the evening, offering panoramic views of the surrounding landscape.A long hallway leads to a full bathroom and three spacious bedrooms, with the master bedroom featuring an attached half bath for added privacy and convenience. The property also includes a small storage shed, providing additional space for your outdoor tools and equipment.This home is in immaculate condition. The roof has architectural shingles installed just 3-4 years ago and a new HVAC system replaced a year ago, ensuring comfort and peace of mind with your new home purchase. Experience the best of country living in this charming brick home. Schedule your showing today and make this beautiful property your own!
MlsNumber: --
ListingId: 4095852


Listing Provided By: Main Street Realty LLC, original listing
Phone: (601) 849-3226
Office Phone: (601) 849-3226
Agent Name: Tiffany Kinslow
Disclaimer: Copyright © 2024 MLS United. 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