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 order by housePrice Asc, 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...
The property comprises a generous living room, contemporary kitchen with open-plan dining room. offer luxury western decoration and spacious open layout, nice v...
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...
