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 (beacon hill) AND "idx_listings"."updated" > 2018-08-19 22:21:13.507860) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

CONTINGENCY CONTRACT

$659,000

219 New Castle Drive

Duncan, SC

4 BDs, 3 BAs

MLS: 1370403

Beacon Hill

Source: Greater Greenville Association of REALTORS®

Robert Ponce - The Ponce Realty Group, Llc

$589,000

222 New Castle Drive

Duncan, SC

5 BDs, 5 BAs

MLS: 1361207

Beacon Hill

Source: Greater Greenville Association of REALTORS®

Marcia Hersey - Allen Tate Company - Greer

REDUCED

$499,900

111 Beacon Hill Road

Duncan, SC

4 BDs, 3 BAs

MLS: 1367898

Beacon Hill

Source: Greater Greenville Association of REALTORS®

Keith Clark - The Buyer's Broker

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
151 Tupelo Drive
Greer, SC 29651
8/17/18 619900 Willow Creek
132 Stone Gate Drive
Duncan, SC 29334
6/13/18 484000 Stone Gate
145 Redcroft Drive
Greer, SC 29651
7/27/18 475000 Redcroft
126 Emily Drive
Moore, SC 29369
8/13/18 469000 Shallow Brook
806 Cranwell Court
Greer, SC 29651
8/3/18 459900 Redcroft
512 E Tara Lane
Duncan, SC 29334
7/31/18 449900 River Falls Plantation
1850 Lightwood Knot Road
Moore, SC 29369
7/19/18 449900 None
569 Allenton Way
Greer, SC 29651
7/23/18 440000 Redcroft
230 Watkins Farm Drive
Greer, SC 29651
7/9/18 439500 Watkins Farm
329 Old South Road
Duncan, SC 29334
6/26/18 435000 River Falls Plantation
116 Stone Gate Drive
Duncan, SC 29334
7/12/18 423900 None
551 Live Oak Court
Greer, SC 29651
8/10/18 419000 Willow Creek
110 Spyglass Court
Duncan, SC 29334
7/13/18 418000 River Falls Plantation
174 River Falls Drive
Duncan, SC 29334
6/25/18 405000 River Falls Plantation
121 Redcroft Drive
Greer, SC 29651
7/30/18 359900 Redcroft
369 Old South Road
Duncan, SC 29334
7/2/18 357900 River Falls Plantation
104 W Longfield Lane
Reidville, SC 29388
8/3/18 353627 Hanlon Knoll
759 Rose Penny Lane
Spartanburg, SC 29301
7/30/18 349990 Sunset Summits
217 Pine Links Drive
Duncan, SC 29334
8/15/18 340000 River Falls Plantation
377 Old South Road
Duncan, SC 29334
8/16/18 334900 River Falls Plantation
131 Berrys Pond Drive
Duncan, SC 29334
8/1/18 324900 The Shores
309 Bohannon Court
Reidville, SC 29388
7/16/18 316685 Hanlon Knoll
237 Holly Tree Circle
Duncan, SC 29334
6/14/18 300000 Holly Tree Estates - Duncan
248 Cumberland Drive
Moore, SC 29369
7/30/18 299900 Shenandoah
318 Bohannon Court
Reidville, SC 29388
7/30/18 280810 Hanlon Knoll

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.