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 (kingsfield) AND "idx_listings"."updated" > 2018-07-13 20:52:05.844624) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

$273,300

2 Kingsfield Place

Piedmont, SC

4 BDs, 2 BAs

MLS: 1360159

Kingsfield

Source: Greater Greenville Association of REALTORS®

Stan McAlister - Mcalister Realty

$259,000

9 Kingsfield Place

Piedmont, SC

3 BDs, 2 BAs

MLS: 1360161

Kingsfield

Source: Greater Greenville Association of REALTORS®

Stan McAlister - Mcalister Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
303 Crescent Avenue
Greenville, SC 29605
5/3/18 1195000 Alta Vista
9 Argonne Drive
Greenville, SC 29605
4/17/18 989000 Augusta Road
282 Rockwood Drive
Greenville, SC 29605
5/15/18 875000 Augusta Road
9 Mount Vere Drive
Greenville, SC 29607
6/28/18 849500 Parkins Mill
1809 Cleveland Street Extension
Greenville, SC 29607
6/27/18 825000 Parkins Mill Area
1306 Augusta Street
Greenville, SC 29605
6/13/18 795000 None
16 W Tallulah Drive
Greenville, SC 29605
5/18/18 795000 Augusta Road
1 Petiver Lane
Greenville, SC 29605
7/12/18 775000 Chanticleer
102 Brookview Circle
Greenville, SC 29605
7/12/18 749900 Augusta Road
7A Meyers Drive
Greenville, SC 29605
5/3/18 749000 Augusta Road
11 OakView Drive
Greenville, SC 29605
6/4/18 729000 Augusta Road
13 Thornwood Lane
Greenville, SC 29605
5/17/18 724605 Chanticleer
318 Jones Avenue
Greenville, SC 29605-2824
6/1/18 724500 Alta Vista
208 Hidden Hills Drive
Greenville, SC 29605
6/18/18 715000 Chanticleer
471 E Parkins Mill Road
Greenville, SC 29607
7/9/18 699900 Quail Hill
32 Waccamaw Circle
Greenville, SC 29605
4/24/18 678999 Augusta Road
326 Riverside Drive
Greenville, SC 29605
7/9/18 669900 Greenville Country Club
200 Waccamaw Avenue
Greenville, SC 29605
5/9/18 669605 Augusta Road
192 Chapman Road
Greenville, SC 29605
4/19/18 650000 Chanticleer
204 Brookside Way
Greenville, SC 29605
5/7/18 650000 Augusta Road
401 Jones Avenue
Greenville, SC 29605
7/11/18 650000 Alta Vista
37 Douglas Drive
Greenville, SC 29605
4/30/18 649000 Augusta Road
14 Hunley Lane
Greenville, SC 29605
4/12/18 649000 Augusta Road
107 Sylvan Way
Greenville, SC 29605
6/1/18 604605 Greenville Country Club
214 Aberdeen Drive
Greenville, SC 29605
6/15/18 575000 Augusta Road

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.