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 (bridgestone) AND "idx_listings"."updated" > 2018-09-18 11:51:40.743667) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$159,900

124 Robin Ridge

Piedmont, South Carolina

3 BDs, 2 BAs

MLS: 20204001

Bridgestone

Source: Anderson / Seneca MLS

Randal Longo - I Save Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
12 Great Lawn Drive
Piedmont, SC 29673
9/4/18 689900 Rushton
128 Walnut Creek Way
Powdersville, SC 29611
7/31/18 532800 Birch River
124 Omega Lane
Piedmont, SC 29673-9783
7/6/18 492500 None
303 Rhetts Run
Easley, SC 29642
8/27/18 459900 Airy Springs
1016 Shoal Creek Way
Easley, SC 29642
8/27/18 444900 Airy Springs
304 Holborne Drive
Easley, SC 29642
7/30/18 409000 Kensington
114 Fathers Drive
Piedmont, SC 29673
8/29/18 399000 Acadia
7 Knob Creek Court
Easley, SC 29642
7/2/18 389000 Airy Springs
117 Kingsland Way
Piedmont, SC 29673
6/22/18 379900 None
109 Dartford Court
Easley, SC 29642
9/12/18 368900 Rose Hill
3 Dartford Court
Easley, SC 29642
8/31/18 334900 Rose Hill
100 Dartford Court
Easley, SC 29642
7/23/18 334900 Rose Hill
1216 White Road
Piedmont, SC 29673
7/20/18 330000 None
309 Sassafras Drive
Easley, SC 29642
8/17/18 330000 Hornbuckle
117 Armistead Lane
Easley, SC 29642
8/17/18 319700 Pendleton Plantation
134 Benton Park Drive
Powdersville, SC 29642
8/31/18 312000 Benton Park
608 B Blossom Branch Road
Piedmont, SC 29673
9/14/18 299900 None
108 Dartford Court
Easley, SC 29642
8/23/18 299900 Rose Hill
408 Planters Walk Drive
Easley, SC 29642
8/10/18 295000 Planters Walk
131 Deer Drive
Greenville, SC 29611
8/31/18 275271 Three Bridges
1039 Freshwater Lane
Easley, SC 29642
8/15/18 275000 Granite Springs
235 Sassafras Drive
Easley, SC 29642
7/31/18 274900 Hornbuckle
108 Berkley Drive
Easley, SC 29642-9313
9/7/18 274900 Hampton Downs
293 Sassafrass Drive
Easley, SC 29642
8/31/18 269900 Hornbuckle
103 Equestrian Trail
Easley, SC 29642
9/14/18 268000 Foxcreek

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.