SELECT "idx_listings"."id", "idx_listings"."proptype", "idx_listings"."subtype", "idx_listings"."idx_id", "idx_listings"."mls_id", "idx_listings"."status", "idx_listings"."created", "idx_listings"."updated", "idx_listings"."price", "idx_listings"."price_reduced", "idx_listings"."listing_agent", "idx_listings"."listing_office", "idx_listings"."listing_agent_id", "idx_listings"."co_listing_agent", "idx_listings"."co_listing_office", "idx_listings"."co_listing_agent_id", "idx_listings"."selling_agent", "idx_listings"."selling_office", "idx_listings"."selling_agent_id", "idx_listings"."address", "idx_listings"."last_geocoded_address", "idx_listings"."lat", "idx_listings"."lon", "idx_listings"."lock_geocode", "idx_listings"."city", "idx_listings"."state", "idx_listings"."zipcode", "idx_listings"."county", "idx_listings"."subdivision", "idx_listings"."original_price", "idx_listings"."beds", "idx_listings"."baths", "idx_listings"."halfbaths", "idx_listings"."foreclosure", "idx_listings"."shortsale", "idx_listings"."sqft", "idx_listings"."lotsize", "idx_listings"."virtualtour", "idx_listings"."openhouse", "idx_listings"."geolocation", "idx_listings"."geometry", "idx_listings"."elementary_school", "idx_listings"."middle_school", "idx_listings"."high_school", "idx_listings"."acres", "idx_listings"."date_listed", "idx_listings"."date_sold", "idx_listings"."sold_price", "idx_listings"."new_construction", "idx_listings"."agent_email", "idx_listings"."year_built", "idx_listings"."area", "idx_listings"."style", "idx_listings"."owner_financing", "idx_listings"."display_address", "idx_listings"."handicap_accessible", "idx_listings"."green_home", "idx_listings"."mls_system_id", "idx_listings"."waterfront", "idx_listings"."lake" FROM "idx_listings" WHERE ("idx_listings"."idx_id" IN (SELECT DISTINCT U0."idx_id" FROM "idxs_idx" U0 INNER JOIN "idxs_idxaccount" U1 ON (U0."idx_id" = U1."idx_id") WHERE U1."user_id" = 163673) AND (UPPER("idx_listings"."proptype"::text) LIKE UPPER(r%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(e%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(s%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(i%)) AND ("idx_listings"."elementary_school" IN (pickens) OR "idx_listings"."middle_school" IN (pickens) OR "idx_listings"."high_school" IN (pickens)) AND "idx_listings"."updated" > 2018-09-22 21:14:55.664506) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 125 Listings

$3,250,000

309 E Fort George Way

Sunset, SC

5 BDs, 5 BAs

MLS: 1372901

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$2,995,000

115 Wood Sage Court

Sunset, SC

6 BDs, 6 BAs

MLS: 1354512

The Cliffs At Keowee Vineyards

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$1,799,000

113 Blazing Star Court

Sunset, SC

5 BDs, 4 BAs

MLS: 1346062

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$1,795,000

134 Teaberry Lane

Sunset, SC

6 BDs, 6 BAs

MLS: 1373829

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

REDUCED

$1,669,000

110 Red Buckeye Trail

Sunset, SC

5 BDs, 4 BAs

MLS: 1320559

The Cliffs At Keowee Vineyards

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$1,650,000

197 Lake Wood Lane

Sunset, SC

2 BDs, 1 BAs

MLS: 1348352

 

Source: Greater Greenville Association of REALTORS®

Constance Finley - Felix Finley Real Estate, Inc.

REDUCED

$1,599,000

210 Passion Flower Way

Sunset, SC

5 BDs, 5 BAs

MLS: 1373823

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$1,595,000

107 Solomons Seal Lane

Sunset, SC

3 BDs, 3 BAs

MLS: 1373825

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
174 CHESTNUT OAKS Drive
Pickens, SC 29671
7/2/18 1499000 None
344 Chinquapin Road
Easley, SC 29640
9/17/18 399900 None
996 Wolf Creek School Road
Pickens, SC 29671
9/6/18 300000 None
2645 Pumpkintown Highway
Pickens, SC 29671
7/16/18 298000 None
119 Pine Hill Drive
Pickens, SC 29671
9/14/18 259900 Other
106 Fox Squirrel Ridge Circle
Pickens, SC 29671
8/16/18 184900 Other
1169 Fox Squirrel Ridge Road
Pickens, SC 29671
8/20/18 179900 None
106 Bradley Drive
Pickens, SC 29671
8/23/18 152999 Millstone
217 Lakewood Drive
Pickens, SC 29671
8/31/18 150000 Lakewood Estate
108 Sugar Maple Drive
Pickens, SC 29671
8/31/18 150000 Lakewood Estate
107 Regency Walk
Pickens, SC 29671
7/31/18 150000 Other
213 Judy Drive
Pickens, SC 29671-8947
8/30/18 149900 Forest Hill
122 Medlin Drive
Pickens, SC 29671
8/20/18 149900 None
112 Hayes Road
Pickens, SC 29671
9/17/18 148900 None
105 Timber Drive
Pickens, SC 29671
9/5/18 144900 Lakewood Estate
121 Judy Drive
Pickens, SC 29671
8/24/18 139800 Forest Hill
205 Liberty Drive
Pickens, SC 29671
9/21/18 134900 None
184 knollwood heights Road
Pickens, SC 29671
8/20/18 134900 None
112 Dakota Trail
Pickens, SC 29671
8/14/18 109900 None
133 Gilliland Road
Pickens, SC 29671
7/17/18 104900 Other
221 Newton Hill Road
Pickens, SC 29671
7/20/18 92900 None
1381 Midway Road
Pickens, SC 29671
9/14/18 88000 None
248 Margaret Street
Pickens, SC 29651
7/27/18 82500 None
108 Left Fork Road
Pickens, SC 29671-8515
8/10/18 24900 Other
229 N Glassy Mountain Road
Pickens, SC 29671
8/29/18 24900 None