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

251 S Ext Street
Hazlehurst, MS 39083

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2909
Agency: Havard Real Estate Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1915
Notes: You are sure to fall in love with this gorgeous home, located in the historical district of Hazlehurst with a separate guest house! Built in 1915, this home still features many of its original features including the original hardwood floors, bathroom tile, original doors and stunning (non-functioning) tiled fireplaces, with several recent updates to restore and reclaim this homes beauty. You will fall in love with the 12 foot ceilings throughout most of the home and the oversized windows that maintain this home's grandeur. When you enter through the front door you will fall in love with the high ceilings, gorgeous original hardwood flooring, and original windows and fireplaces. This area is perfect for gathering with friends or simply relaxing after a long day of work. Just off the living room you will find a stunning formal dining room with another original fireplace. Conveniently located to the formal dining you will find a kitchen complete with a drop in range, double ovens, a pantry, and abundant natural light. The kitchen area also features an eat in breakfast nook and breakfast bar. Don't forget to check out the sunroom, as well as the separate study. The Master suite is just off the study in the back of the home and is complete with 3 closets, and a en-suite master bath. The two guest rooms are over sized and both feature an original fireplace. The guest bath is located between the two guest rooms and is complete with abundant storage and 12 ft ceilings. Out back you will find a spacious 2 car, carport with a storage area located in the crawl space. Out back you will also find a guest house complete with a porch, bedroom, walk-in closet and private bath with updated electric wiring, HVAC,and water heater. This home has too many amazing features to list them all! Plus, it is priced to sell! Call today for your private showing!
MlsNumber: 4076485


Listing Provided By: Havard Real Estate Group, LLC, original listing
Name: Havard Real Estate Group, LLC
Phone: (601) 672-8147
Office Name: Havard Real Estate Group, LLC
Office Phone: (601) 340-9656
Agent Name: Hartley Havard
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