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;

193 Surrey Loop
Byhalia, MS 38611
Donnie R Chambliss with Crye-Leike Of MS-SH, original listing - (662) 349-5550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $815,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3750 Square Feet
Agency: Crye-Leike Of MS-SH
Agency Phone: (662) 349-5550

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Next to Collierville, TN but in the peaceful, country setting of Barton Mississippi ~ IMMACULATE, Like-NEW Custom, Luxury, 100% Updated, Fully-Furnished Home nestled on a gorgeous 1.7 Acre Lot with Pool, Cabana, Outdoor Living, Terraced Sun Deck, in an idyllic setting... a Back Yard Paradise you must see to believe ~ Unmatched natural beauty with extensive professional landscaping all around offers great privacy ~ NEW driveway can accommodate RV parking leads to 2-Car Detached Garage and a 2-Car Attached Garage ~ Curved walkway to a front porch with impressive stacked stone entry to Double Iron Doors ~ 2-Story Foyer with upgraded chandelier and LVP wood floors throughout to an open Formal Dining with Heavy Trim, Plantation Shutters to the Great Room with 18 foot ceilings, stone FP with Built-In Bookshelves and Cabinets, upgraded lighting, and 2-story windows offering natural light ~ Open and Split Floor Plan with updated Kitchen featuring Quartz counters, Peninsula Island, Center Island, Professional faucet, Walk-In Pantry, custom cabinets with drawer stacks, Gas Cook-Top, Decorative Vent Hood, backsplash, Stainless Double Wall Ovens, Wine Fridge, and Side-By-Side Fridge ~ Breakfast Area offers panoramic views, custom lighting, and Iron Double Doors to the rear covered porch ~ Primary Suite on the rear with Security Keypad, WiFi Thermostat, double tray ceiling with crown molding, CF, Sitting Area, LVP wood floors, 2 Walk-In closets with wood shelving, and Updated Primary Bath with High Ceilings, Porcelain floors, 2 Quartz vanities with drawer stacks, updated everything, NEW Soaker Tub, upgraded faucet, Stacked Subway Tile Shower with Frameless Glass, Dual Heads ~ Bedroom 2 on opposite side with Ceiling Fan and arched double window across from Bathroom 2 with furniture vanity and subway shower ~ Mud Area with Cubbies and Charging Station just off the Garage Entry and Hallway to Laundry Room with Built-In cabinets, Sink with upgraded faucet, Hanging Rod, Folding Counter, Broom Cabinet, Washer & Dryer ~ Upstairs find Vaulted Bedrooms 3, 4 and a Theater Multi-Purpose Room with 2 Full Bathrooms ~ Welcome outside to a Back Yard Paradise with 30 foot Covered Porch with AR Fieldstone, stepping down to an extended patio and Terraced Sun Deck with Wood-Burning FP, overlooking an Inground Heated Saltwater Pool with water features, Cabana with Outdoor Kitchen and Pool Bath... all surrounded by beautiful landscaping and mature trees. Additional features: FULLY FURNISHED... everything included!!! WiFi enabled smart thermostats, Ring Camera System, Crown Molding entire house, Wood Shelving, ADT Security System, Extensive Landscaping all round (front and back), Full Irrigation System, Brick landscape planters, Exterior Security Lighting, landscape lights, Digital Locks, French drains, Pool Cleaner, Storm Shelter, Whole House Generator and more...
MlsNumber: --
ListingId: 4083806


Listing Provided By: Crye-Leike Of MS-SH, original listing
Phone: (901) 355-2074
Office Phone: (662) 349-5550
Agent Name: Donnie R Chambliss
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