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 (crayton hall) AND "idx_listings"."updated" > 2018-08-16 23:59:45.993576) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

REDUCED

$184,000

32 Hillsborough

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20200925

Crayton Hall

Source: Anderson / Seneca MLS

Suzette Christopher - Re/Max Realty Prof/Anderson

REDUCED

$159,900

34 Hillsborough

Anderson, South Carolina

2 BDs, 2 BAs

MLS: 20203682

Crayton Hall

Source: Anderson / Seneca MLS

ROZLYNN INC - Coldwell Banker Durham & Assoc

REDUCED

$159,900

34 Hillsborough Drive

Anderson, SC

2 BDs, 2 BAs

MLS: 1369312

Crayton Hall

Source: Greater Greenville Association of REALTORS®

Rozlynn Hood - Coldwell Banker Hugh Durham As

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
109 Foxcroft Way
Anderson, SC 29621
6/29/18 629700 Other
110 Harlond Drive
Anderson, SC 29621
7/31/18 529000 Rivendell
129 Rivendell
Anderson, South Carolina 29621
6/13/18 498500 Rivendell
900 Windy Hill Drive
Anderson, SC 29621
5/15/18 489000 None
201 Oakmont Drive
Anderson, SC 29621
8/17/18 479900 Oakmont
1028 Omega Farms Lane
Williamston, SC 29697
6/14/18 474900 Omega Farms
123 Ridgeway Trail
Anderson, SC 29621
7/6/18 399000 Other
724 Sunny Shore Lane
Anderson, SC 29621
7/20/18 390000 Other
100 Briar Creek Lane
Anderson, SC 29621
7/11/18 389900 Other
326 Stephen King Drive
Anderson, SC 29621
6/25/18 354900 Other
5151 Slater Road
Anderson, SC 29621
6/27/18 345000 None
128 Baybrooke Lane
Anderson, SC 29621
8/2/18 344900 Other
102 Sunrise Harbor Drive
Anderson, SC 29621
7/6/18 339900 Other
108 Wild Meadows Drive
Anderson, SC 29621
7/2/18 339100 Wild Meadows
132 Baybrooke Lane
Anderson, SC 29621
7/27/18 324900 Kensington Plantation
106 McPhail Farms Circle
Anderson, SC 29621
6/21/18 319900 Other
8 Chardonnay Drive
Anderson, SC 29621
7/31/18 316900 Mystic Vineyards
134 Jones Creek Circle
Anderson, SC 29621
7/27/18 316000 None
1042 Tuscany Drive
Anderson, SC 29621
5/30/18 309900 Other
111 Grove Park Drive
Anderson, SC 29621
6/28/18 299900 Brookstone Meadows
135 Hammett Acres Road
Anderson, SC 29621
7/6/18 299000 Other
414 Ashley Downs
Anderson, SC 29621-2410
6/27/18 295000 None
2905 Cobbs Way
Anderson, SC 29621
7/20/18 290000 Cobbs Glen
146 Jones Creek Circle
Anderson, SC 29621
6/13/18 288900 Covered Bridge at Jones Creek
2029 Moultrie Square
Anderson, SC 29621
6/4/18 279000 None

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.