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 (clairmont estates) AND "idx_listings"."updated" > 2018-08-20 03:40:44.021612) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 15 Listings

CONTINGENCY CONTRACT

$220,990

563 Falls Cottage Run

Boiling Springs, SC

5 BDs, 2 BAs

MLS: 1364290

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

$215,990

558 Falls Cottage Run

Boiling Springs, SC

4 BDs, 2 BAs

MLS: 1373003

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

REDUCED

$204,990

566 Falls Cottage Run

Boiling Springs, SC

3 BDs, 2 BAs

MLS: 1372997

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

REDUCED

$204,900

527 Falls Cottage Run

Boiling Springs, SC

4 BDs, 2 BAs

MLS: 1359106

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

$200,990

562 Falls Cottage Run

Boiling Springs, SC

4 BDs, 2 BAs

MLS: 1373002

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

CONTINGENCY CONTRACT

$199,900

308 New Springs Lane

Boiling Springs, SC

5 BDs, 2 BAs

MLS: 1364086

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

REDUCED

$199,900

550 Falls Cottage Run

Boiling Springs, SC

4 BDs, 2 BAs

MLS: 1365678

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

REDUCED

$198,990

523 Falls Cottage Run

Boiling Springs, SC

4 BDs, 2 BAs

MLS: 1371580

Clairmont Estates

Source: Greater Greenville Association of REALTORS®

Tammy Peluso - D.R. Horton

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
415 Lions Paw Court
Inman, SC 29349-5915
6/1/18 549900 Woodfin Ridge
735 E Long Bay Drive
Inman, SC 29349
5/30/18 529000 Woodfin Ridge
1630 Sugar Ridge Road
Boiling Springs, SC 29316
5/30/18 479900 Other
311 Burro Court
Boiling Springs, SC 29316
7/31/18 419900 Other
124 Bay Tree Court
Inman, SC 29349
7/3/18 409900 Woodfin Ridge
105 MonReve Drive
Boiling Springs, SC 29316
6/14/18 399900 MonReve Village
224 Tuscan Ridge Trail
Inman, SC 29349
8/12/18 399000 Woodfin Ridge
826 E Heathland Drive
Inman, SC 29347
7/20/18 368900 Woodfin Ridge
355 Island Green Lane
Inman, SC 29349
6/1/18 354900 Other
210 Clearcreek Drive
Boiling Springs, SC 29316
7/25/18 349900 Turtle Creek
630 Ship Wreck Place
Inman, SC 29349
8/17/18 345900 Lake Emory
505 Wicked Stick Court
Inman, SC 29349
8/20/18 329900 Woodfin Ridge
777 Ashmont Lane
Boiling Springs, SC 29316
7/20/18 309990 Sterling Estate
208 Corie Fields Court
Boiling Springs, SC 29316
7/27/18 285000 Other
504 Planters Rest Lane
Inman, SC 29349
8/9/18 284900 Sugar Ridge
513 Wicked Stick Court
Inman, SC 29349
8/14/18 284900 Woodfin Ridge
235 Coburg Court
Boiling Springs, SC 29316
6/27/18 273900 Sterling Estate
120 Ridgeville Church Road
Inman, SC 29349
8/17/18 264900 Other
408 Hunting Crest Court
Boiling Springs, SC 29316-5940
8/3/18 260000 Carlisle Place
204 Lakewinds Boulevard
Inman, SC 29349
7/13/18 259900 Other
235 Castleton Circle
Boiling Springs, SC 29316
5/31/18 240744 Cobbs Creek
223 Slate Drive
Boiling Springs, SC 29316
7/13/18 237579 Hanging Rock
174 Victoria Drive
Inman, SC 29349
8/6/18 224900 Other
139 Bay Hill Drive
Boiling Springs, SC 29316
8/3/18 222900 Other
655 Ridgeville Crossing Drive
Inman, SC 29349
8/7/18 221804 Ridgeville Crossing

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.