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-10-14 00:59:35.212745) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 152 Listings

$3,900/month

Greenville, SC

5 BDs, 4 BAs

MLS: 1376296

Chaunessy

Source: Greater Greenville Association of REALTORS®

Avril Caviness - C. Dan Joyner & Co Inc

$2,950/month

414 Ansel Street

Greenville, SC

3 BDs, 2 BAs

MLS: 1377130

 

Source: Greater Greenville Association of REALTORS®

Carmen Diaz - Rt Eaton

$2,800/month

117 E Woodburn Drive

Taylors, SC

4 BDs, 3 BAs

MLS: 1378101

Seven Oaks

Source: Greater Greenville Association of REALTORS®

Bethany Hauf - Re/Max Moves Fountain Inn

$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,500/month

181 Circle Road

Greer, SC

4 BDs, 3 BAs

MLS: 1376806

 

Source: Greater Greenville Association of REALTORS®

Donna Askins - New Leaf Realty

REDUCED

$2,400/month

Travelers Rest, SC

4 BDs, 3 BAs

MLS: 1370971

 

Source: Greater Greenville Association of REALTORS®

Avril Caviness - C. Dan Joyner & Co Inc

REDUCED

$2,395/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,395/month

105 Quail Creek Lane

Greenville, SC

3 BDs, 2 BAs

MLS: 1378601

Quail Creek

Source: Greater Greenville Association of REALTORS®

Giovonnie Patterson - The Carolina Agent Grp.Upstate

REDUCED

$2,395/month

105 Highgrove Court

Simpsonville, SC

4 BDs, 2 BAs

MLS: 1369302

Highgrove Estates

Source: Greater Greenville Association of REALTORS®

Julie Burton - Coldwell Banker Caine/Williams

REDUCED

$2,300/month

308 Medford Drive

Greer, SC

4 BDs, 3 BAs

MLS: 1375949

Riverwood Farm

Source: Greater Greenville Association of REALTORS®

Tony Tamburro - Keller Williams Greenville Cen

$2,200/month

Simpsonville, SC

5 BDs, 4 BAs

MLS: 1378171

Orchard Farms

Source: Greater Greenville Association of REALTORS®

Avril Caviness - C. Dan Joyner & Co Inc

$2,195/month

11 Cammer Avenue

Greenville, SC

3 BDs, 2 BAs

MLS: 1376700

 

Source: Greater Greenville Association of REALTORS®

Kevin Cribbs - Houses And Then Some Realty

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.