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 = 2 and (b.cnpropertyname like '%Old house in ShaoXing Road%' or b.enpropertyname like '%Old house in ShaoXing Road%') order by updateTime Desc, a.dftpic desc
Large living space and contemporary kitchen. Very well arranged and spacious old house with open kitchen, nice view. newly renovated,luxury decoration with spa...
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 ...