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" 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-01-18 00:27:18.987379) 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,800,000

106 Peaceful Night Trail

Travelers Rest, SC

6 BDs, 7 BAs

MLS: 1349564

Cliffs Valley

Source: Greater Greenville Association of REALTORS®

LuAnn Loeber - Cliffs Realty Sales Sc, Llc

$3,500,000

12 Kings Grant Way

Simpsonville, SC

5 BDs, 6 BAs

MLS: 1331216

Kilgore Plantation

Source: Greater Greenville Association of REALTORS®

Linda O'Brien - Wilson Associates

$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.

$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

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

$2,500,000

119 N Main Street

Greenville, SC

3 BDs, 3 BAs

MLS: 1357326

Downtown

Source: Greater Greenville Association of REALTORS®

Philip Whisnant - Realserv Residential, Llc

REDUCED

$2,150,000

124 chamberlain Court

Greenville, SC

5 BDs, 6 BAs

MLS: 1302581

Chanticleer

Source: Greater Greenville Association of REALTORS®

Barkley Rickman - The Parker Company

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
209 High Country Way
Landrum, SC 29356
11/10/17 1395000 The Cliffs at Glassy
4 Huntington Court
Greenville, SC 29615
12/8/17 1395000 Huntington
113 Upper Ridge Way
Travelers Rest, SC 29690
12/4/17 1295000 Cliffs Valley
1906 Jonesville Road
Simpsonville, SC 29681
10/27/17 1165000 None
107 Tuscany Way
Greer, SC 29650
11/7/17 1100000 Thornblade
130 Duck Hawk Way
Marietta, SC 29661
12/18/17 975000 The Cliffs at Mountain Park
211 Knightsridge Road
Travelers Rest, SC 29690
12/28/17 965000 Cliffs Valley
1150 McCarter Road
Fountain Inn, SC 29644
10/30/17 949000 None
6 Dolphin Pond Lane
Fountain Inn, SC 29644
11/7/17 899900 Catalina Estates
111 Boxwood Lane
Greenville, SC 29601
12/4/17 859000 Alta Vista
101 Ramsford Lane
Simpsonville, SC 29681
12/15/17 859000 Cobblestone
501 & 503 Augusta Street
Greenville, SC 29609
10/31/17 849800 Downtown
509 E Seven Oaks Drive
Greenville, SC 29605
11/30/17 839000 Chanticleer
220 Saluda Run Drive
Piedmont, SC 29673
1/3/18 830000 Acadia
127 Seminole Drive
Greenville, SC 29605
10/30/17 829000 Augusta Road
707 Brixton Circle
Simpsonville, SC 29681
11/30/17 810000 Cobblestone
63 Sweetgum Road
Greenville, SC 29617
12/18/17 799900 Green Valley
29 Quail Hill Drive
Greenville, SC 29607
11/9/17 799000 Parkins Mill Area
15 Rolleston Drive
Greenville, SC 29615
11/16/17 789900 Claremont - Greenville
208 Chamblee Boulevard
Greenville, SC 29615
1/5/18 769900 Claremont - Greenville
269 Carolina Wren Trail
Marietta, SC 29661
1/5/18 769000 The Cliffs at Mountain Park
133 Augusta Court
Greenville, SC 29605
12/28/17 750000 Augusta Road
305 Stonebrook Farm Way
Greenville, SC 29615
12/8/17 699900 Stonebrook Farm
316 Byrd Boulevard
Greenville, SC 29605
12/13/17 697500 Augusta Road
407 Hemingford Circle
Simpsonville, SC 29681
12/7/17 680000 Kingsbridge

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.