Title Page Background
DEBUG FN args: Array ( [0] => 1449 [1] => [2] => [3] => agent ) BEFORE: Site: 1449 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1449 Igate: njhud LocID: 1449 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1449 [1] => [2] => [3] => lender ) BEFORE: Site: 1449 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1449 Igate: njhud LocID: 1449 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1449 [1] => [2] => [3] => other ) BEFORE: Site: 1449 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1449 Igate: njhud LocID: 1449 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

129 Elizabeth Avenue
Madison, MS 39110

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths:
Status: Active Under Contract
SqFt: 4158 Square Feet
Agency: eXp Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Garbage Disposer, Ice Maker, Cooktop - Gas, Oven - Double, Oven - Convection
Architectural Style: New Traditional
Cooling: Ceiling Fan(s)
Flooring: Carpet, Tile, Wood, Tile - Ceramic
Heating: Central Furnace, Fireplace
Interior Features: Entrance Foyer, Pantry, High Ceilings, Walk-in Closet(s), Vaulted Ceiling(s), Cathedral Ceiling(s), Double Vanity, Granite Counters, Sound System, Dry Bar
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Pool, Lighting, Front Yard, Fenced, Garden, Landscaped, Rain Gutters, Private Yard, Fire Pit, Concrete Drive, VINYL, In ground
Fencing: Fenced
Parking Features: Carport
Roof: Shingle
Waterfront Features: Waterfront, Pond

Neighborhood/Schools

Elementary School/District: Madison Station
Middle/Junior High School/District:
High School/District: Madison Central/Madison County - 8
Subvidision Name: Ingleside

Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Nestled within Madison's heart, this exceptional 5-acre retreat invites you into a world of tranquility and luxury. Set amidst meticulously maintained grounds, this rare gem boasts a serene stocked pond, a swimming pool, a delightful guest house.Step onto the charming main house's front porch, a captivating 4-bedroom, 4.5-bathroom abode that exudes care and meticulous attention to detail. The well-appointed kitchen features granite countertops, beautifully stained cabinets, and a suite of stainless steel appliances including double ovens, a built-in microwave, and a gas cooktop. The adjacent formal dining area is a perfect setting for gatherings and seamlessly connects to the great room, graced with vaulted ceilings and a unique ceiling fan.The master bedroom, a haven of comfort, showcases vaulted and beamed ceilings, accompanied by an attached den or office space adorned with a fireplace. This space serves dual roles, doubling as a safe room, ensuring peace of mind during tumultuous weather. The master bathroom offers granite countertops, a tiled shower, a whirlpool tub, ample closet space, and a convenient dressing table.Upstairs, discover additional bedrooms, each boasting its own en-suite bathroom and walk-in closet. Bedrooms 3 and 4 delight with dormer windows that overlook the backyard, infusing charm and character into every corner.Meticulously landscaped, the grounds embrace the property in natural beauty, framing the stocked pond, water garden, and inviting pool. The fully fenced yard, enclosed by a white fence, provides a secure space for loved ones and pets. An underground dog fence spans the entire 5 acres, ensuring freedom and safety for your four-legged companions.An enchanting guest house lies behind the main residence, offering an additional 600 square feet of living space. With a studio-style layout, a full bathroom, and a tankless water heater, it's perfect for visitors, a home office, or creative endeavors.This is a unique discovery - a harmonious blend of nature, luxury, and comfort. Don't miss your chance to claim this captivating property as your own. Arrange a showing today and experience the allure of 5-acre living in Madison.
MlsNumber: --


Listing Provided By: eXp Realty, original listing
Phone: (601) 214-5451
Office Phone: (601) 455-0101
Agent Name: Mark Metcalf
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => madison [3] => MS [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: madison State: MS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: madison State: MS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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