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-04-23 17:49:44.235425) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 500 Listings

$7,500,605

100 Chapman Place

Greenville, SC

5 BDs, 6 BAs

MLS: 1341916

Augusta Road

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

$3,500,000

106 Peaceful Night

Travelers Rest, South Carolina

 

MLS: 20200314

Cliffs At Valley

Source: Anderson / Seneca MLS

Jeremy Russell - Re/Max Realty Professionals

$3,500,000

22 Bennett Street

Greenville, SC

6 BDs, 7 BAs

MLS: 1347737

 

Source: Greater Greenville Association of REALTORS®

Jacob Mann - Coldwell Banker Caine Co.

$3,500,000

106 Peaceful Night Trail

Travelers Rest, SC

6 BDs, 7 BAs

MLS: 1362327

Cliffs Valley

Source: Greater Greenville Association of REALTORS®

Jeremy Russell - Re/Max Realty Professionals

$2,999,999

45 Falling Star Way

Landrum, SC

4 BDs, 4 BAs

MLS: 1346484

The Cliffs At Glassy

Source: Greater Greenville Association of REALTORS®

Clark Kent - Blackstream International Re

$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

NEW

$2,950,000

10 High Bluff Court

Travelers Rest, SC

5 BDs, 5 BAs

MLS: 1365956

Cliffs Valley

Source: Greater Greenville Association of REALTORS®

Robby Brady - Allen Tate Company - Greenvill

REDUCED

$2,695,000

16 High Bluff Court

Travelers Rest, SC

6 BDs, 6 BAs

MLS: 1247202

Cliffs Valley

Source: Greater Greenville Association of REALTORS®

LuAnn Loeber - Cliffs Realty Sales Sc, Llc

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
18 Sirrine Drive
Greenville, SC 29605
4/20/18 1695000 Greenville Country Club
109 Sherwood Street
Greenville, SC 29601
3/26/18 1690000 Alta Vista
120 Sorrento Drive
Greenville, SC 29609
1/26/18 1400000 Montebello
4007 State Park Road
Greenville, SC 29609
3/30/18 1150000 Paris Mt Area
203 Hope Street
Greenville, SC 29601
2/14/18 1149000 Downtown
306 Thornblade Boulevard
Greer, SC 29650
2/15/18 1145000 Thornblade
12 Lawson Way
Greenville, SC 29605
4/2/18 1135605 Chanticleer
9 Argonne Drive
Greenville, SC 29605
4/17/18 989000 Augusta Road
140 Rocky Point Circle
Greenville, SC 29615
3/26/18 974900 Rocky Creek Acres
329 Sorono Drive
Greenville, SC 29609
3/2/18 895000 Montebello
811 Butter Street
Landrum, SC 29356
4/20/18 870000 None
112 Deep Haven Lane
Landrum, SC 29356
3/23/18 850000 The Cliffs at Glassy
111 Mount Vista Avenue
Greenville, SC 29605-1120
4/13/18 849950 Augusta Road
732 Brixton Circle
Simpsonville, SC 29681
2/28/18 835000 Cobblestone
112 Westminster Drive
Greenville, SC 29605
4/16/18 827900 Augusta Road
333 Riverside Drive
Greenville, SC 29605
1/31/18 825000 Augusta Road
140 Ramsford Lane
Simpsonville, SC 29681
1/29/18 819900 Cobblestone
109 Thornblade Boulevard
Greer, SC 29650
1/30/18 817400 Thornblade
169 Chapman Road
Greenville, SC 29605
2/28/18 809000 Chanticleer
104 Bamber Green Court
Greenville, SC 29615
3/16/18 799000 Blackstone
17 Landsdown Avenue
Greenville, SC 29601
2/14/18 798500 Cleveland Place
120 Woodland Way
Greenville, SC 29601
3/21/18 794000 Cleveland Forest
120 Tindal Avenue
Greenville, SC 29605
4/4/18 789900 Alta Vista
23 Rolleston Drive
Greenville, SC 29615
4/4/18 779500 Claremont - Greenville
121 Tindal Avenue
Greenville, SC 29605
4/11/18 765000 Alta Vista

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.