select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and b.propertytype = 1 and (a.houseprice >= 30000 and a.houseprice <= 40000) and (b.cnpropertyname like '%Lakeville%' or b.enpropertyname like '%Lakeville%') order by updateTime Desc, a.dftpic desc
Delicated decoration,the property comprises a brigh and sunny livingroom，north-south transparent, good ventilation, good lighting, with a beautiful balcony, o...
Located at the Xintiandi bussiness Area, it is one of the most luxury home in Shanghai. Best home design plus the wonderful home layout. Floor Heating, fully ...
