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-10-13 05:49:34.530027) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 32 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

CONTINGENCY CONTRACT

$1,150,000

130 Capers Street

Greenville, SC

5 BDs, 4 BAs

MLS: 1376536

Augusta Road

Source: Greater Greenville Association of REALTORS®

Blair Miller - Wilson Associates

REDUCED

$1,025,000

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

REDUCED

$898,500

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

$887,500

43 Forest Lane

Greenville, SC

4 BDs, 3 BAs

MLS: 1375889

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®

Leah Grabo - Joan Herlong Sotheby's Int'l

CONTINGENCY CONTRACT

$650,000

13 Ottaway Drive

Greenville, SC

4 BDs, 3 BAs

MLS: 1376183

Augusta Road

Source: Greater Greenville Association of REALTORS®

Jacob Mann - Coldwell Banker Caine/Williams

$640,000

132 Aberdeen Drive

Greenville, SC

5 BDs, 3 BAs

MLS: 1377199

Augusta Road

Source: Greater Greenville Association of REALTORS®

Karla Alvarez - Coldwell Banker Caine/Williams

REDUCED

$589,000

404 Aberdeen Drive

Greenville, SC

4 BDs, 3 BAs

MLS: 1375674

Augusta Road

Source: Greater Greenville Association of REALTORS®

Michelle Kilcoyne - Southern Home Real Estate

CONTINGENCY CONTRACT

$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

$549,000

116 Cureton Street

Greenville, SC

4 BDs, 3 BAs

MLS: 1377427

Augusta Road

Source: Greater Greenville Association of REALTORS®

Anna Hill Miller - Bhhs C Dan Joyner - Augusta Rd

REDUCED

$524,900

30 E Tallulah Drive

Greenville, SC

4 BDs, 3 BAs

MLS: 1343052

Augusta Road

Source: Greater Greenville Association of REALTORS®

Beth Crigler - Bhhs C Dan Joyner - Augusta Rd

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.