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 (gilder creek farm) AND "idx_listings"."updated" > 2018-08-18 11:04:09.424960) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-9 of 9 Listings

NEW

$355,000

100 Red Rome Court

Simpsonville, SC

7 BDs, 4 BAs

MLS: 1374214

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Randal Longo - Isave Realty

REDUCED

$295,000

317 Stayman Court

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1373528

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Barry Venuto - Greenville Realty, Llc

CONTINGENCY CONTRACT

$269,900

301 Stayman Court

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1371690

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Sandra Palmer - Bhhs C Dan Joyner - Simp

CONTINGENCY CONTRACT

$263,499

27 Red Jonathan Court

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1369785

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Alan Swartzentruber - Re/Max Realty Professionals

CONTINGENCY CONTRACT

$249,900

509 Grimes Drive

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1369813

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Kathy Harris - Coldwell Banker Caine/Williams

$239,900

16 Red Jonathan Court

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1365936

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Deborah Guy - Allen Tate Company - Greer

$235,900

2 Red Jonathan Court

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1372218

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Wendy Carnes - Re/Max Results

REDUCED

$234,900

42 Smokehouse Drive

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1368207

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Janet Happy Bradshaw - Re/Max Moves Simpsonville

CONTINGENCY CONTRACT

$205,000

7 Crown Empire Court

Simpsonville, SC

3 BDs, 2 BAs

MLS: 1373497

Gilder Creek Farm

Source: Greater Greenville Association of REALTORS®

Corinne Nickell - Keller Williams Grv Upst

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.