No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by rt.ordering' at line 1 SQL=SELECT rt.* FROM vb_properties_rates as rt WHERE rt.published = 1 AND rt.productid = order by rt.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by i.ordering' at line 1 SQL=SELECT i.* FROM vb_properties_images as i WHERE i.published = 1 AND i.parent = order by i.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.ordering' at line 1 SQL=SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug, CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug FROM vb_properties_products as p LEFT JOIN vb_properties_country AS cy ON cy.id = p.cyid LEFT JOIN vb_properties_state AS s ON s.id = p.sid LEFT JOIN vb_properties_locality AS l ON l.id = p.lid LEFT JOIN vb_properties_category AS c ON c.id = p.cid LEFT JOIN vb_properties_type AS t ON t.id = p.type LEFT JOIN vb_properties_profiles AS pf ON pf.mid = p.agent_id WHERE p.published = 1 AND p.parent = order by p.ordering

DETAILS_MARKET

The price can vary without prior notice, please consult us. The price is quoted in Thaï bath, exchange rates are given for information purpose only on an average rate, not a real time rate.

Contact for property

Quick answer, usually within one day. Don't hesitate to details your need or call us.

Thailand Property ShowRoom

Company Vauban Co., Ltd. (Head Office)
Trendy  Office Building, unit10/36 (First floor)
Soi Sukhumvit 13,Sukhumvit road.,Klongtoey Noey,Wattana,
Bangkok,Thailand
(2min walking distance BTS Nana)
Tel : +66 (0) 02-168-7047
Fax : +66 (0) 02-168-7048
Mobile: +66 (0) 8-5227-7175
Email: [email protected]

Send us your enquiry. Answer within 24h - 48h.
First name:
Name: *
Phone:
Email: *
Skype:
Country:
   
Subject: *
Message:
 

Property Quick Search

Search by reference:

Newsletter

Subscribe to our newsletter!

Investment in Thailand

logo-destination-bangkok
logo-destination-huahin
logo-destination-pattaya
logo-destination-phuket
logo-destination-samui

List your property

icon-listproperty

Blogs & Portal

About Thailand Living
Retirement in Thailand

Proud member of

reba-thailand
Franco Thai chamber of Commerce