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-06-16 11:28:22.369815) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

NEW

$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
109 ACADIA Avenue
Piedmont, SC 29673
5/31/18 549500 Acadia
104 Brookside Lane
Piedmont, SC 29673
6/15/18 449000 Other
1032 Westbrooke Lane
Easley, SC 29642
3/30/18 440000 Kensington
5 Firelight Lane
Easley, SC 29642
4/2/18 440000 Lantern Ridge
128 Lantern Ridge Drive
Easley, SC 29642
3/30/18 439900 Lantern Ridge
111 Fathers Drive
Piedmont, SC 29673
4/23/18 409900 Acadia
102 Clara Smith Lane
Piedmont, SC 29673
5/2/18 402960 Bagwell Farms
271 OLD RIVER Road
Pelzer, SC 29669
4/10/18 399000 None
1012 Westbrooke Lane
Easley, SC 29642
5/3/18 396500 Kensington
105 Birch Meadow Drive
Piedmont, SC 29673
5/31/18 389000 Birch Meadow
123 Walnut Creek Way
Greenville, SC 29611
4/11/18 385000 Birch River
202 Wren School Road
Piedmont, SC 29673
5/18/18 374900 None
115 Cravens Creek Court
Piedmont, SC 29673
5/18/18 369900 Craven's Creek
1003 Shoal Creek Way
Easley, SC 29642
4/26/18 365750 Airy Springs
1035 Westbrooke Lane
Easley, SC 29642
5/8/18 355000 Kensington
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
104 Jackson Parc Court
Greenville, SC 29607
5/31/18 309900 Belhaven Parc
122 Guilford Drive
Easley, SC 29642
5/7/18 299900 Pendleton Plantation 054
119 Spring Hill Farm Road
Piedmont, SC 29673
5/23/18 299500 Spring Hill Farm
220 Piedmont Golf Course Road
Piedmont, SC 29673
5/2/18 295000 None
297 SASSAFRAS Drive
Easley, SC 29642
5/25/18 267900 Hornbuckle
101 Quail Court
Piedmont, SC 29673
4/13/18 259000 Prestwick
284 Sassafras Drive
Easley, SC 29642
4/20/18 250000 Hornbuckle

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.