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 (crestview hills) AND "idx_listings"."updated" > 2018-04-22 14:16:52.761641) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-5 of 5 Listings

CONTINGENCY CONTRACT

$157,000

114 W Celestial Drive

Greer, SC

3 BDs, 2 BAs

MLS: 1362843

Crestview Hills

Source: Greater Greenville Association of REALTORS®

Steven Salvato - Keller Williams Greenville Cen

CONTINGENCY CONTRACT

$154,000

122 Apollo Avenue

Greer, SC

3 BDs, 2 BAs

MLS: 1363170

Crestview Hills

Source: Greater Greenville Association of REALTORS®

Drew Custer - Flagship Sc Properties, Llc

CONTINGENCY CONTRACT

$149,900

319 E Celestial Drive

Greer, SC

3 BDs, 2 BAs

MLS: 1364513

Crestview Hills

Source: Greater Greenville Association of REALTORS®

Meredith Shannon - Keller Williams Grv Upst

CONTINGENCY CONTRACT

$149,900

329 E Celestial Drive

Greer, SC

3 BDs, 2 BAs

MLS: 1358411

Crestview Hills

Source: Greater Greenville Association of REALTORS®

Terri Warner - Hive Realty, Llc

$145,000

209 Vega Lane

Greer, SC

3 BDs, 2 BAs

MLS: 1362432

Crestview Hills

Source: Greater Greenville Association of REALTORS®

Steven Salvato - Keller Williams Greenville Cen

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
314 E Celestial Drive
Greer, SC 29651
2/9/18 135900 Crestview Hills

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.