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 (b.cnpropertyname like '%Ladoll International City%' or b.enpropertyname like '%Ladoll International City%') order by updateTime Desc, a.dftpic desc
New decoration, whole room floor heating, whole room central air conditioning, with embedded oven, microwave oven, dishwasher! The house has its own super 100 f...
Modern design, Fully furnitured,walking distance to subway line 2 and line 1, with large living room,very comfortable living environment.please confirm with our...