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 (alta vista) AND "idx_listings"."updated" > 2018-08-20 02:12:20.506658) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 12 Listings

REDUCED

$895,000

514 Watts Avenue

Greenville, SC

4 BDs, 3 BAs

MLS: 1371894

Alta Vista

Source: Greater Greenville Association of REALTORS®

Susan Dodds - Bhhs C Dan Joyner - Cbd

REDUCED

$825,000

821 Crescent Avenue

Greenville, SC

5 BDs, 4 BAs

MLS: 1372378

Alta Vista

Source: Greater Greenville Association of REALTORS®

Jeannette Schell - Coldwell Banker Caine/Williams

$769,601

329 Pine Forest Drive Extension

Greenville, SC

4 BDs, 4 BAs

MLS: 1368365

Alta Vista

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

$699,605

16 Cromwell Avenue

Greenville, SC

4 BDs, 3 BAs

MLS: 1367043

Alta Vista

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

$679,000

01 Pine Forest Drive Extension

Greenville, SC

4 BDs, 3 BAs

MLS: 1370420

Alta Vista

Source: Greater Greenville Association of REALTORS®

Michelle Kilcoyne - Southern Home Real Estate

CONTINGENCY CONTRACT

$650,000

15 Partridge Lane

Greenville, SC

3 BDs, 3 BAs

MLS: 1374106

Alta Vista

Source: Greater Greenville Association of REALTORS®

Thomas Cheves - Coldwell Banker Caine/Williams

REDUCED

$640,000

103 Belmont Avenue

Greenville, SC

4 BDs, 3 BAs

MLS: 1367024

Alta Vista

Source: Greater Greenville Association of REALTORS®

Thomas Cheves - Coldwell Banker Caine/Williams

CONTINGENCY CONTRACT

$625,605

4 Cromwell Avenue

Greenville, SC

5 BDs, 3 BAs

MLS: 1348836

Alta Vista

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

REDUCED

$615,605

205 Jones Avenue

Greenville, SC

4 BDs, 3 BAs

MLS: 1367102

Alta Vista

Source: Greater Greenville Association of REALTORS®

Joan Herlong - Joan Herlong Sotheby's Int'l

REDUCED

$600,000

39 Harvest Court

Greenville, SC

3 BDs, 3 BAs

MLS: 1369622

Alta Vista

Source: Greater Greenville Association of REALTORS®

Helen Hagood - Coldwell Banker Caine/Williams

CONTINGENCY CONTRACT

$549,000

217 Cleveland Street

Greenville, SC

3 BDs, 3 BAs

MLS: 1367150

Alta Vista

Source: Greater Greenville Association of REALTORS®

Mary Jane Freeman - Coldwell Banker Caine/Williams

$520,000

411 Jones Avenue

Greenville, SC

3 BDs, 2 BAs

MLS: 1373738

Alta Vista

Source: Greater Greenville Association of REALTORS®

Terri Warner - Hive Realty, Llc

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.