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 = 1 and (a.houseArea >= 0 and a.houseArea <= 100) and c.enDistrictName = 'Putuo' order by updateTime Desc, a.dftpic desc
Central air conditioning, bathroom with floor heating, embedded oven, embedded microwave oven, whole house soft water purification system. The community has its...
Delicated decoration,the property comprises a brigh and sunny living room and well equipped contemporary kitchen, north-south transparent, good ventilation, goo...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.whole house floor hea...
