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 a.houseType = 3 and c.enDistrictName = 'Qingpu' order by updateTime Desc, a.dftpic desc
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,
especially good north-south light permeability.With large balconie...
Delicated decoration,the property comprises a brigh and sunny living room and well equipped contemporary kitchen, north-south transparent, good ventilation, goo...
Nice decoration with good furniture, western style, whole room which floor heating. Larce spacious livingroom and dining room, and with very large window makes ...
Quite bright apaptment with good qualty furniture. The livingroom and diningroom are more space for family together! Soft matterss in the main bedroom and guest...