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 (crestland) AND "idx_listings"."updated" > 2018-07-15 13:01:07.782142) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

PENDING

$159,900

100 Havenshire

Anderson, South Carolina

4 BDs, 2 BAs

MLS: 20204165

Crestland

Source: Anderson / Seneca MLS

Chappelear and Associates - Western Upstate Kw

NEW

$155,000

103 Lochenshire

Belton, South Carolina

3 BDs, 2 BAs

MLS: 20204962

Crestland

Source: Anderson / Seneca MLS

Claude Turpin - The Agentowned Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
110 Cordova Court
Belton, SC 29627
5/17/18 549000 None
129 Rivendell
Anderson, South Carolina 29621
6/13/18 498500 Rivendell
1028 Omega Farms Lane
Williamston, SC 29697
6/14/18 474900 Omega Farms
123 Ridgeway Trail
Anderson, SC 29621
7/6/18 399000 Other
1042 Tuscany Drive
Anderson, SC 29621
5/30/18 309900 Other
107 Cathey Road
Anderson, SC 29621
5/24/18 300000 None
111 Grove Park Drive
Anderson, SC 29621
6/28/18 299900 Brookstone Meadows
5410 Midway Road
Williamston, SC 29697
5/31/18 279000 None
100 Golden Eagle Lane
Anderson, SC 29621
5/29/18 236037 Arbors at Cobbs Glen
3003 Midway Road
Anderson, SC 29621
6/22/18 227500 None
104 Leland Heights Drive
Williamston, SC 29697
7/9/18 219000 Other
129 Running Fox Lane
Belton, SC 29627
6/26/18 215000 Wild Deer Crossing
121 Coosa Lane
Anderson, SC 29621
5/8/18 203000 Willow Haven at Cobbs Glen
144 Rock Moss Drive
Williamston, SC 29697
4/30/18 178000 Other
213 Carrageen Drive
Williamston, SC 29697
5/11/18 173000 Other
101 Foghorn Court
Williamston, SC 29697
5/11/18 169000 Hidden Anchor
1406 Whiten Road
Belton, SC 29627
6/13/18 145000 None
801 Garren Road
Belton, SC 29627
4/23/18 145000 None
105 Wild Turkey Road
Williamston, SC 29697
5/16/18 139900 Other
106 Windfield Hill Road
Williamston, SC 29697
7/13/18 125000 None
219 Lufkin Drive
Williamston, SC 29697
7/6/18 118000 None
202 Mahaffey Road
Williamston, SC 29697
4/30/18 112000 None
104 McAlister Circle
Williamston, SC 29697-9763
4/20/18 98000 None
1104 Anderson Drive
Williamston, SC 29697
6/15/18 75900 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.
Site Maintenance
at 8 p.m. EDT
(Click for details)