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-06-17 04:12:35.516575) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 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

$160,000

325 Seven Oaks Lane

Spartanburg, SC

3 BDs, 2 BAs

MLS: 1367816

Camelot

Source: Greater Greenville Association of REALTORS®

LeAnne Carswell - The Leanne Carswell Expert Re

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
108 Chickasaw Run
Williamston, SC 29697
6/14/18 569900 Other
128 Lantern Ridge Drive
Easley, SC 29642
3/30/18 439900 Lantern Ridge
1 Sparrow Drive
Williamston, SC 29697
6/1/18 430000 Ridgewood Plantation
7 Ione Circle
Williamston, SC 29697
3/23/18 414900 Ridgewood Plantation
102 Clara Smith Lane
Piedmont, SC 29673
5/2/18 402960 Bagwell Farms
105 Birch Meadow Drive
Piedmont, SC 29673
5/31/18 389000 Birch Meadow
202 Wren School Road
Piedmont, SC 29673
5/18/18 374900 None
1003 Shoal Creek Way
Easley, SC 29642
4/26/18 365750 Airy Springs
115 Hunting Meadow Drive
Williamston, SC 29697
5/31/18 360000 Other
1005 Trescott Lane
Easley, SC 29642
5/14/18 339900 Pendleton Plantation 054
120 Croxton Road
Williamston, SC 29697
5/24/18 329900 None
14 Nickel Springs Drive
Easley, SC 29642
6/13/18 314900 Avendell
121 Coppermine Drive
Easley, SC 29642
5/8/18 271000 Avendell
297 SASSAFRAS Drive
Easley, SC 29642
5/25/18 267900 Hornbuckle
1201 Whippoorwill Road
Pelzer, SC 29669
5/29/18 260000 None
103 Weston Estates Drive
Easley, SC 29642
4/27/18 259900 Weston Estates
101 Quail Court
Piedmont, SC 29673
4/13/18 259000 Prestwick
5135 Sunset Drive
Easley, SC 29642
3/30/18 254900 Sunset Ridge
284 Sassafras Drive
Easley, SC 29642
4/20/18 250000 Hornbuckle
122 Robinwood Lane
Pelzer, SC 29669
5/14/18 249900 Robinwood
101 PINEWOOD Drive
Piedmont, SC 29673
4/30/18 249444 None
114 Mountain Lake Drive
Piedmont, SC 29673
4/13/18 248900 Mount Vernon Estates
105 Yount Court
Easley, SC 29642
4/27/18 239900 Rose Hill
170 Haverhill Lane
Easley, SC 29642
6/8/18 238000 Rose Hill
201 Bonanza Circle
Piedmont, SC 29673
4/27/18 235000 Ponderosa

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.