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" = 171305) 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-05-22 08:13:26.192205) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 120 Listings

$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.

$2,250,000

126 North Lake Drive

Sunset, SC

5 BDs, 5 BAs

MLS: 1365679

The Reserve At Lake Keowee

Source: Greater Greenville Association of REALTORS®

Steve White - All-Star Co. Inc.

$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,779,000

250 Long Ridge Road

Sunset, SC

4 BDs, 4 BAs

MLS: 1367722

Other

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

$1,695,000

230 Long Ridge Road

Sunset, SC

5 BDs, 5 BAs

MLS: 1340423

The Reserve At Lake Keowee

Source: Greater Greenville Association of REALTORS®

Libby Zorbas - Kw Luxury Lake Living

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.

CONTINGENCY CONTRACT

$1,649,000

174 CHESTNUT OAKS Drive

Pickens, SC

5 BDs, 5 BAs

MLS: 1356136

 

Source: Greater Greenville Association of REALTORS®

Chet Smith - Bhhs C Dan Joyner - N. Pleas

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
303 Crooked Rock Lane
Sunset, SC 29685
3/2/18 1595000 Other
606 Wind Flower Drive
Sunset, SC 29685
4/27/18 949000 The Cliffs at Keowee Vineyards
1234 Reserve Boulevard
Sunset, SC 29685
2/28/18 879000 The Reserve at Lake Keowee
117B Portside Court
Sunset, SC 29685
5/11/18 589000 The Cliffs at Keowee Vineyards
108 Sweetshrub Way
Sunset, SC 29685
5/4/18 549000 Other
429 Allgood Bridge Road
Pickens, SC 29671
3/13/18 456900 None
2024 Mount Tabor Church Road
Easley, SC 29640
5/10/18 320000 None
148 Blue Hills Trail
Pickens, SC 29671
3/20/18 299900 None
106 cliffside Trail
Pickens, SC 29671
5/7/18 299900 Keowee Mountain Lake Estates
107 Roanoke Road
Liberty, SC 29657
5/8/18 289900 None
103 Devon Court
Easley, SC 29640
5/9/18 275000 Hood Estates
207 Cold Springs Church Road
Pickens, SC 29671
4/2/18 274900 None
288 Big Rock Lake Road
Pickens, SC 29617
5/3/18 250000 Big Rock Lake
229 Laurel Oak Lane
Pickens, SC 29671
5/11/18 249900 The Oaks
507 MT. TABOR CHURCH Road
Pickens, SC 29671
2/28/18 249900 None
129 Kennelworth Way
Easley, SC 29640
5/18/18 249900 Georgetown
207 Ossie Hayes Road
Pickens, SC 29671
5/10/18 239900 None
1792 Ireland Road
Pickens, SC 29671
5/11/18 234900 None
136 The Season Drive
Sunset, SC 29685
5/4/18 234900 None
129 Cannon Lane
Easley, SC 29640
5/4/18 225888 Rolling Green
220 Raven Cliff Road
Cleveland, SC 29635
3/16/18 225000 River Bluff
115 Aiken Farm Road
Pickens, SC 29671
3/20/18 218000 Saddlebrook
416 Hidden Valley Road
Pickens, SC 29671
3/22/18 204900 None
262 Belvoir Drive
Pickens, SC 29671-8348
4/6/18 199000 Gauley Falls
124 Fulda Court
Pickens, SC 29671
2/23/18 199000 The Rock at Jocassee