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(rent%) AND "idx_listings"."updated" > 2018-08-20 02:18:44.354215) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 100 Listings

$4,000/month

6 Baronne Court

Greer, SC

4 BDs, 4 BAs

MLS: 1370990

Thornblade

Source: Greater Greenville Association of REALTORS®

Avril Caviness - C. Dan Joyner & Co Inc

REDUCED

$3,000/month

14 Ossabaw Loop

Simpsonville, SC

4 BDs, 4 BAs

MLS: 1369751

Five Forks Plantation

Source: Greater Greenville Association of REALTORS®

Carlos Tuazon - Alpha Property Llc

REDUCED

$2,950/month

421 Kingsgate Court

Simpsonville, SC

5 BDs, 5 BAs

MLS: 1369235

Kingsbridge

Source: Greater Greenville Association of REALTORS®

Julie Burton - Coldwell Banker Caine/Williams

$2,800/month

Travelers Rest, SC

4 BDs, 3 BAs

MLS: 1370971

 

Source: Greater Greenville Association of REALTORS®

Avril Caviness - C. Dan Joyner & Co Inc

NEW

$2,650/month

101 W Augusta Place

Greenville, SC

3 BDs, 2 BAs

MLS: 1374337

Augusta Road

Source: Greater Greenville Association of REALTORS®

Julie Burton - Coldwell Banker Caine/Williams

$2,650/month

34 Devonhall Way

Taylors, SC

5 BDs, 3 BAs

MLS: 1372893

Berkshire Park

Source: Greater Greenville Association of REALTORS®

Janie VanLeeuwen - Keller Williams Drive

$2,595/month

1123 Wembley Road

Greenville, SC

5 BDs, 3 BAs

MLS: 1371332

Gower Estates

Source: Greater Greenville Association of REALTORS®

Kevin Cribbs - Houses And Then Some Realty

NEW

$2,500/month

109 Damascus Drive

Simpsonville, SC

5 BDs, 3 BAs

MLS: 1374440

Copper Creek

Source: Greater Greenville Association of REALTORS®

Lisa Alexander - Del-Co Realty Group, Inc.

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
336 Montalcino Way
Simpsonville, SC 29681
7/11/18 3500 Tuscany Falls
614 Pawleys Drive
Simpsonville, SC 29681
6/13/18 2995 Five Forks Plantation
7 Red Jonathan Court
Simpsonville, SC 29681
7/24/18 2100 Gilder Creek Farm
4 Heathfield Court
Simpsonville, SC 29681
6/5/18 1250 Dunwoody Oaks

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.