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
  • Palm Beach Condominiums 104, Christ Church

  • Hastings, Christ church
  • Parish: Christ Church
  • Property Status: Long Term Rental
  • Property Type: Furnished, Beachfront, Condominium, Residential
  • List Price: US$ 4,750 
  • Bedrooms: 3 
  • Bathrooms: 3.5 
  • Ocean Reef 201

  • Christ Church
  • Parish: Christ Church
  • Property Status: Long Term Rental
  • Property Type: Furnished, Condominium, Oceanfront, Residential
  • List Price: US$ 4,750 
  • Bedrooms: 3 
  • Bathrooms: 3 
  • Fort George Heights, 7 Wildey Avenue REDUCED

  • Fort George Heights, St. Michael
  • Parish: St. Michael
  • Property Status: Long Term Rental
  • Property Type: Appliances Only, Unfurnished, House / Villa, Residential
  • List Price: US$ 4,750 
  • Bedrooms: 5 
  • Bathrooms: 5.5 
  • Gibbs Hill, Altamira

  • Gibbs Hill,St. Peter
  • Parish: St. Peter
  • Property Status: Long Term Rental
  • Property Type: Appliances Only, Furnished, Semi-furnished, Unfurnished, House / Villa, Residential
  • List Price: US$ 4,750 
  • Bedrooms: 4 
  • Bathrooms: 4 
  • Westmoreland, "Malabar"

  • Westmorland, Malabar
  • Parish: St. James
  • Property Status: Long Term Rental
  • Property Type: Semi-furnished, House / Villa, Residential
  • List Price: US$ 5,000 
  • Bedrooms: 4 
  • Bathrooms: 6 
  • Ocean Reef 101

  • Parish: Christ Church
  • Property Status: Long Term Rental
  • Property Type: Furnished, Condominium, Oceanfront
  • List Price: US$ 5,250 
  • Bedrooms: 3 
  • Bathrooms: 3 
  • Port Ferdinand 603

  • Port Ferdinand, St. Peter
  • Parish: St. Peter
  • Property Status: Long Term Rental
  • Property Type: Appliances Only, Unfurnished, Condominium, Gated Community Estate, Luxury, Oceanfront, Residential
  • List Price: US$ 6,000 
  • Bedrooms: 3 
  • Bathrooms: 3 
  • Port Ferdinand 604

  • Port Ferdinand, St. Peter
  • Parish: St. Peter
  • Property Status: Long Term Rental
  • Property Type: Appliances Only, Unfurnished, Condominium, Gated Community Estate, Luxury, Oceanfront
  • List Price: US$ 6,000 
  • Bedrooms: 3 
  • Bathrooms: 3 
  • Countryside 4-Bedroom Home

  • Countryside St Thomas Barbados
  • Parish: St. Thomas
  • Property Status: Long Term Rental
  • Property Type: Furnished, House / Villa, Residential
  • List Price: US$ 6,000 
  • Bedrooms: 4 
  • Bathrooms: 4 
Slide 2