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

1004 Annandale Drive Drive
Madison, MS 39110

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,298,000
Beds: 5
Baths: 8
Status: Active
SqFt: 5004
Agency: Livingston Land Company of MS, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1988
Notes: Welcome to this one of a kind dream home located in gated Annandale Estates - the Main house is 5,004 square feet PLUS Guest house located in the courtyard with an additional 1,200 square feet (not included in square footage listed). This property has it all when it comes to character: gas lanterns, antique heart of pine floors, a grand staircase, exposed brick walls, reclaimed beams, front porches. Also located on an acre lot, with a newly plastered pool, guest house, home gym, media room, New Orleans style courtyard, fountain... the list is endless with this home! Pulling up you are greeted by a two story front porch with long views of hole #12. Step through the double front doors into this timeless home, into a foyer to find a friend's parlor to the left and formal dining room to the right. Next is the family room where the wood-burning fireplace serves as the centerpiece of the room with views into the impeccably landscaped courtyard with soothing fountain flanked by the guest house and pool. Downstairs in the main house is the updated kitchen with Quartzite counters, walk in pantry, cypress cabinets, farmhouse sink, Subzero refrigerator, Viking 48'' range and breakfast area with another fireplace. On the opposite side of the home is the primary bedroom wing with sitting area and fireplace plus double doors with more views of courtyard. The bathroom is adorned with all the amenities you could imagine with steam shower, soaking tub, double vanities, knee space, his/her closets AND laundry for convenience! The staircase leading to the second floor invokes one from antebellum homes and adds even more to the home's timeless design details. The second floor encompasses two bedrooms, each with their own bathroom, also a laundry room and sitting area. The front bedroom offers access to the second story balcony with more views of Annandale Golf Club. On the third floor, the media room is refined and comfortable with room for a card table, half bathroom, and beverage cooler. Back downstairs and through the courtyard, sits the guest house opposite the main home. On the first floor is two bedrooms and 1 bathroom. Upstairs is a spacious home gym or game room with another half bath and beverage cooler. Take the courtyard pathway to the pool - very private and replastered and retiled in April 2024. Truly an inspiring home perfect for those seeking a home with privacy, character and exquisite architectural detail!
MlsNumber: 4076731


Listing Provided By: Livingston Land Company of MS, LLC, original listing
Name: Livingston Land Company of MS, LLC
Phone: (769) 234-7517
Office Name: Bowie & Co Real Estate, LLC
Office Phone: (769) 234-7517
Agent Name: Walt Bowie
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 = 1449 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;
Taylor Lewis
ASCIIHome Again Realty
Call Today!: (601) 750-6788

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App