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 (UPPER("idx_listings"."address"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."city"::text) LIKE UPPER(%greer%) OR "idx_listings"."city" IN (greer) OR UPPER("idx_listings"."zipcode"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."subdivision"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."elementary_school"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."middle_school"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."high_school"::text) LIKE UPPER(%greer%) OR UPPER("idx_listings"."county"::text) LIKE UPPER(%greer%)) AND "idx_listings"."updated" > 2018-02-22 05:31:01.955232) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 500 Listings

$1,350,000

7 Riley Hill Court

Greer, SC

6 BDs, 6 BAs

MLS: 1358190

Greywood At Hammett

Source: Greater Greenville Association of REALTORS®

Faith Ross - Bhhs C Dan Joyner - N. Pleas

$1,350,000

16 Baronne Court

Greer, SC

5 BDs, 4 BAs

MLS: 1359999

Thornblade

Source: Greater Greenville Association of REALTORS®

Sharon Wilson - Wilson Associates

NEW

$1,250,000

4 Redgold Court

Greer, SC

6 BDs, 6 BAs

MLS: 1361295

Thornblade

Source: Greater Greenville Association of REALTORS®

Cy Bagheri - Carolina Moves, Llc

$1,200,000

2777 Brockman McCLimon Road

Greer, SC

4 BDs, 4 BAs

MLS: 1322823

 

Source: Greater Greenville Association of REALTORS®

Kathy Rogoff - Allen Tate Company - Greenvill

REDUCED

$1,200,000

650 Hammett Road

Greer, SC

4 BDs, 3 BAs

MLS: 1355321

 

Source: Greater Greenville Association of REALTORS®

Sheila Young - Re/Max Realty Professionals

$1,150,000

116 Chatsworth Road

Greer, SC

6 BDs, 5 BAs

MLS: 1353370

Chatsworth

Source: Greater Greenville Association of REALTORS®

Cy Bagheri - Carolina Moves, Llc

$975,000

5 Hermosa Court

Greer, SC

5 BDs, 5 BAs

MLS: 1360546

Thornblade

Source: Greater Greenville Association of REALTORS®

Charlotte Sarvis - That Realty Group

$894,900

403 Father Hugo Drive

Greer, SC

6 BDs, 4 BAs

MLS: 1353944

Thornblade

Source: Greater Greenville Association of REALTORS®

Janet Sandifer - That Realty Group

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
306 Thornblade Boulevard
Greer, SC 29650
2/15/18 1145000 Thornblade
109 Thornblade Boulevard
Greer, SC 29650
1/30/18 817400 Thornblade
213 Upper View Court
Greer, SC 29651
2/16/18 639900 Mountain View Valley
3902 Jordan Road
Greer, SC 29651
1/31/18 627777 None
1 LONDON Court
Greer, SC 29650
1/11/18 624900 Glen Abbey
1 Claymore Court
Greer, SC 29650
11/29/17 599900 Hammett Creek
484 S Bennetts Bridge Road
Greer, SC 29651
1/3/18 599900 Bennetts Crossing
4485 Skyland Drive
Greer, SC 29651
1/11/18 595000 None
28 Chestnut Springs Court
Greer, SC 29651
11/27/17 589900 Tuxedo Park
4435 Stokes Road
Greer, SC 29651
2/5/18 589900 None
305 Galeton Court
Greer, SC 29651
12/28/17 579000 Ledgestone
19 Riverbanks Court
Greer, SC 29651
12/18/17 565000 Mahaffey Plantation
205 Coleridge Lane
Greer, SC 29651
1/19/18 559000 Stonewood Manor
108 Meilland Drive
Greer, SC 29650
12/18/17 554650 Thornblade
213 Riverstone Way
Greer, SC 29651
2/9/18 550000 Mahaffey Plantation
317 Scarborough Drive
Greer, SC 29650
2/12/18 484900 Barrington Park
700 Ladykirk Lane
Greer, SC 29650
1/23/18 475000 Carisbrooke
208 Grandmont Court
Greer, SC 29650
12/20/17 475000 Charleston Walk
303 HAMMETT Road
Greer, SC 29650
1/23/18 460000 None
601 Scarborough Drive
Greer, SC 29650
12/15/17 449900 Barrington Park
576 Allenton Way
Greer, SC 29651
2/20/18 445500 Redcroft
613 Greywell Court
Greer, SC 29651
1/30/18 440644 Redcroft
1 JUNEBERRY Court
Greer, SC 29651
1/10/18 439950 Laurel Lake
413 Isaqueena Drive
Greer, SC 29651
12/29/17 435000 Jamestowne Estates
26 Yorkmont Way
Greer, SC 29651
1/11/18 433829 Redcroft

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.