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

199 Myers Road
Byhalia, MS 38611
Elizabeth A Thomas with RE/MAX Realty Group, original listing - (662) 403-4200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5012 Square Feet
Agency: RE/MAX Realty Group
Agency Phone: (662) 403-4200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Want acreage in Lewisburg School district? Dream of having horses? Desire a large shop, beautiful home and an inground pool? COME TOUR this 5,000 s.f. home which sits on 6.71 acres! This custom-built home offers (4) Bedrooms, (3.5) Baths plus a massive Media/Game Room with wet bar! Gorgeous hardwood floors throughout! You have NOT seen a larger kitchen than this! It is every chef and entertainer's dream come true with the massive amounts of cabinets and countertop space. Such stunning granite! The kitchen, den and breakfast room are very open and very spacious. Additionally, on the main level, there is a formal dining room, three bedrooms, 2.5 baths (one of which is a Jack and Jill), massive laundry room, walk in pantry, separate home office and a small study area between to two additional bedrooms down. Let's talk about the Primary suite... WOW! It has nail down hardwood floors, decorative tray ceiling, wood planked accent wall with a door to the patio. Ideal for a late-night swim. The primary bathroom has a His/Her closet, jacuzzi tub, garden shower and double sink vanity. The second level offers a large landing/sitting area with storage room, (4th) bedroom, another full bathroom PLUS a game/media room. There is also a large walk-in attic for storage. The front of the home is inviting with the enormous covered front porch and double entry doors. Let's step out back to the party! Take in the serene surroundings with the inground, saltwater pool, covered patio, ornate pergola, hot tub and custom outdoor kitchen. The kitchen is built with aluminum frame and wrapped in stunning stone. The kitchen appliances are SS and includes a refrigerator, cooler, burner, trash bin, storage drawers and a gas grill. Now, let's talk SHOP! The property offers a 1,500 s.f. shop with 220-volt wiring, ducted for HVAC and large slide doors. Shop has a lien-to on the side. Come tour this unique home before its gone!
MlsNumber: --
ListingId: 4079063


Listing Provided By: RE/MAX Realty Group, original listing
Phone: (901) 412-9691
Office Phone: (662) 403-4200
Agent Name: Elizabeth A Thomas
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