Properties for Rent

#
: array(4) {
  [0]=>
  string(387) "SELECT * FROM wp_fastproperties t1  INNER JOIN wp_posts t2 ON t1.post_id = t2.ID WHERE t2.post_status = 'publish' AND (1=1) and (office_id<>'XNJCAM') AND (office_id>'') AND (status>'') AND (status NOT IN ('sold','leased','deleted') ) AND (property_type IN ('rental','commercial_land/lease','business/lease','commercial/lease') ) ORDER BY property_list_date DESC, post_id DESC LIMIT 0, 10"
  [1]=>
  string(341) "SELECT COUNT(post_id) FROM wp_fastproperties t1  INNER JOIN wp_posts t2 ON t1.post_id = t2.ID WHERE t2.post_status = 'publish' AND (1=1) and (office_id<>'XNJCAM') AND (office_id>'') AND (status>'') AND (status NOT IN ('sold','leased','deleted') ) AND (property_type IN ('rental','commercial_land/lease','business/lease','commercial/lease') )"
  [2]=>
  string(0) ""
  [3]=>
  string(0) ""
}

Displaying 10 of 13 total properties

Load more