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 (crescent creek) AND "idx_listings"."updated" > 2018-08-20 03:53:47.003113) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

REDUCED

$115,900

19 Lama Way

Greenville, SC

3 BDs, 2 BAs

MLS: 1367489

Crescent Creek

Source: Greater Greenville Association of REALTORS®

Tim Harris - Providence Realty & Marketing

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
9 Mount Vere Drive
Greenville, SC 29607
6/28/18 849500 Parkins Mill
471 E Parkins Mill Road
Greenville, SC 29607
7/9/18 699900 Quail Hill
55 Chisolm Trail
Greenville, SC 29607
7/24/18 639000 Parkins Mill Area
220 Weatherstone Lane
Simpsonville, SC 29680
7/12/18 540000 Weatherstone
200 Weatherstone Lane
Simpsonville, SC 29680
7/16/18 489500 Weatherstone
201 Weatherstone Lane
Simpsonville, SC 29680
7/31/18 425000 Weatherstone
416 Marswen Court
Simpsonville, SC 29680
7/2/18 424900 Weatherstone
3 POPLAR GROVE Court
Greenville, SC 29607
7/20/18 389900 Parkins Grove
201 Quail Hunt Road
Simpsonville, SC 29680
7/20/18 389800 Lost River
202 Walnut Hill Court
Simpsonville, SC 29681
7/23/18 384990 Parker's Landing
342 Laguna Lane
Simpsonville, SC 29680
6/15/18 375000 The Courtyards on West Georgia Road
607 Briar Thistle Court
Simpsonville, SC 29680
7/30/18 359400 Lost River
101 Martele Court
Simpsonville, SC 29680
7/19/18 349900 Verdmont
109 Brandau Lane
Simpsonville, SC 29680
8/14/18 349749 Weatherstone
1 Leafmore Court
Simpsonville, SC 29680
7/27/18 346284 Leafmore Woods
2725 W Georgia Road
Piedmont, SC 29673
7/16/18 344900 None
15 Sandusky Lane
Simpsonville, SC 29680
6/15/18 339900 River Shoals
154 Circle Slope Drive
Simpsonville, SC 29681
8/17/18 336000 Holly Trace
213 Kings Heath Lane
Simpsonville, SC 29680
6/22/18 334900 Crossgate at Remington
308 S Main Street
Simpsonville, SC 29681
7/27/18 330000 None
301 Clairhill Court
Simpsonville, SC 29680
7/31/18 315000 Verdmont
7 Flintlock Court
Piedmont, SC 29673
6/16/18 315000 Garrison Woods
402 Hayworth Drive
Simpsonville, SC 29680
8/17/18 315000 Verdmont
201 Weddington Lane
Simpsonville, SC 29681
6/25/18 309900 Linden Park
17 Marquette Road
Simpsonville, SC 29680
6/28/18 309900 Verdmont

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.