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

103 Cherry Laurel Lane
Ridgeland, MS 39157
Katie Warren with Turn Key Properties, LLC, original listing - (601) 427-5088

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,595,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6724 Square Feet
Agency: Turn Key Properties, LLC
Agency Phone: (601) 427-5088

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Welcome Home - 103 Cherry Laurel Lane is a magnificent home located in the renowned Estate Community of Bridgewater. The Bridgewater neighborhood is a privately gated community with amenities including lake, pool, clubhouse, tennis courts, playground, and the Natchez Trace Trail (Chisha Foka Multi-Use Trail) a 14-mile-long scenic walking/ biking trail that overlooks the Ross Barnett Reservoir is located just outside the back entrance gate, also the location is superb - just minutes from restaurants, shopping, and much more. This Magnificent Home has 5 bedrooms and 6 bathrooms over its 6742 square feet of living space, a Grand Entry Foyer with Stunning Staircase beautiful Chandelier, Grand Dining room, Stately Office, Antique Wood flooring through, Exquisite Fixtures, Faucets, and Hardware, Stone Counters, Gutters, Circle Drive, Professionally Landscaped Yard with Irrigation System, Landscape Lighting, and so much more all tucked away on a beautiful one-acre lot. Upon arriving you will notice many inspiring features before you ever take a step into the interior. Start by walking up the Ellegant brick steps as you make your way to the Antique Pine Front door with beautiful glass transoms accenting both sides, you may notice the many floor to ceiling windows with their handcrafted shutters, don't miss the brick flooring, massive collum's, shiplap ceiling, dual gas lanterns, this is a wraparound porch, with multiple sitting areas, the entrance is thoughtful and timeless. This Home was masterfully constructed as you enter be inspired by the Grand Foyer with its stunning Staircase and Iron Banister, the Formal Dining room is large and elegant space, this Kitchen is world class with Stainless Steel Appliances to include a high-end double oven range with 2 griddles and 4 burners, large Island with seating for 6, farmhouse sink, custom cabinets for storage, marble counters, and a built-in sub-zero refrigerator, Buttler's Pantry with sink, ice maker, and wine fridge, solid counter, gorgeous tilework, wine racks, and glass open shelving, separate walk-in pantry and appliance pantry, the Keeping room has a grand fireplace, brick accent wall, and multiple large windows showing the lovely views over the back yard. The Great room is very large, the focal points in this room would be the Grand Brick Fireplace, Antique Pine Beams accenting the celling, and the 3 French doors leading to the covered porch. The back porch offers great entertaining space for ample seating and a built-in Gas grill for grilling. There is a stunning office with a fireplace and custom built-in bookcases. The Master suite is extremely large with room for separate sitting with access to the porch. The double-sided master bathroom has a vessel soaking tub, walkthrough shower, and a huge closet. The upstairs includes multiple bedrooms, large game room media room with kitchenette, cedar closet, storage galore and 4 attics. The exterior offers a fully landscaped yard with a circle drive and side entry garage as well as a fully fenced back yard. This home is magnificent and has many features that are not mentioned including a new roof, central vacuum, sound system, 3 fireplaces, laundry room with multiple windows, a sink, built-ins, and door to the porch, this home really has it all. Call your Realtor today and schedule your private tour!
MlsNumber: --
ListingId: 4065244


Listing Provided By: Turn Key Properties, LLC, original listing
Phone: (601) 906-5956
Office Phone: (601) 427-5088
Agent Name: Katie Warren
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 = 1449 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 Camryn Greer
Camryn Greer
ASCIIMcCool Thorpe Real Estate
Call Today!: (662) 739-7661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App