Long Term Rentals



SELECT node.nid as nid, node.title as ptitle , min(content_type_property.field_property_ltrental_min_amount) as NR , min(content_type_property.field_property_ltrental_max_amount) as NR_max FROM node inner join term_node tn on (tn.nid=node.nid) inner join term_data td on (tn.tid=td.tid) LEFT JOIN content_field_r_property RP ON node.nid = RP.field_r_property_nid LEFT JOIN content_type_property ON node.vid = content_type_property.vid WHERE node.status <> 0 AND node.type = 'property' and (td.vid=1) and (td.tid = 2) GROUP BY node.nid ORDER BY NR ASC, NR_max ASC
  • Margate Gardens 2nd Floor

  • Margate Gardens 2nd Floor, Christ Church
  • Parish: Christ Church
  • Property Status: Long Term Rental
  • Property Type: Apartment, Furnished, Gated Community Estate, Residential
  • List Price: US$ 2,250 
  • Bedrooms: 2 
  • Bathrooms: 2 
  • Six Roads Retail and Office Building

  • Six Roads Retail and Office Building, St.Philip
  • Parish: St. Philip
  • Property Status: Long Term Rental
  • Property Type: Office, Retail, Commercial
  • List Price: US$ 12,182 
  • Regus, One Welches

  • One Welches, St. Thomas
  • Parish: St. Thomas
  • Property Status: Long Term Rental
  • Property Type: Furnished, Office, Commercial
  • List Price: US$ 245 - 4,766 
  • Prior Park, Dormers

  • Parish: St. James
  • Property Status: Long Term Rental
  • Property Type: Furnished, Office, Commercial
  • List Price: US$ 250 - 1,250 
  • Bathrooms: 2 
  • Belle Estate Offices

  • Parish: St. Michael
  • Property Status: Long Term Rental
  • Property Type: Office, Unfurnished, Commercial
  • List Price: US$ 250 - 1,500 
  • Bathrooms: 2 
  • Ashford

  • Parish: St. John
  • Property Status: Long Term Rental
  • Property Type: Apartment, Residential
  • List Price: US$ 575 
  • Bedrooms: 2 
  • Bathrooms: 1 
  • Old Navy Road

  • Old Navy Road, Dayrells Road, Christ Church
  • Parish: Christ Church
  • Property Status: Long Term Rental
  • Property Type: Townhouse
  • List Price: US$ 625 
  • Bedrooms: 2 
  • Bathrooms: 2 
  • The Belle, Upstairs Unit

  • The Belle, St. Michael
  • Parish: St. Michael
  • Property Status: Long Term Rental
  • Property Type: Office, Commercial
  • List Price: US$ 750 
  • Bathrooms: 1 
Slide 2