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-10-13 05:54:35.752859) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 500 Listings

REDUCED

$2,125,000

103 Tuscany Way

Greer, SC

6 BDs, 5 BAs

MLS: 1368995

Thornblade

Source: Greater Greenville Association of REALTORS®

Tom Marchant - Marchant Company, The

REDUCED

$1,715,000

133 Shore Vista

Greer, South Carolina

5 BDs

MLS: 20203766

Other

Source: Anderson / Seneca MLS

Jill Chapman - Bhhs C Dan Joyner - Greer

REDUCED

$1,715,000

133 Shore Vista Lane

Greer, SC

5 BDs, 6 BAs

MLS: 1369863

Pennington Pointe

Source: Greater Greenville Association of REALTORS®

Jill Chapman - Bhhs C Dan Joyner - Greer

$1,498,000

5 Redgold Court

Greer, SC

5 BDs, 4 BAs

MLS: 1366267

Thornblade

Source: Greater Greenville Association of REALTORS®

Sharon Wilson - Wilson Associates

$1,498,000

5 Redgold

Greer, South Carolina

5 BDs, 4 BAs

MLS: 20206062

Thornblade

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

$1,289,650

7 Riley Hill Court

Greer, SC

6 BDs, 6 BAs

MLS: 1375293

Greywood At Hammett

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

$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

CONTINGENCY CONTRACT

$1,150,000

2152 Fews Chapel Road

Greer, SC

4 BDs, 2 BAs

MLS: 1369588

 

Source: Greater Greenville Association of REALTORS®

Randal Longo - Isave Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
1 Hermosa Court
Greer, SC 29650
8/10/18 799860 Thornblade
225 Glen Abbey Way
Greer, SC 29650
7/27/18 769900 Glen Abbey
201 Terra Woods Lane
Greenville, SC 29615
8/6/18 585000 Terra Woods
6 Claymore Court
Greer, SC 29650
8/10/18 575000 Hammett Creek
109 Royal Troon Court
Greer, SC 29650
10/5/18 525000 Barrington Park
103 Rapid River Trail
Greenville, SC 29615
8/20/18 509900 Riverview
200 Grandmont Court
Greer, SC 29650
8/30/18 485000 Charleston Walk
4 Craigmillar Place
Greer, SC 29650
8/13/18 479000 Carisbrooke
145 Redcroft Drive
Greer, SC 29651
7/27/18 475000 Redcroft
1977 Locust Hill Road
Greer, SC 29651
7/23/18 460000 None
26 Steadman Way
Greer, SC 29650
9/14/18 449900 Brighton
326 Rock Road
Greer, SC 29651
7/23/18 440000 Other
2 Steadman Way
Greer, SC 29650
10/5/18 435000 Brighton
101 Silver Pine Court
Greer, SC 29650
7/31/18 425000 Sugar Creek
1018 Bent Creek Run Drive
Greer, SC 29651
8/17/18 424900 Spring Hill
322 S Wingfield Road
Greer, SC 29650
9/6/18 424900 Sugar Creek
547 Forest Court
Greer, SC 29651
8/17/18 424900 None
148 BURLWOOD Drive
Greer, SC 29651
7/30/18 419000 Mount Vernon Estates
211 Hammetts Glen Way
Greer, SC 29650
8/24/18 414900 Hammetts Glen
1 Wildlife Trail
Greer, SC 29650
9/18/18 399000 River Oaks
106 Sugar Creek Road
Greer, SC 29650
9/28/18 399000 Sugar Creek
4 Kirkpatrick Court
Greer, SC 29650
9/7/18 398000 Carisbrooke
107 Dartmoor Drive
Greer, SC 29650
9/24/18 395000 River Downs
369 Harkins Bluff Drive
Greer, SC 29651
10/1/18 385000 Dillard Creek Crossing
101 Old Province Way
Greer, SC 29650
8/10/18 380900 Grove Park

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.