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 (a.houseprice >= 20000 and a.houseprice <= 30000) and (b.cnpropertyname like '%La Cite%' or b.enpropertyname like '%La Cite%') order by updateTime Desc, a.dftpic desc
Luxury decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good li...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
Amazing deal on this newly renovated three bedroom paradise. Large and sunny apartment on one of the most charming compound in Xujiahui. whole house wall heatin...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...