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 >= 20000 and a.houseprice <= 30000) and a.houseType = 4 and c.enDistrictName = 'Xuhui' order by updateTime Desc, a.dftpic desc
Large size 4bedrooms with 2bathrooms, floor heating system, open kitchen with high quality equipments, nice decoration with full furnished
High floor with nice...
Ikea style decoration,Full of Sunshine ,equiped with washing machine,baking oven,wall heating,bathtub.The compound also have a clubhouse,indoor swimming pool,p...