Title Page Background
DEBUG FN args: Array ( [0] => 2337 [1] => [2] => [3] => agent ) BEFORE: Site: 2337 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2337 Igate: njhud LocID: 2337 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2337 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2337 [1] => [2] => [3] => lender ) BEFORE: Site: 2337 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2337 Igate: njhud LocID: 2337 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2337 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2337 [1] => [2] => [3] => other ) BEFORE: Site: 2337 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2337 Igate: njhud LocID: 2337 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2337 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

103 White Magnolia Way
Marietta, SC 29661
Kimberly Roberts with BHHS C Dan Joyner - Midtown, original listing - (864) 242-6650

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: BHHS C Dan Joyner - Midtown
Agency Phone: (864) 242-6650

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Step into timeless elegance in this extraordinary Old World-inspired residence, nestled within The Cliffs at Mountain Park. Perfectly situated just one minute from the front gate and within easy reach of world-class amenities, this one-level home offers the perfect blend of classic charm and modern luxury. Every detail has been thoughtfully curated—from the construction materials to the hand-selected reproduction lighting fixtures, custom shutters, and carefully chosen textiles that reflect the home’s rich character. The exterior makes a striking first impression with its combination of stucco and dry-stacked natural stone, crowned by a slate roof, copper gutters, and downspouts. A wrought-iron gate welcomes you into the enchanting front courtyard. Inside, the great room features a soaring 14-foot ceiling with rustic cedar beams and a dramatic, hand-crafted reproduction of an 18th-century French mantel, reaching to the ceiling above the grand fireplace. The kitchen is a true work of art: antique terra cotta tiles reclaimed from Provençal rooftops pave the floors, while the island is topped with oiled solid black walnut, developing a rich patina over time. Honed granite countertops, copper sinks and fixtures, and a stunning LaCanche range imported from France—complete with gas and electric ovens—enhance the kitchen’s rustic elegance. A stacked stone surround and terra cotta tile backsplash complete the look. Adjacent to the kitchen is a welcoming hearth room with a second stacked stone fireplace, cozy dining area, and floor-to-ceiling windows that frame breathtaking long-range mountain views. Step onto the expansive screened porch with its own massive stone fireplace—an ideal space for entertaining on cool evenings. The newly added luxury gunite pool and spa take full advantage of the home’s elevated position, offering panoramic mountain vistas and a private oasis perfect for relaxation or entertaining in style. The master suite exudes warmth and luxury, featuring a limestone fireplace, a spacious keeping area, and large windows that bathe the room in natural light and showcase the stunning landscape. A generous walk-through closet seamlessly connects the dressing room to the spa-like master bath. Across the hall, the study captivates with its rounded wall entrance and hand-finished plaster walls, adding even more charm and distinction—and offering flexibility as a potential fourth bedroom if desired. Don’t miss this rare opportunity to own one of the Upstate’s most uniquely crafted homes. Schedule your private tour today and experience the perfect marriage of Old World artistry and modern luxury.
MlsNumber: --
ListingId: 1558487


Listing Provided By: BHHS C Dan Joyner - Midtown, original listing
Phone: (864) 242-6650
Office Phone: (864) 242-6650
Agent Name: Kimberly Roberts
Disclaimer: Copyright © 2025 Greater Greenville Association of Realtors. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => greenville [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: greenville State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: greenville State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2337 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Distinguished Realty of South Carolina
Distinguished Realty of South Carolina
Call Today!: (864) 818-7653

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => greenville [3] => SC [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: greenville State: SC Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: greenville State: SC Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2337 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Mark Krueger, NMLS#358631
ASCIILifeTree Lending, LLC.
Call Today!: (864) 208-6609

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App