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 >= 10000 and a.houseprice <= 20000) and (b.cnpropertyname like '%Old house in Fumin Road%' or b.enpropertyname like '%Old house in Fumin Road%') order by updateTime Desc, a.dftpic desc
Fumin rd near Changle rd, nice decoration, fully furnished, open kitchen, good light, two bedrooms+two bathrooms, about 5mins walking to Line1 Changshu rd satio...
2nd floor, 3rd floor and fouth floor, one bedroom with south direction and one small room, the master bedroom with large round balcony, bathroom with bath tub
Delicated decoration,the property comprises a brigh and sunny livingroom , north-south transparent, good ventilation, good lighting, with a beautiful balcony, o...
