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 (ashmore lakes) AND "idx_listings"."updated" > 2018-08-18 11:05:27.249548) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

$325,400

305 Scenic Lake Court

Piedmont, SC

4 BDs, 3 BAs

MLS: 1370414

Ashmore Lakes

Source: Greater Greenville Association of REALTORS®

Stan McAlister - Mcalister Realty

$310,400

325 Scenic Lake Court

Piedmont, SC

4 BDs, 2 BAs

MLS: 1370416

Ashmore Lakes

Source: Greater Greenville Association of REALTORS®

Stan McAlister - Mcalister Realty

$307,700

26 Hidden Lake Court

Piedmont, SC

4 BDs, 3 BAs

MLS: 1370415

Ashmore Lakes

Source: Greater Greenville Association of REALTORS®

Stan McAlister - Mcalister Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
220 Weatherstone Lane
Simpsonville, SC 29680
7/12/18 540000 Weatherstone
109 Bingham Way
Simpsonville, SC 29680
8/15/18 489900 Glen Meadows
117 Bingham Way
Simpsonville, SC 29680
7/9/18 489900 Glen Meadows
200 Weatherstone Lane
Simpsonville, SC 29680
7/16/18 489500 Weatherstone
201 Weatherstone Lane
Simpsonville, SC 29680
7/31/18 425000 Weatherstone
416 Marswen Court
Simpsonville, SC 29680
7/2/18 424900 Weatherstone
201 Quail Hunt Road
Simpsonville, SC 29680
7/20/18 389800 Lost River
202 Walnut Hill Court
Simpsonville, SC 29681
7/23/18 384990 Parker's Landing
342 Laguna Lane
Simpsonville, SC 29680
6/15/18 375000 The Courtyards on West Georgia Road
607 Briar Thistle Court
Simpsonville, SC 29680
7/30/18 359400 Lost River
101 Martele Court
Simpsonville, SC 29680
7/19/18 349900 Verdmont
308 Belle Oaks Drive
Simpsonville, SC 29680
7/31/18 349900 Cottages at Harrison Bridge
109 Brandau Lane
Simpsonville, SC 29680
8/14/18 349749 Weatherstone
1 Leafmore Court
Simpsonville, SC 29680
7/27/18 346284 Leafmore Woods
2725 W Georgia Road
Piedmont, SC 29673
7/16/18 344900 None
15 Sandusky Lane
Simpsonville, SC 29680
6/15/18 339900 River Shoals
213 Kings Heath Lane
Simpsonville, SC 29680
6/22/18 334900 Crossgate at Remington
301 Clairhill Court
Simpsonville, SC 29680
7/31/18 315000 Verdmont
402 Hayworth Drive
Simpsonville, SC 29680
8/17/18 315000 Verdmont
7 Flintlock Court
Piedmont, SC 29673
6/16/18 315000 Garrison Woods
17 Marquette Road
Simpsonville, SC 29680
6/28/18 309900 Verdmont
23 Lucerne Court
Simpsonville, SC 29680
7/9/18 304900 Verdmont
203 Bradbourne Way
Simpsonville, SC 29680
7/12/18 300000 Crossgate at Remington
202 Murphy Lane
Greenville, SC 29607
8/10/18 299900 None
306 Saddlebred Drive
Pelzer, SC 29669
6/26/18 296000 Saddlehorn

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.