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 >= 60000 and a.houseprice <= 500000) and (a.houseArea >= 200 and a.houseArea <= 300) order by updateTime Desc, a.dftpic desc
New decoration, fully furnished, whole apt floor heating, A/C, open kitchen, oven, dish washing, washing mashine with dryer, large terrace and yard, close to We...
4bedrooms with 3bathrooms, large size livignrooms space,high quality eqipements in the kitchen, parts of furnished, can be negotiable about the furniture
Delicated decoration,with large garden,the property comprises a brigh and sunny livingroom ,north-south transparent, good ventilation, good lighting, with a bea...