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

109 Turnhouse Lane
Simpsonville, SC 29681

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $948,000
Beds: 4
Baths:
Status: Active
SqFt: --
Agency: Keller Williams Greenville Cen

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Garbage Disposer
Architectural Style: New Traditional
Construction Materials: Brick, Stone, Brick Veneer
Flooring: Carpet, Tile, Wood, Tile - Ceramic
Heating: Forced Air
Interior Features: Central Vacuum, Ceiling Fan, Cable Available, Open Floor Plan, Smoke Detector, Bookcase, Walk In Closet, Ceiling 9ft+, Ceiling Smooth, Tub Garden, Sec. System-Owned/Conveys, Pantry – Walk In, 2 Story Foyer, Countertops Granite, Tub-Jetted, Ceiling – Coffered, Attic Stairs Disappearing
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Utilities: Cable Available

Window Features

Exterior Features: Deck, Balcony, Porch-front, Porch-wrap Around, Porch-screened, Windows-Insulated, Sprklr In Grnd-Full Yard, Tilt Out Windows, Under Ground Irrigation
Patio and Porch Features: Porch, Deck

Neighborhood/Schools

Elementary School/District: Bryson
Middle/Junior High School/District:
High School/District: HILLCREST
Subvidision Name: Sycamore Ridge

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: 109 Turnhouse Lane, Simpsonville. Martha Durgin, Keller Williams Greenville Central, 864-881-8240. Gracious Home located within the community of Sycamore Ridge. Quality craftsmanship, spacious rooms, mainfloor master with sitting room/office and balcony, gourmet kitchen with beautiful custom cabinets and granite counter tops. Fireplaced living room and great room, wrap around covered porch, 3 additional large bedrooms on the 2nd floor with a bonus room w/wet bar and theater room. 3- car garage plus detatched garage/storage building with electricity in the back yard. Private .59 acre lot with fenced in back yard and fireplace. New roof and gutters with gutter guards, recently painted interior, new garage doors and openers, 2 water supplies and all new smoke detectors and surge protection. A must to see.
MlsNumber: --


Listing Provided By: Keller Williams Greenville Cen, original listing
Phone: (864) 400-4200
Office Phone: (864) 400-4100
Agent Name: Martha Durgin
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 ('nwhud','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 = 'nwhud', 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