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

1895 Nottingham Drive
Southaven, MS 38671
Donnie R Chambliss with Crye-Leike Of MS-SH, original listing - (662) 349-5550

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: Extraordinary opportunity to own this 10 acre luxury estate in the heart of DeSoto County ~ Custom-Built with 700 foot winding driveway between 2 ponds and through the trees up to the concealed homesite where you'll find 6000sf on ONE-LEVEL ~ 4 Bedrooms, 4 Full Bathrooms, 2 Half Baths, Sun Room, Trophy Room, 2 Screen Porches, Rear Covered Porch, Courtyard Botanic Garden, Inground Pool, Cabana Pool House with Outdoor Kitchen, Dog Kennel / Detached Shop and separate driveway to an alternate homesite where you could build a 2nd residence on the property ~ Front Paver Walkway leads up to a commanding Double Door Transom Entry with parquet wood floors and heavy trim ~ Long Hallway leads in both directions ~ Updated Kitchen with Center Island, Granite Bar, professional appliances, built-in Sub-Zero Fridge, commercial convection ovens w/ gas cook-top and Vent Hood, Ice Maker, Wine Fridge, Warming Drawer, custom cabinets, backsplash, under cabinet lighting, appliance garage, drawer stacks, cushioned window seat with sconce lighting, crank out windows ~ Opens to a Breakfast Area Morning Room with FP and double doors to a front Screened Porch with CA Redwood and a spectacular view of the lake ~ Formal Dining Room is large with built-in arched lighted buffet ~ Great Room has Cypress Floors, Heavy Trim, Center FP and arched openings to a large Sun Room with floor to ceiling windows and double doors with transoms opposite a built-in wall with wet bar ~ The Trophy Room is impressive with Wet Bar, Center FP, Built-In Gun Cases, beams and paneling, and an entry door to a front cigar patio ~ Primary Suite on the rear with Australian Cypress Wood Floors, Beamed Ceiling, Private Screened Porch, Security keypad, thermostat and 2 separate bathrooms (His/Hers) with individual vanities, toilets, and closets with built-in organization systems and a shared jetted tub and walk-in shower with dual heads and sauna ~ Bedrooms 2, 3, 4 are large with private bathrooms ~ 1/2 Bath Powder Room for Guests AND a 1/2 Bath off the Laundry / Work area ~ Laundry Room is massive with lots of cabinets, folding counters, broom closet, sink and a Workroom with sink, more built-in cabinets, work counters, tons of storage closets, rear entry door, and hallway to door to Upstairs Bonus Room, Bath, and a Floored Attic Expandable Area with over 2000sf of unfinished expandable space ~ Rear Covered Porch opens to a brick paver courtyard surrounded by trees and professional landscaping including Japanese maples, azaleas leading up to a pool deck with gunite pool/spa and a Pool House Cabana with vaulted ceiling, Outdoor FP, Outdoor Kitchen... all this and more is GREAT for Entertaining ~ Dog Kennel / Work Shop on the rear corner of the property could serve multiple purposes (and a 2nd homesite) ~ Additional Features: Crown molding and heavy trim throughout, Roll-Out windows, Marble counters, Beadboard porch ceilings, 4 Fireplaces, Upgraded HVAC system with 6 water-cooled geothermal units, Gun Safe, Storm Shelter, Gas Lanterns, Irrigation all around house, landscaping, and more... check back for updates... and come see this extraordinary luxury estate
MlsNumber: --
ListingId: 4081976


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.


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 = 1421 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;
Grace Webb
ASCIICentury 21 Home First Realtors
Call Today!: (901) 210-8669

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App