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

607 Tiffintown Rd
Vicksburg, MS 39183
Liz Edmonds with Three Rivers Real Estate, original listing - (601) 303-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 5
Baths: Full: 5, ¾: 1
Status: Active
SqFt: 6551 Square Feet
Agency: Three Rivers Real Estate
Agency Phone: (601) 303-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 34 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Stunning executive home located just outside of Vicksburg, MS and only approximately 40 minutes from the Jackson Metro area. From the moment you pass through the main entrance and proceed down the long winding drive you'll see this majestic home in the distance with a fully stocked pond in front giving you a since of calm and peacefulness. You pass through an electronic gate just before approaching the circular drive at the home. The ornate iron double doors greet you as you enter this stunning home. This custom home is 6551 sq feet with 5 bedrooms and 5 3/4 baths. The primary suite is very spacious and boasts a large fireplace with gorgeous marble surround and private bar. The en suite bath has been tastefully updated with huge walk in shower with granite surround, free standing tub, his and her back-to-back vanities with granite countertops. The kitchen has custom cabinets, double ovens, under mount lighting and granite on countertops and island and has an open line of sight of the keeping room, large family living area and dining areas. Deep crown moldings can be seen throughout. Floors throughout the home are solid oak. This home also features a formal family room, private study/office, media room with gorgeous bar down stairs (including equipment). Upstairs is another family area with built-ins and three guest bedrooms each with their private bath. On the wing over the triple garage is another bedroom accessible by a winding staircase which could also be used as a bonus room. The laundry room is large and has a sink, space for an extra refrigerator and tons of extra storage. Enjoy your view overlooking the property from the second story balcony with your afternoon tea or entertain your friends and family around the large pool along with gazebo, fountain and outdoor fireplace. Also, there is a shop with water and electricity and covered parking bays just beyond the house for your farm and/or hunting equipment. There are two parcels of land that are connected. The house and barn are on approximately 5 acres and the remaining tract consists of pasture and timber on approximately 29 acres. Contact your favorite realtor for a private showing. (Qualified Buyers Only for Showings)
MlsNumber: --
ListingId: 4094280


Listing Provided By: Three Rivers Real Estate, original listing
Phone: (601) 303-7653
Office Phone: (601) 303-7653
Agent Name: Liz Edmonds
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