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-05-25 01:06:39.939069) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 14 Listings

REDUCED

$795,000

130 Beechwood

Greer, South Carolina

4 BAs

MLS: 20185837

 

Source: Anderson / Seneca MLS

Joseph Cann - Cann Realty, Llc

REDUCED

$744,900

29 Griffith Knoll

Greer, South Carolina

5 BDs, 4 BAs

MLS: 20202707

Other

Source: Anderson / Seneca MLS

Milton Shockley - Re/Max Realty Professionals

REDUCED

$575,000

6 Claymore

Greer, South Carolina

5 BDs, 4 BAs

MLS: 20191921

Other

Source: Anderson / Seneca MLS

Carolyn Pyfrom - Carol Pyfrom Realty

REDUCED

$439,900

15 Hunters Landing

Greer, South Carolina

4 BDs, 3 BAs

MLS: 20192212

Other

Source: Anderson / Seneca MLS

Matt Smith - Profound Real Estate

REDUCED

$299,000

527 Mahaffey

Greer, South Carolina

3 BDs, 2 BAs

MLS: 20202116

 

Source: Anderson / Seneca MLS

Ciro Piccirillo - Jw Martin Real Estate

PENDING

$295,000

2361 Country Club

Greer, South Carolina

5 BDs, 2 BAs

MLS: 20191553

 

Source: Anderson / Seneca MLS

Victor Amadi - Producer Realty Llc

$276,000

104 W GREER

Honea Path, South Carolina

3 BDs, 2 BAs

MLS: 20201212

 

Source: Anderson / Seneca MLS

David Phillips - Silver Star Real Estate

PENDING

$200,000

3809 Pennington

Greer, South Carolina

3 BDs, 2 BAs

MLS: 20196388

 

Source: Anderson / Seneca MLS

April Hendricks - Keller Williams Easley/Powd

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
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
31 Fox Hunt Lane
Greer, SC 29651
3/19/18 699000 Fox Creek Farm
144 Griffith Hill Way
Greer, SC 29651
3/1/18 685000 Griffith Farm
1286 N Highway 101
Greer, SC 29651
5/25/18 674900 None
1400 Thornblade Boulevard
Greer, SC 29650
2/28/18 614900 Villas at Thornblade
19 Griffith Hill Way
Greer, SC 29651
4/27/18 610000 Griffith Farm
301 Galeton Court
Greer, SC 29651
3/28/18 579000 Ledgestone
300 Windsor Road
Greer, SC 29651
4/27/18 559000 Belmont Heights
267 Tuxedo Lane
Greer, SC 29651
5/22/18 555057 Tuxedo Park
160 Riverstone Way
Greer, SC 29651
3/22/18 549900 Mahaffey Plantation
216 Riverstone Way
Greer, SC 29651
3/29/18 545000 Mahaffey Plantation
15 Meadow Trace Court
Greer, SC 29651
3/27/18 524900 Pennington Pointe
28 Dusty Oak Lane
Greer, SC 29651
3/15/18 500000 None
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
364 CREPE MYRTLE Drive
Greer, SC 29651
3/7/18 499900 Willow Creek
1045 Owens Road
Greer, SC 29651
4/27/18 495000 None
379 Crepe Myrtle Drive
Greer, SC 29651
5/15/18 473600 Willow Creek
1 Penny Meadow Court
Greer, SC 29650
4/12/18 458500 River Oaks
4026 Pennington Road
Greer, SC 29651-4923
4/16/18 449900 None
1403 Beverly Road
Greer, SC 29651
4/20/18 449000 Cameron Woods

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.