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 >= 40000 and a.houseprice <= 50000) and c.enDistrictName = 'Huangpu' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Xintiandi') order by updateTime Desc, a.dftpic desc
It is a nice single-family lane house, offers spacious and bright livingroom and well equipped contemporary open kitchen, whole house wall heating, with huge ga...
The apartment is particularly good, whole house floor heating,Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeabi...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With a loft an large ...
C/A, boasts high ceilings with stunning feature windows,offering abundant living space throughout,beautiful décor throughout and large beautiful terrance