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

1-1 of 1 Listings

$749,900

504 Piedmont Gold Course Road

Piedmont, SC

6 BDs, 5 BAs

MLS: 1356919

Beechwood Farms

Source: Greater Greenville Association of REALTORS®

David Miller - Unique Real Estate, Llc

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
2725 W Georgia Road
Piedmont, SC 29673
7/16/18 344900 None
409 Woodson Road
Piedmont, SC 29673
5/21/18 344900 Woodson Lake
1216 White Road
Piedmont, SC 29673
7/20/18 330000 None
7 Flintlock Court
Piedmont, SC 29673
6/16/18 315000 Garrison Woods
100 Arbor Woods Lane
Piedmont, SC 29673
8/3/18 262691 Arbor Woods
6 Taiga Court
Piedmont, SC 29673
7/25/18 254395 The Farm at Sandy Springs
5 ONeal Farms Way
Piedmont, SC 29673
8/3/18 252550 ONeal Farms
205 Tar Boulevard
Greenville, SC 29605
5/31/18 239500 Tar Acres
106 Wimberly Court
Piedmont, SC 29673-6310
7/9/18 220000 Blythwood
108 Josie Creek Drive
Piedmont, SC 29673
8/10/18 215000 Josie Creek
725 Streamside Drive
Piedmont, SC 29673
6/28/18 214780 Willow Grove
600 Heathridge Lane
Piedmont, SC 29673
7/16/18 212990 Willow Grove
111 Triple Creek Drive
Piedmont, SC 29673
7/19/18 204160 Triple Creek
715 Streamside Drive
Piedmont, SC 29673
7/31/18 201990 Willow Grove
716 Streamside Drive
Piedmont, SC 29673
6/27/18 200990 Willow Grove
312 Millridge Road
Piedmont, SC 29673
6/29/18 200990 Triple Creek
175 Pendock Lane
Piedmont, SC 29673
8/13/18 200000 The Farm at Sandy Springs
602 Saluda Drive
Piedmont, SC 29673-8384
7/30/18 199900 None
49 Brockmore Drive
Greenville, SC 29605
6/22/18 199900 Woods at Bonnie Brae
307 Ridgebrook Way
Greenville, SC 29605
6/29/18 199900 River Mist
127 Birkhall Circle
Greenville, SC 29605
5/31/18 195000 Linkside at Bonnie Brae
147 Birkhall Circle
Greenville, SC 29605-5952
6/11/18 194000 Linkside at Bonnie Brae
727 Streamside Drive
Piedmont, SC 29673
6/29/18 189990 Willow Grove

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.