1.888.794.7590 Contact

SELECT node.nid as nid, node.title as ptitle , RR.field_nightly_rate_amount as NR FROM node INNER JOIN content_type_property AS cp ON node.nid = cp.nid INNER JOIN term_node AS tn ON cp.nid = tn.nid INNER JOIN term_data AS td ON tn.tid = td.tid INNER JOIN term_node tnd ON node.nid = tnd.nid INNER JOIN term_data tdt ON tdt.tid = tnd.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 WHERE node.status <> 0 AND node.type = 'property' AND ( tn.tid = 1) AND cp.field_property_region_nid = 50 GROUP BY node.nid ORDER BY NR DESC

Thailand Vacation Rental and Villa Rentals

Villa Riva
Bang Por, Koh Samui, Thailand
7 bed    7.5 baths
Rate On Request
Villa Riva is an exceptional choice for families or groups of friends seeking the ultimate exclusive retreat! The multifunctional living spaces and luxurious facilities offer guests a range ...
Ban Haad Sai
Bang Rak, Koh Samui, Thailand
7 bed    7 baths
Rate On Request
Ban Haad Sai is a large luxurious beach front villa comprised of 2 identical pavilions with spectacular sea views overlooking the truly inspiring golden Big Buddha Bay and its famous Temple, the Big B...
Four Seasons Resort Villas Koh Samui
Koh Samui, Thailand
4 bed    2 baths
Rate On Request
At the Four Seasons Resort Koh Samui experience prefection in your private hillside luxury villa, shaded by coconut groves, and overlooking the Gulf of Siam. Dotted around the hillside, the luxurious ...
Villa Kalyana
Laem Sor, Koh Samui, Thailand
14 bed    14 baths
Rate On Request
Undeniably beautiful, Villa Kalyana is an exclusive beachfront estate, within a private bay, on Koh Samui’s idyllic south shore. The lush palm tree plantation, fringed by the icing sugar sands and c...
favourite