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 (heritage estate) AND "idx_listings"."updated" > 2018-06-17 04:26:27.286106) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

REDUCED

$435,000

108 Heritage

Pickens, South Carolina

3 BDs, 2 BAs

MLS: 20194655

Heritage Estate

Source: Anderson / Seneca MLS

Megan Dockery - Thomas Realty

REDUCED

$435,000

108 Heritage Drive

Pickens, SC

3 BDs, 2 BAs

MLS: 1357778

Heritage Estate

Source: Greater Greenville Association of REALTORS®

Megan Thomas - Thomas Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
109 ACADIA Avenue
Piedmont, SC 29673
5/31/18 549500 Acadia
104 Brookside Lane
Piedmont, SC 29673
6/15/18 449000 Other
111 Fathers Drive
Piedmont, SC 29673
4/23/18 409900 Acadia
271 OLD RIVER Road
Pelzer, SC 29669
4/10/18 399000 None
202 Wren School Road
Piedmont, SC 29673
5/18/18 374900 None
505 Tripp Street
Williamston, SC 29697
6/6/18 370000 None
409 Woodson Road
Piedmont, SC 29673
5/21/18 344900 Woodson Lake
710 Osteen Hill Road
Piedmont, SC 29673
4/13/18 339900 None
411 Graystone Drive
Piedmont, SC 29673
3/23/18 325000 None
178 Pendock Lane
Piedmont, SC 29673
3/23/18 315000 The Farm at Sandy Springs
113 Stone Drive
Pelzer, SC 29669
4/30/18 299900 None
220 Piedmont Golf Course Road
Piedmont, SC 29673
5/2/18 295000 None
200 Holland Ford Road
Pelzer, SC 29669
6/8/18 264900 None
703 Shaded Acre Court
Pelzer, SC 29669
3/29/18 259900 Forest Oaks
101 Quail Court
Piedmont, SC 29673
4/13/18 259000 Prestwick
181 Largess Lane
Piedmont, SC 29673
4/24/18 250000 The Farm at Sandy Springs
122 Robinwood Lane
Pelzer, SC 29669
5/14/18 249900 Robinwood
114 Mountain Lake Drive
Piedmont, SC 29673
4/13/18 248900 Mount Vernon Estates
201 Bonanza Circle
Piedmont, SC 29673
4/27/18 235000 Ponderosa
200 Ramblewood Drive
Piedmont, SC 29673
6/12/18 219900 Ramblewood
729 Streamside Drive
Piedmont, SC 29673
4/30/18 201140 Willow Grove
112 Largess Lane
Piedmont, SC 29673
5/30/18 200000 The Farm at Sandy Springs
308 Huddersfield Drive
Piedmont, SC 29673
3/26/18 200000 The Summit
1700 River Road
Piedmont, SC 29679
5/16/18 199900 Bentwood III
137 Robinwood Lane
Pelzer, SC 29669
5/30/18 199900 Robinwood

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.