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 >= 40000 and a.houseprice <= 50000) and a.houseType = 3 and c.enDistrictName = 'Pudong' order by updateTime Desc, a.dftpic desc
This is an amazing apt, it was newly renovated, luxury decoration with bright and spacious livingroom and bedrooms, whole house floor heating and wall heating, ...
