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 (holly tree plantation) AND "idx_listings"."updated" > 2018-06-21 21:49:59.397797) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-10 of 10 Listings

$339,000

906 Plantation Drive

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1367821

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Heather Durbin - Coldwell Banker Caine Co.

NEW

$335,000

204 Mornington Court

Simpsonville, SC

5 BDs, 3 BAs

MLS: 1370589

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Anthony Morgan - Keller Williams Grv Upst

CONTINGENCY CONTRACT

$335,000

204 Mornington Court

Simpsonville, SC

5 BDs, 3 BAs

MLS: 1359066

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

April Whitfield - Only Way Realty Greenville

REDUCED

$334,900

110 Ravenwood Lane

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1368604

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Robert Schmidt - Bhhs C Dan Joyner - Simp

CONTINGENCY CONTRACT

$320,000

106 Ravenwood Lane

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1369367

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Johnny Phillips - Re/Max Realty Professionals

CONTINGENCY CONTRACT

$279,900

102 Honey Horn Drive

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1364818

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Kirsten Zinkann - Keller Williams Greenville Cen

$274,900

105 Linwood Court

Simpsonville, SC

3 BDs, 3 BAs

MLS: 1369888

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Randal Longo - Isave Realty

$274,500

1205 Plantation Drive

Simpsonville, SC

4 BDs, 3 BAs

MLS: 1369265

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Pat James - Bhhs C Dan Joyner - N. Pleas

$264,000

1402 Plantation Drive

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1366839

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

David Painter - Keller Williams Grv Upst

CONTINGENCY CONTRACT

$254,900

202 Pecan Hill Drive

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1365827

Holly Tree Plantation

Source: Greater Greenville Association of REALTORS®

Jeremy Russell - Re/Max Realty Professionals

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.
Site Maintenance
at 8 p.m. EDT
(Click for details)