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 = 3 and (a.houseprice >= 20000 and a.houseprice <= 30000) and (a.houseArea >= 200 and a.houseArea <= 300) order by updateTime Desc, a.dftpic desc
Self-residential property with good maintenance, move out of the town for the new baby born, 2bedrooms with 2bathrooms, highly quality with full furnished.
Heritage apartment close to Hengshan Road with elevator. Wall heating system and built-in oven installed. Freshly renovated, spacious % full of sunlight.
North-south transparent, good ventilation, good lighting,with outdoor balcony,open landscape.The apartment also include free fitness center,offer free cleaning ...
Ikea style decoration,Full of Sunshine ,equiped with washing machine,baking oven,wall heating,bathtub.The compound also have a clubhouse,indoor swimming pool,p...