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 (bagwell farms) AND "idx_listings"."updated" > 2018-08-17 00:10:26.910048) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

$406,950

107 Clara Smith

Piedmont, South Carolina

4 BDs, 3 BAs

MLS: 20203385

Bagwell Farms

Source: Anderson / Seneca MLS

Linda Horner - Keller Williams Easley/Powd

REDUCED

$396,950

107 Clara Smith Lane

Piedmont, SC

4 BDs, 3 BAs

MLS: 1368320

Bagwell Farms

Source: Greater Greenville Association of REALTORS®

Linda Horner - Keller Williams Easley/Powd

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
1000 Campbell Road
Piedmont, SC 29669
8/15/18 949900 None
105 Chestnut Springs Way
Williamston, SC 29697
7/27/18 699200 Chestnut Springs
104 Farm Terrace Court
Easley, SC 29642
6/26/18 699000 The Farm I
1106 Stratford Court
Easley, SC 29642
6/28/18 600000 None
108 Chickasaw Run
Williamston, SC 29697
6/14/18 569900 Other
124 Omega Lane
Piedmont, SC 29673-9783
7/6/18 492500 None
3553 Pelzer Highway
Easley, SC 29642
6/27/18 485000 Farm II
156 Burberry Drive
Williamston, SC 29697
7/24/18 399900 Ridgewood Plantation
7 Knob Creek Court
Easley, SC 29642
7/2/18 389000 Airy Springs
117 Kingsland Way
Piedmont, SC 29673
6/22/18 379900 None
1006 Shiloh Circle
Easley, SC 29642
6/28/18 379900 None
115 Hunting Meadow Drive
Williamston, SC 29697
5/31/18 360000 Other
229 W Church Road
Easley, SC 29642
7/16/18 341999 None
22 Olivia Court
Pelzer, SC 29669
7/30/18 340900 The Farms at Spearman Road
100 Dartford Court
Easley, SC 29642
7/23/18 334900 Rose Hill
155 Wild Hickory Circle
Easley, SC 29642
7/17/18 332900 Enclave at Airy Springs
124 Wild Hickory Circle
Easley, SC 29642
7/11/18 324900 Enclave at Airy Springs
101 Jordan Close
Easley, SC 29642
8/17/18 320000 Lee Ridge
117 Armistead Lane
Easley, SC 29642
8/17/18 319700 Pendleton Plantation
110 Fairoaks Drive
Williamston, SC 29697
7/27/18 316900 Wyatts Grant
14 Nickel Springs Drive
Easley, SC 29642
6/13/18 314900 Avendell
106 Clearstone Drive
Easley, SC 29642
7/30/18 299900 Other
2 Duxbury Lane
Easley, SC 29642
7/20/18 299900 Rose Hill
408 Planters Walk Drive
Easley, SC 29642
8/10/18 295000 Planters Walk
1009 Trescott Lane
Easley, SC 29642
6/28/18 276900 Pendleton Plantation 054

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.