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 (augusta road) AND "idx_listings"."updated" > 2018-08-20 02:10:40.131239) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 36 Listings

REDUCED

$1,999,950

108 Crescent Avenue

Greenville, SC

4 BDs, 5 BAs

MLS: 1364169

Augusta Road

Source: Greater Greenville Association of REALTORS®

Lil Glenn - Lil Glenn Co, Llc

REDUCED

$1,086,400

233 Camille Avenue

Greenville, SC

4 BDs, 3 BAs

MLS: 1369499

Augusta Road

Source: Greater Greenville Association of REALTORS®

Skipper Smith - Bhhs C Dan Joyner - Pelham

$949,000

309 W Faris Road

Greenville, SC

5 BDs, 5 BAs

MLS: 1369694

Augusta Road

Source: Greater Greenville Association of REALTORS®

Sharon Wilson - Wilson Associates

REDUCED

$675,000

13 Ottaway Drive

Greenville, SC

4 BDs, 3 BAs

MLS: 1366848

Augusta Road

Source: Greater Greenville Association of REALTORS®

Jacob Mann - Coldwell Banker Caine/Williams

REDUCED

$669,605

103 Waccamaw Avenue

Greenville, SC

4 BDs, 2 BAs

MLS: 1372590

Augusta Road

Source: Greater Greenville Association of REALTORS®

C. Matthew Crider - Joan Herlong Sotheby's Int'l

REDUCED

$640,000

132 Aberdeen Drive

Greenville, SC

5 BDs, 3 BAs

MLS: 1367982

Augusta Road

Source: Greater Greenville Association of REALTORS®

Karla Alvarez - Bhhs C Dan Joyner - N. Pleas

$629,900

114 Aberdeen Drive

Greenville, SC

4 BDs, 4 BAs

MLS: 1374212

Augusta Road

Source: Greater Greenville Association of REALTORS®

Heidi Putnam - Coldwell Banker Caine/Williams

REDUCED

$605,605

2 Phillips Lane

Greenville, SC

4 BDs, 3 BAs

MLS: 1369532

Augusta Road

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

CONTINGENCY CONTRACT

$589,000

20 Sunset Drive

Greenville, SC

4 BDs, 4 BAs

MLS: 1371922

Augusta Road

Source: Greater Greenville Association of REALTORS®

Blair Miller - Wilson Associates

NEW

$569,000

116 Cureton Street

Greenville, SC

4 BDs, 3 BAs

MLS: 1374359

Augusta Road

Source: Greater Greenville Association of REALTORS®

Anna Hill Miller - Bhhs C Dan Joyner - Augusta Rd

$565,000

146 Faris Circle

Greenville, SC

4 BDs, 3 BAs

MLS: 1372390

Augusta Road

Source: Greater Greenville Association of REALTORS®

M. Susie White - Wilson Associates

REDUCED

$560,000

15 Trails End

Greenville, SC

4 BDs, 3 BAs

MLS: 1368192

Augusta Road

Source: Greater Greenville Association of REALTORS®

Thomas Cheves - Coldwell Banker Caine/Williams

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.