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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

306 Sycamore Drive
Mauldin, SC 29662

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $385,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: BHHS C Dan Joyner - Midtown

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer
Architectural Style: New Traditional
Construction Materials: Brick, Brick Veneer
Flooring: Tile, Vinyl, Tile - Ceramic
Interior Features: Cable Available, Open Floor Plan, Ceiling Smooth, Countertops-Solid Surface, Sec. System-Owned/Conveys, Countertops Granite
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Utilities: Cable Available

Window Features

Exterior Features: Vinyl/Aluminum Trim
Roof: Shingle, Composition

Neighborhood/Schools

Elementary School/District: Bethel
Middle/Junior High School/District:
High School/District: Mauldin
Subvidision Name: Eastdale

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Listing Offered by Dina Elm Berkshire Hathaway C. Dan Joyner REALTORS. For Information contact Dina Elm @ [email protected] 864-915-4254. Welcome to your new home in the heart of Mauldin, SC! Nestled on a spacious .41-acre lot with no HOA, this Ranch Tri-Split home boasts timeless charm and modern updates. Crafted with enduring full brick, this residence offers not just a home, but a lifestyle of convenience and comfort. Step inside to discover the elegance of luxury vinyl flooring that graces every corner, offering both durability and style. The heart of the home, the kitchen, beckons with its inviting island, gleaming stainless-steel appliances, and a dazzling tile backsplash. Entertaining is a delight as this culinary space seamlessly flows into the dining area, where a charming fireplace adds warmth and ambiance. Ascend to the second level where tranquility awaits in the master bedroom, complete with a full bath featuring pristine tile floors and a rejuvenating shower. Two additional guest rooms and bathroom await, meticulously remodeled with tasteful tile flooring, vanity and a tub/shower combo. Venture downstairs to the basement, where the versatility is endless. Discover a comfortable bedroom, a cozy sitting area, charming fireplace and a full bath, perfect for accommodating guests or creating a private retreat. The expansive Flex/Bonus area offers endless possibilities, whether it be a home office, a fitness haven, or additional storage. With a separate walkout entrance, this space also presents an opportunity for independent living, catering to diverse needs and preferences. Outside, the allure continues with an extra storage garden shed and a utility closet in the carport, ensuring ample space for all your belongings and equipment. Embrace the convenience of this prime location, just moments away from shopping centers, esteemed physicians, and top-rated schools. Don't miss your chance to experience the epitome of Mauldin living. Schedule your showing today and make this exceptional property your own! Welcome Home 306 Sycamore Drive!
MlsNumber: --


Listing Provided By: BHHS C Dan Joyner - Midtown, original listing
Phone: (864) 242-6650
Office Phone: (864) 242-6650
Agent Name: Dina Elm
Disclaimer: Copyright © 2024 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 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 ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Shannon Humphries NMLS# 180810
Shannon Humphries NMLS# 180810
ASCIIHomebridge Financial Services
Call Today!: (864) 915-7777

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App