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-08-18 03:06:42.179417) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-4 of 4 Listings

$1,325,000

2212 Lightwood

Hartwell, Georgia

4 BDs, 3 BAs

MLS: 20200960

Camelot

Source: Anderson / Seneca MLS

Cathy Blevins - Dockside Realty

PENDING

$239,900

220 Camelot

Clemson, South Carolina

5 BDs, 3 BAs

MLS: 20203716

Camelot

Source: Anderson / Seneca MLS

WINKOPP/ KOHOUT - Tom Winkopp & Associates

CONTINGENCY CONTRACT

$174,500

112 Redwood Circle

Spartanburg, SC

3 BDs, 3 BAs

MLS: 1373169

Camelot

Source: Greater Greenville Association of REALTORS®

Nicole Watkins - Allen Tate Company - Greer

CONTINGENCY CONTRACT

$172,500

214 Heather Drive

Spartanburg, SC

4 BDs, 2 BAs

MLS: 1372732

Camelot

Source: Greater Greenville Association of REALTORS®

Steve Wallace - Keller Williams Greenville Cen

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
104 Farm Terrace Court
Easley, SC 29642
6/26/18 699000 The Farm I
1106 Stratford Court
Easley, SC 29642
6/28/18 600000 None
108 Chickasaw Run
Williamston, SC 29697
6/14/18 569900 Other
124 Omega Lane
Piedmont, SC 29673-9783
7/6/18 492500 None
3553 Pelzer Highway
Easley, SC 29642
6/27/18 485000 Farm II
104 Brookside Lane
Piedmont, SC 29673
6/15/18 449000 Other
304 Holborne Drive
Easley, SC 29642
7/30/18 409000 Kensington
7 Knob Creek Court
Easley, SC 29642
7/2/18 389000 Airy Springs
117 Kingsland Way
Piedmont, SC 29673
6/22/18 379900 None
1006 Shiloh Circle
Easley, SC 29642
6/28/18 379900 None
115 Hunting Meadow Drive
Williamston, SC 29697
5/31/18 360000 Other
409 Woodson Road
Piedmont, SC 29673
5/21/18 344900 Woodson Lake
22 Olivia Court
Pelzer, SC 29669
7/30/18 340900 The Farms at Spearman Road
100 Dartford Court
Easley, SC 29642
7/23/18 334900 Rose Hill
155 Wild Hickory Circle
Easley, SC 29642
7/17/18 332900 Enclave at Airy Springs
1216 White Road
Piedmont, SC 29673
7/20/18 330000 None
101 Jordan Close
Easley, SC 29642
8/17/18 320000 Lee Ridge
117 Armistead Lane
Easley, SC 29642
8/17/18 319700 Pendleton Plantation
14 Nickel Springs Drive
Easley, SC 29642
6/13/18 314900 Avendell
106 Clearstone Drive
Easley, SC 29642
7/30/18 299900 Other
2 Duxbury Lane
Easley, SC 29642
7/20/18 299900 Rose Hill
408 Planters Walk Drive
Easley, SC 29642
8/10/18 295000 Planters Walk
1009 Trescott Lane
Easley, SC 29642
6/28/18 276900 Pendleton Plantation 054

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.