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) ""
}
FOR RENT
3 Princes Way, Drouin
$490 Per Week
422
FOR RENT
8/3 Gumleaf Place, Drouin
$300 Per Week
312
FOR RENT
70 Mills Road, Warragul
$420 Per Week
422
FOR RENT
111 Willandra Circuit, Warragul
$410 Per Week
322
FOR RENT
1/25 George Street, Warragul
$390 Per Week
412
FOR RENT
31 Willow Crescent, Warragul
$450 Per Week
323
FOR RENT
5 Lincoln Street, Warragul
$360 Per Week
312
FOR RENT
27 Princess Street, Warragul
$340 per week
312
FOR RENT
10a Brynwood Avenue, Drouin
$380 Per Week
312
FOR RENT
4 Paulan Court, Warragul
$420 per week
422

Displaying 10 of 13 total properties

Load more