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 (ashley grove) AND "idx_listings"."updated" > 2018-06-16 11:01:54.482138) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

CONTINGENCY CONTRACT

$165,000

9 RED HAVEN Court

Greer, SC

4 BDs, 2 BAs

MLS: 1368032

Ashley Grove

Source: Greater Greenville Association of REALTORS®

Haro Setian - Keller Williams Historic Dist.

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
16 Baronne Court
Greer, SC 29650
6/8/18 1299000 Thornblade
14 Baronne Court
Greer, SC 29650
5/11/18 899900 Thornblade
2 Saint Helaine Place
Greer, SC 29650
5/17/18 779000 Barrington Park
105 Antigua Way
Greer, SC 29650
3/29/18 749000 Thornblade
205 Belfrey Drive
Greer, SC 29650
4/16/18 709900 Barrington Park
207 Chelsea Lane
Greer, SC 29650-3262
6/8/18 709000 Chelsea Woods
31 HIGHFIELD Court
Greer, SC 29650
5/25/18 624900 Hammett Creek
217 Terra Woods Drive
Greenville, SC 29615
6/15/18 610000 Terra Woods
711 Lady Hillingdon Court
Greer, SC 29650
6/11/18 592250 Battery at Thornblade
5 Terra Lane
Greenville, SC 29615
5/31/18 565000 Terra Oaks
6 Terrapin Trail
Taylors, SC 29687
6/15/18 565000 Pebble Creek
300 Windsor Road
Greer, SC 29651
4/27/18 559000 Belmont Heights
323 Raes Creek Drive
Greenville, SC 29609
5/10/18 510000 Linkside III
1400 Thornblade Boulevard
Greer, SC 29650
4/11/18 500000 Villas at Thornblade
804 Ladykirk Lane
Greer, SC 29650
5/3/18 499900 Carisbrooke
603 Scarborough Drive
Greer, SC 29650
5/15/18 499900 Barrington Park
1045 Owens Road
Greer, SC 29651
4/27/18 495000 None
1 Penny Meadow Court
Greer, SC 29650
4/12/18 458500 River Oaks
15 Stonybrook Drive
Greenville, SC 29615
5/21/18 449900 Botany Woods
619 Meadow Grove Way
Greer, SC 29650
6/4/18 449500 Brushy Meadows
19 Brannons View Drive
Taylors, SC 29687
5/11/18 429000 Pebble Grove
124 Amandas Autumn Lane
Taylors, SC 29687
3/26/18 424900 Pebble Grove
104 Botany Road
Greenville, SC 29615
5/3/18 424900 Botany Woods
103 Sugar Mill Court
Greer, SC 29650
5/3/18 424900 Sugarmill
103 Sugarfield Court
Greer, SC 29650
6/14/18 409900 Sugar Creek

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.