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.houseType = 4 and (a.houseArea >= 200 and a.houseArea <= 300) and c.enDistrictName = 'Pudong' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Lujiazui') order by updateTime Desc, a.dftpic desc
Newly renovated, everything is brand new!! one master bedroom, one guest room. one reading room and one tea house. two balconies. central A/C floor heating.
It is an amazing single-family apartment with four bedrooms newly renovated with elegant decoration. This home's highlights include two bright and spacious livi...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
