to
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" = 173423) 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"."subdivision" IN (camelot) AND "idx_listings"."updated" > 2018-10-19 14:00:45.149317) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$344,000

319 Lancelot

Clemson, South Carolina

4 BDs, 2 BAs

MLS: 20208051

Camelot

Source: Anderson / Seneca MLS

Randal Longo - I Save Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
1000 Campbell Road
Piedmont, SC 29669
8/15/18 949900 None
105 Chestnut Springs Way
Williamston, SC 29697
7/27/18 699200 Chestnut Springs
12 Great Lawn Drive
Piedmont, SC 29673
9/4/18 689900 Rushton
303 Rhetts Run
Easley, SC 29642
8/27/18 459900 Airy Springs
1016 Shoal Creek Way
Easley, SC 29642
8/27/18 444900 Airy Springs
156 Burberry Drive
Williamston, SC 29697
7/24/18 399900 Ridgewood Plantation
202 Avendell Drive
Easley, SC 29642
8/24/18 375000 Avendell
109 Dartford Court
Easley, SC 29642
9/12/18 368900 Rose Hill
22 Olivia Court
Pelzer, SC 29669
7/30/18 340900 The Farms at Spearman Road
119 Colonial Drive
Pelzer, SC 29669
9/28/18 339900 None
3 Dartford Court
Easley, SC 29642
8/31/18 334900 Rose Hill
100 Dartford Court
Easley, SC 29642
7/23/18 334900 Rose Hill
309 Sassafras Drive
Easley, SC 29642
8/17/18 330000 Hornbuckle
101 Jordan Close
Easley, SC 29642
8/17/18 320000 Lee Ridge
117 Armistead Lane
Easley, SC 29642
8/17/18 319700 Pendleton Plantation
130 Wild Hickory Circle
Easley, SC 29642
9/27/18 316900 Enclave at Airy Springs
110 Fairoaks Drive
Williamston, SC 29697
7/27/18 316900 Wyatts Grant
615 N Meadows Lane
Easley, SC 29640
9/4/18 309670 Hunt Meadows
7 Dartford Court
Easley, SC 29642
9/28/18 305000 Rose Hill
108 Dartford Court
Easley, SC 29642
8/23/18 299900 Rose Hill
135 Waltzing Vine Lane
Williamston, SC 29697
10/1/18 299900 Hemlock
408 Planters Walk Drive
Easley, SC 29642
8/10/18 295000 Planters Walk
204 Byron Abbey
Piedmont, SC 29673
9/7/18 290000 Quartermein
100 Clearstone Drive
Easley, SC 29642
10/1/18 289900 Ashley Woods
293 Sassafrass Drive
Easley, SC 29642
8/31/18 269900 Hornbuckle

Robert Haney, REALTOR®


Luxury Collection Specialist, Marketing Specialist, High End Luxury Homes
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
745 N Pleasantburg Dr., Greenville, SC 29607

864-270-4192

Paige Haney, REALTOR®


Luxury Collection Specialist, SFR, Certified Relocation Specialist
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
705 W. Wade Hampton Blvd., Greer, SC 29650

864-414-9937

Equal Housing Oppoortunity
Information is deemed reliable but not guaranteed, and is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify perspective properties consumers may be interested in purchasing. Any use of search facilities of data on the site other than by potential buyers and sellers is prohibited. Sale data is for informational purposes only and is not an indication of a market analysis or appraisal.

All code, applications and designs © 2014-present EASy Media, LLC. All right reserved. Operating under US Patent 8234174 and other Patents Pending.