Short Term Rentals
SELECT
node.nid as nid, node.title as ptitle , min(RR.field_nightly_rate_amount) as NR
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_rental_rate RR ON RP.nid = RR.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 = 1) GROUP BY node.nid ORDER BY NR ASC
-
- Sandy Lane, St. James
- Parish: St. James
- Property Status: Short Term Rental
- Property Type:
House / Villa, Luxury, Sandy Lane
- List Price: US$
2,800 - 5,200
- Bedrooms: 5
- Bathrooms: 5.5
-
- St. James
- Parish: St. James
- Property Status: Short Term Rental
- Property Type:
House / Villa, Luxury
- List Price: US$
495 - 1,250
- Bedrooms: 4
- Bathrooms: 4.5
-
- Speightstown, St. Peter
- Parish: St. Peter
- Property Status: Short Term Rental
- Property Type:
Apartment, Beachfront
- List Price: US$
75 - 100
- Bedrooms: 1
- Bathrooms: 1
-
- Parish: St. Peter
- Property Status: Short Term Rental
- Property Type:
Furnished, House / Villa, Residential
- List Price: US$
115
- Bedrooms: 3
- Bathrooms: 2
-
- Speightstown, St. Peter
- Parish: St. Peter
- Property Status: Short Term Rental
- Property Type:
Apartment, Beachfront
- List Price: US$
120 - 150
- Bedrooms: 2
- Bathrooms: 1
-
- Speightstown, St. Peter
- Parish: St. Peter
- Property Status: Short Term Rental
- Property Type:
Apartment, Beachfront
- List Price: US$
145 - 195
- Bedrooms: 2
- Bathrooms: 2
-
- Sugar Hill, St. James
- Parish: St. James
- Property Status: Short Term Rental
- Property Type:
Furnished, Gated Community Estate, Luxury, Villa
- List Price: US$
220 - 325
- Bedrooms: 2
- Bathrooms: 2
-
- Porter's, St. James
- Parish: St. James
- Property Status: Short Term Rental
- Property Type:
Furnished, House / Villa
- List Price: US$
1,575 - 3,150
- Bedrooms: 2
- Bathrooms: 2
-
- Port St. Charles, St. Peter
- Parish: St. Peter
- Property Status: Short Term Rental
- Property Type:
House / Villa, Luxury
- List Price: US$
275 - 345
- Bedrooms: 4
- Bathrooms: 3.5
-
- St. Lawrence Gap, Christ Church
- Parish: Christ Church
- Property Status: Short Term Rental
- Property Type:
Beachfront, Condominium
- List Price: US$
285 - 525
- Bedrooms: 2
- Bathrooms: 2