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 (fieldstone) AND "idx_listings"."updated" > 2018-06-17 04:11:23.454295) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

CONTINGENCY CONTRACT

$204,900

38 CANTERA Circle

Greenville, SC

3 BDs, 2 BAs

MLS: 1368656

Fieldstone

Source: Greater Greenville Association of REALTORS®

Chet Smith - Bhhs C Dan Joyner - N. Pleas

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
109 Putney Bridge Lane
Simpsonville, SC 29681
6/12/18 1299000 Cobblestone
16 Baronne Court
Greer, SC 29650
6/8/18 1299000 Thornblade
614 Lancashire Court
Greenville, SC 29615
5/21/18 1225000 Blackstone
140 Rocky Point Circle
Greenville, SC 29615
3/26/18 974900 Rocky Creek Acres
14 Ramsford Lane
Simpsonville, SC 29681
4/27/18 930000 Cobblestone
24 White Crescent Lane
Simpsonville, SC 29681
4/26/18 930000 Kingsbridge
14 Baronne Court
Greer, SC 29650
5/11/18 899900 Thornblade
11 Babbs Hollow
Greenville, SC 29607
6/15/18 834900 Collins Creek
8 Ruffian Way
Greenville, SC 29615
6/15/18 825000 Spaulding Farm
2 Peters Creek Court
Simpsonville, SC 29681
4/30/18 815000 Kilgore Plantation
101 Babbs Hollow
Greenville, SC 29607
5/14/18 814799 Collins Creek
10 Mitchell Spring Court
Simpsonville, SC 29681
4/27/18 800000 Kingsbridge
18 Norman Place
Greenville, SC 29615
4/30/18 799000 Stonebrook Farm
2 Saint Helaine Place
Greer, SC 29650
5/17/18 779000 Barrington Park
136 Ramsford Lane
Simpsonville, SC 29681
5/11/18 759500 Cobblestone
105 Antigua Way
Greer, SC 29650
3/29/18 749000 Thornblade
7 Finsbury Lane
Simpsonville, SC 29681
6/13/18 744900 Cobblestone
26 Gatwick Lane
Simpsonville, SC 29681
6/12/18 719000 Cobblestone
104 Griffith Hill Way
Greer, SC 29651
6/15/18 714900 Griffith Farm
205 Belfrey Drive
Greer, SC 29650
4/16/18 709900 Barrington Park
207 Chelsea Lane
Greer, SC 29650-3262
6/8/18 709000 Chelsea Woods
109 Joseph Fletcher Way
Simpsonville, SC 29681
4/20/18 699900 Maxwell Farm
204 Buckland Way
Greenville, SC 29615
3/30/18 699900 Spaulding Farm
1 Hunters Run
Greenville, SC 29615
4/30/18 699000 Spaulding Farm
108 Charleston Oak Lane
Greenville, SC 29615
5/29/18 690000 The Oaks at Roper Mountain

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.