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" = 175666) AND "idx_listings"."created" > 2018-08-20 02:06:30.169420 AND "idx_listings"."updated" > 2018-08-19 02:06:30.169400) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 500 Listings

NEW

$3,900,000

257 Chalmers Mountain

Walhalla, South Carolina

 

MLS: 20205942

 

Source: Anderson / Seneca MLS

Guy Thurmond - Thurmond & Associates, Inc.

NEW

$3,900,000

734 Sharon Church

Liberty, South Carolina

3 BDs, 2 BAs

MLS: 20204638

 

Source: Anderson / Seneca MLS

Jenks Patrick - Jenks Inc. Realty

NEW

$3,300,000

807 Belk

Anderson, South Carolina

 

MLS: 20206260

 

Source: Anderson / Seneca MLS

John Powell - Nai Earle Furman, Llc

NEW

$3,300,000

807 Belk

Anderson, South Carolina

 

MLS: 20206256

 

Source: Anderson / Seneca MLS

John Powell - Nai Earle Furman, Llc

NEW

$2,895,000

117 E Fort George

Sunset, South Carolina

5 BDs, 4 BAs

MLS: 20205484

The Reserve At Lake Keowee

Source: Anderson / Seneca MLS

Lisa Vogel - Keowee River Club, Llc

NEW

$2,799,500

00 HWY 81 N

Anderson, South Carolina

 

MLS: 20205835

 

Source: Anderson / Seneca MLS

Roy Jeffcoat - Anderson Realty

NEW

$1,995,000

305 Kingfisher

Salem, South Carolina

5 BDs, 5 BAs

MLS: 20205653

Cliffs At Keowee Falls North

Source: Anderson / Seneca MLS

Justin Winter Sotheby's International - Justin Winter Sothebys Int'l

NEW

$1,995,000

305 Kingfisher Lane

Salem, SC

5 BDs, 5 BAs

MLS: 1374628

The Cliffs At Keowee Falls North

Source: Greater Greenville Association of REALTORS®

Justin Winter - Justin Winter Sotheby's Intl.

NEW

$1,695,000

685 Monitor

Anderson, South Carolina

 

MLS: 20205764

 

Source: Anderson / Seneca MLS

Hugh Durham - Coldwell Banker Durham & Assoc

NEW

$1,649,000

213 Horse Head Point

Seneca, South Carolina

5 BDs, 5 BAs

MLS: 20204634

Stillwater

Source: Anderson / Seneca MLS

Gregory Coutu - Allen Tate - Lake Keowee Water

NEW

$1,498,000

5 Redgold

Greer, South Carolina

5 BDs, 4 BAs

MLS: 20206062

Thornblade

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

NEW

$1,399,000

219 S Lake

Sunset, South Carolina

4 BDs, 4 BAs

MLS: 20205561

The Reserve At Lake Keowee

Source: Anderson / Seneca MLS

Justin Winter Sotheby's International - Justin Winter Sothebys Int'l