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 (UPPER("idx_listings"."address"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."city"::text) LIKE UPPER(%greenville%) OR "idx_listings"."city" IN (greenville) OR UPPER("idx_listings"."zipcode"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."subdivision"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."elementary_school"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."middle_school"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."high_school"::text) LIKE UPPER(%greenville%) OR UPPER("idx_listings"."county"::text) LIKE UPPER(%greenville%)) AND "idx_listings"."updated" > 2018-10-19 13:55:02.020788) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 137 Listings

$2,999,999

45 Falling Star

Landrum, South Carolina

4 BDs, 4 BAs

MLS: 20190243

Cliffs At Glassy

Source: Anderson / Seneca MLS

John Kent - Blackstream International Re

REDUCED

$1,715,000

133 Shore Vista

Greer, South Carolina

5 BDs

MLS: 20203766

Other

Source: Anderson / Seneca MLS

Jill Chapman - Bhhs C Dan Joyner - Greer

$1,498,000

5 Redgold

Greer, South Carolina

5 BDs, 4 BAs

MLS: 20206062

Thornblade

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

REDUCED

$1,295,000

136 High Rock Ridge

Landrum, South Carolina

4 BDs, 5 BAs

MLS: 20190245

Cliffs At Glassy

Source: Anderson / Seneca MLS

John Kent - Blackstream International Re

$1,199,000

308 Sorono

Greenville, South Carolina

4 BDs, 5 BAs

MLS: 20206065

Monte Vista

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

REDUCED

$1,100,000

4 Grouse

Landrum, South Carolina

4 BDs, 4 BAs

MLS: 20190241

Cliffs At Glassy

Source: Anderson / Seneca MLS

John Kent - Blackstream International Re

$949,000

309 W Faris

Greenville, South Carolina

5 BDs, 5 BAs

MLS: 20204179

 

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

$949,000

309 W Faris

Greenville, South Carolina

5 BDs, 5 BAs

MLS: 20206049

 

Source: Anderson / Seneca MLS

Sharon Wilson - Wilson Associates

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
154 Riverplace Drive
Greenville, SC 29601
8/23/18 1629601 River House Condos
212 Stonebrook Farm Way
Greenville, SC 29615
10/19/18 1099000 Stonebrook Farm
208 Sunset Drive
Greenville, SC 29605
8/17/18 1047000 None
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
201 Riverplace Way
Greenville, SC 29601
9/21/18 897000 Terrace at RiverPlace
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
174 Marshall Bridge Drive
Greenville, SC 29605
8/27/18 750000 Brookside Forest
108 Fernwood Lane
Greenville, SC 29607
7/30/18 750000 Cleveland Forest
100 Asheton Way
Simpsonville, SC 29681
9/24/18 729500 Asheton
111 Woodland Way
Greenville, SC 29601
8/29/18 729000 Boxwood Manor
121 Rhett Street
Greenville, SC 29601
9/20/18 724900 121 Rhett Street
108 Augusta Court
Greenville, SC 29605
9/28/18 719605 Augusta Road
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
25 Highland Drive
Greenville, SC 29605
8/16/18 650000 Augusta Road
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

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.