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

504 South Jackson Street
Brookhaven, MS 39601
Trinity Webb with Southern Oaks RE Properties, LLC, original listing - (601) 927-2942

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $679,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 5724 Square Feet
Agency: Southern Oaks RE Properties, LLC
Agency Phone: (601) 927-2942

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1885
Notes: Step through time into the grandeur of 1885 with this Queen Anne home that graces one of Brookhaven's most esteemed streets. A whimsical aura reminiscent of a Disney Castle surrounds this residence, promising a life of elegance and sophistication. The home boasts 5 bedrooms and 4 bathrooms within its 5724 sqft, offering ample space for both intimate gatherings and grand celebrations. Immerse yourself in the charm of yesteryear with 12 and 13-foot ceilings, accentuating the spaciousness and airiness of each room. The allure of history is further enhanced by 5 fireplaces, creating cozy corners for relaxation and warmth. Marvel at the natural light streaming through the floor-to-ceiling windows, casting a soft glow on the crystal chandeliers that grace various rooms. Gleaming hardwood floors add a touch of refinement, leading you through a journey of both opulence and comfort. The steel foundation ensures the longevity of this architectural gem, while the 20x40 saltwater pool invites you to unwind in style amidst meticulously landscaped surroundings. A separate 884 sqft guest house, with charming brick floors and recent renovations, provides additional space for guests or creative pursuits. The crown jewel of this fairytale dwelling is its roof, a mere 3 to 4 years old, ensuring not just historical allure but modern durability. There is also a large workshop that could be additional storage, art studio or dance studio. Immerse yourself in the magic of this Queen Anne home, a piece of living history awaiting its next chapter in the heart of Brookhaven's distinguished neighborhood.
MlsNumber: --
ListingId: 140772


Listing Provided By: Southern Oaks RE Properties, LLC, original listing
Phone: (769) 218-7860
Office Phone: (601) 927-2942
Agent Name: Trinity Webb
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