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-10-17 04:23:03.713895) 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
260 Snow Road
Pelzer, SC 29669
8/31/18 595000 None
605 Glen Meadows Drive
Simpsonville, SC 29680
8/20/18 550000 Glen Meadows
640 Harrison Bridge Road
Simpsonville, SC 29680
9/28/18 499999 Fox Hollow Farm
109 Bingham Way
Simpsonville, SC 29680
8/15/18 489900 Glen Meadows
116 Pinehaven Way
Simpsonville, SC 29680
8/23/18 450000 Glen Meadows
9 Tippecanoe Street
Simpsonville, SC 29680
10/9/18 445000 River Shoals
420 Santa Cruz Way
Greenville, SC 29680
8/24/18 440000 The Courtyards on West Georgia R
371 Alverson Road
Pelzer, SC 29669-9399
9/11/18 429900 None
201 Weatherstone Lane
Simpsonville, SC 29680
7/31/18 425000 Weatherstone
100 Weatherstone Lane
Simpsonville, SC 29680
8/31/18 418000 Weatherstone
33 Lazy Willow Drive
Simpsonville, SC 29680
8/28/18 389900 Greythorne
14 Foxmoor Court
Simpsonville, SC 29680
9/10/18 385000 Lost River
506 Worchester Place
Simpsonville, SC 29680
8/28/18 359900 Neely Farm
607 Briar Thistle Court
Simpsonville, SC 29680
7/30/18 359400 Lost River
39 Governors Lake Way
Simpsonville, SC 29680
10/15/18 355000 The Estates @ Governors Lake
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
114 Locke Lane
Mauldin, SC 29662
9/6/18 339900 Knollwood Heights
222 McCall Road
Simpsonville, SC 29680
10/5/18 339000 None
2 Lucerne Court
Simpsonville, SC 29680
8/31/18 329900 Verdmont
539 Hipps Road
Simpsonville, SC 29680
9/25/18 327795 None
108 Sunlit Drive
Simpsonville, SC 29680
10/3/18 324950 Cottages at Harrison Bridge
533 Hipps Road
Simpsonville, SC 29680
10/11/18 319900 None
301 Clairhill Court
Simpsonville, SC 29680
7/31/18 315000 Verdmont
402 Hayworth Drive
Simpsonville, SC 29680
8/17/18 315000 Verdmont

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 9 p.m. EDT
on Oct. 19th
(Click for details)