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;

2848 S Cypress Lake Drive
Olive Branch, MS 38654

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $745,000
Beds: 5
Baths: 5
Status: Pending
SqFt: 4331
Agency: crye-leike realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Stunning, Custom, Designer Farm Home on a 3/4 Acre Lot in #1 Lewisburg with Pool and Outdoor Living ~ Like-New (only 3 years old) and in immaculate condition with 5 Bedrooms (2 down / 3 up), 4.5 Bathrooms, Office, Media Room, Multi-Purpose Room, 3-Car Garage with workshop, Roll-Up Door to pool, Outdoor Kitchen, Outdoor Fireplace ~ Check out the photos and video. This home will blow you away. Impressive curb appeal and commanding front elevation with friends entry, professional landscaping, and wrap-around front porch to Double Door Transomed Entry to an Open Floor Plan with beautiful wood floors and high ceilings throughout the main living areas ~ Vaulted Great Room with brick FP to ceiling, cedar mantel, built-in cabinets, floating shelves, gas logs/starter, cat-walk above, and sliding doors to the covered porch and outdoor living ~ Designer Chef's kitchen with center island, quartz counters, upgraded lighting, custom faucet, farm sink, tons of cabinets with soft-close, under-cabinet lighting, glass door cabinets, floating shelves, gas cook-top, warming-drawer, custom vent hood, herringbone backsplash, designer white appliances, and walk-in pantry with wood shelves ~ Kitchen opens to Dining with upgraded lighting and window coverings ~ Next to the kitchen / dining find a barn door leading to an office with built-in shelves/cabinets with panoramic windows ~ Primary Bedroom on the rear of the home with wood floors, sliding doors to the covered porch, 10' ceiling, crown molding, recessed lighting and barn door to Primary Bath with over-sized dual vanity with leathered granite, drawer stack, upgraded faucets, soaker tub, and frameless walk-in shower with dual heads, rainfall, and dual seats ~ Walk-In Primary Closet with built-in wood closet system with cabinets, drawers, shelves, and shoe cubbies ~ Bedroom 2 with Private Bath 2 on the first floor ~ 1/2 Bath Powder Room for Guests ~ Laundry with Friends Entry, Mud Area with Cubbies, folding counter, sink, built-in cabinets ~ Upstairs find a center Loft, Bedrooms 3, 4, 5 and Bathroom 3 with Dual Vanity, plus a Media Room and Multi-Purpose Room ~ Outside find a great 33 foot Covered Porch with Outdoor Kitchen featuring a sink, gas grill, fridge, space for a Green Egg, and concrete bar counters plus an Outdoor Brick FP ~ Extended patio opens to a 41 x 17 inground salt-water pool with fountains ~ The back yard is an oasis paradise! Views of Beautiful trees offering great privacy. Additional Features: Wood-tread stairs, iron rails, Low E vinyl windows, upgraded plumbing and lighting throughout, Zosia sodded yard, window planters, floored attic, tankless water heater, Beadboard porch ceilings, Roll-Up garage door to the pool deck with keypad, workshop in 3rd garage with a 15 foot work table, built-in cabinets, Garage Mud Area with Cubbies, Pool Bath, exterior security lighting, cameras, painted brick, hardiplank siding, ridge vent, copper gutters, and more. Must see to believe!
MlsNumber: 4076345


Listing Provided By: crye-leike realtors, original listing
Name: crye-leike realtors
Phone: (662) 985-0043
Office Name: Crye-Leike Of MS-SH
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;
Real Estate Expert Photo for Melanie Henderson
Melanie Henderson
ASCIIBurch Realty Group
Call Today!: (770) 289-3130

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App