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 (1200 pelham) AND "idx_listings"."updated" > 2018-10-13 05:59:57.735143) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$314,900

1273 Shadow Way

Greenville, SC

3 BDs, 3 BAs

MLS: 1376768

1200 Pelham

Source: Greater Greenville Association of REALTORS®

Carol Pyfrom - Carol Pyfrom Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
28 Fontaine Road
Greenville, SC 29607
8/6/18 995000 Parkins Mill
21 Collins Creek Road
Greenville, SC 29607
9/5/18 899670 Collins Creek
26 E Earle Street
Greenville, SC 29609
8/24/18 883000 North Main
2395 Roper Mountain Road
Simpsonville, SC 29681
8/17/18 875000 Deerland Plantation
47 Rolleston Drive
Greenville, SC 29615
9/28/18 839000 Claremont - Greenville
1 Hermosa Court
Greer, SC 29650
8/10/18 799860 Thornblade
1107 N Main Street
Greenville, SC 29609
10/10/18 795000 North Main
225 Glen Abbey Way
Greer, SC 29650
7/27/18 769900 Glen Abbey
13 Gallivan Street
Greenville, SC 29609
10/5/18 769000 None
108 Fernwood Lane
Greenville, SC 29607
7/30/18 750000 Cleveland Forest
174 Marshall Bridge Drive
Greenville, SC 29605
8/27/18 750000 Brookside Forest
100 Asheton Way
Simpsonville, SC 29681
9/24/18 729500 Asheton
111 Woodland Way
Greenville, SC 29601
8/29/18 729000 Boxwood Manor
44 Ruskin Square
Greenville, SC 29607
7/18/18 725000 Hollingsworth Park
11 Azalea Spring Court
Greenville, SC 29615
8/24/18 689000 Azalea Springs
312 Joseph Fletcher Way
Simpsonville, SC 29681
8/2/18 659900 Maxwell Farm
15 Partridge Lane
Greenville, SC 29601
9/20/18 650000 Alta Vista
16 Country Squire Court
Greenville, SC 29615
7/30/18 649900 Roper At Pelham
8 Hawkins Road
Greenville, SC 29615
7/31/18 649500 None
14 Babbs Hollow
Greenville, SC 29607
7/24/18 649000 Collins Creek
55 Chisolm Trail
Greenville, SC 29607
7/24/18 639000 Parkins Mill Area
1124 Wembley Road
Greenville, SC 29607
8/24/18 624900 Gower Estates
315 Block House Road
Greenville, SC 29615
9/28/18 615000 Spaulding Farm
10 Triple Crown Court
Greenville, SC 29615
9/28/18 605000 Spaulding Farm
524 Spaulding Lake Drive
Greenville, SC 29615
8/17/18 595000 Spaulding Farm

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.