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

4128 S Siwell Road
Byram, MS 39272
Barbara Richardson with Eternity Real Estate, original listing - (601) 346-8009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,700,000
Beds: 7
Baths: Full: 7, ½: 3
Status: Active
SqFt: 11059 Square Feet
Agency: Eternity Real Estate
Agency Phone: (601) 346-8009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 52 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: This is an amazing Home and site-Gated entrance and small bridge to compliment the elegant entrance with water fountain flowing in front of the entrance. This Custom deigned Mississippi Charm comes fully furnished. Per the Seller, Several pieces of furnishings, were actually built to fit the rooms.Beautifully seated in the middle of the first 25.2 acre tract- fenced and Fully Furnished. Breathtaking foyer entrance leading to the Formal Living, French doors to the patio. Ballroom size formal dining room with ElegantChandelier. There is a breakfast area a bar, gourmet kitchen-all viking appliances. Massive family room for those one of a kind gatherings- Split bedroom plan with 4-fireplaces, piano room, Laundry room. The 2nd story has a formal Living room, covered patio overlooking the Tennis Court, stocked pond, full basketball court and Guest house. Guest House features a mini kitchen and full bath. Main house is fully equipped with Gym, Beauty Salon, Jacuzzi, Jacuzzi, Shower and Sauna. Floor number-3 features a a fully functional office.4-Car garage, stable for horses. Other features Flooring-Brazilian Cherry, Marble Tile, and Travertine--Kitchen, Granite Countertops and Backsplash-built in appliances, all Viking with freezer drawers--6 Burner gas cook top, Double Convection Oven, Viking Mini frig, GE Ice Maker, Viking Dishwasher and Ice Disposal. Bathrooms have Granite and Marble Fixtures , double sinks Tub and Shower, with Acrylic Marble Tile. Hand showers, brass, lever and double shower heads. In Addition-Jacuzzi Sauna/Steam Shower, Lipped cast from tub with Body jets. Bedrooms Fireplaces have wood mantels--there are 2-built in flat screen TV's -Spiral staircase, built in entertainment center, cedar chip walk-in closet--built in bedroom desk-built in integrated speaker system, jacuzzi tubs with built in television. Interior faux finished columns, recessed niches, custom drapery, granite bar, granite fireplace with wood mantle, and jetted tubs.
MlsNumber: --
ListingId: 4099554


Listing Provided By: Eternity Real Estate, original listing
Phone: (601) 668-3263
Office Phone: (601) 346-8009
Agent Name: Barbara Richardson
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.


Local Real Estate Expert

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 = 1429 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;
Real Estate Expert Photo for Jacqueline Jackson
Jacqueline Jackson
ASCIIPrestige Realty & Investment Co.
Call Today!: (601) 918-2708

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App