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 = 3 and (a.houseprice >= 30000 and a.houseprice <= 40000) and a.houseType = 3 and c.enDistrictName = 'Xuhui' order by updateTime Desc, a.dftpic desc
Luxury Decoration, Fully furnished, Center of French Concession, With elevator, air-condition, three bedrooms with two bedrooms,Good views, Close to Line1 Hengs...
High rise Building with elevator, Heritage apt in the Xinle Road, nice with large size terrace, high quality equipements, floor heating system installed