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 = 2 and a.houseType = 3 and (a.houseArea >= 200 and a.houseArea <= 300) order by updateTime Desc, a.dftpic desc
Delicated decoration,the property comprises a brigh and sunny living room and well equipped contemporary kitchen, north-south transparent, good ventilation, goo...
Nice decoration with good furniture, western style, whole room which floor heating. Larce spacious livingroom and dining room, and with very large window makes ...
Quite bright apaptment with good qualty furniture. The livingroom and diningroom are more space for family together! Soft matterss in the main bedroom and guest...
