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 (charleston walk) AND "idx_listings"."updated" > 2018-06-17 04:17:31.741926) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

$475,000

240 Grandmont Court

Greer, SC

5 BDs, 4 BAs

MLS: 1341159

Charleston Walk

Source: Greater Greenville Association of REALTORS®

Holly May - Blackstream International Re

$469,000

236 Grandmont Court

Greer, SC

5 BDs, 4 BAs

MLS: 1361519

Charleston Walk

Source: Greater Greenville Association of REALTORS®

Holly May - Blackstream International Re

$459,000

9 Stonewash Way

Greer, SC

3 BDs, 4 BAs

MLS: 1361662

Charleston Walk

Source: Greater Greenville Association of REALTORS®

Holly May - Blackstream International Re

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
16 Baronne Court
Greer, SC 29650
6/8/18 1299000 Thornblade
614 Lancashire Court
Greenville, SC 29615
5/21/18 1225000 Blackstone
140 Rocky Point Circle
Greenville, SC 29615
3/26/18 974900 Rocky Creek Acres
14 Baronne Court
Greer, SC 29650
5/11/18 899900 Thornblade
8 Ruffian Way
Greenville, SC 29615
6/15/18 825000 Spaulding Farm
18 Norman Place
Greenville, SC 29615
4/30/18 799000 Stonebrook Farm
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
204 Buckland Way
Greenville, SC 29615
3/30/18 699900 Spaulding Farm
1 Hunters Run
Greenville, SC 29615
4/30/18 699000 Spaulding Farm
108 Charleston Oak Lane
Greenville, SC 29615
5/29/18 690000 The Oaks at Roper Mountain
2335 Roper Mountain Road
Simpsonville, SC 29681
5/21/18 675000 Deerland Plantation
521 Spaulding Lake Drive
Greenville, SC 29615
6/15/18 675000 Spaulding Farm
7 Prestige Court
Greenville, SC 29615
5/29/18 650000 Other
31 HIGHFIELD Court
Greer, SC 29650
5/25/18 624900 Hammett Creek
216 Sweetbriar Road
Greenville, SC 29615
6/15/18 619900 Lake Forest Heights
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
20 Lowther Hall Lane
Greenville, SC 29615
4/30/18 575000 Plantation on Pelham
112 Hunters Run
Greenville, SC 29615
3/27/18 574900 Spaulding Farm
5 Angel Oak Court
Greenville, SC 29615
4/27/18 572500 The Oaks at Roper Mountain
6 Terrapin Trail
Taylors, SC 29687
6/15/18 565000 Pebble Creek
5 Terra Lane
Greenville, SC 29615
5/31/18 565000 Terra Oaks

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.