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 >= 40000 and a.houseprice <= 50000) and c.enDistrictName = 'Pudong' order by updateTime Desc, a.dftpic desc
The Oriental Garden is located on Jinqiao Road, in Pudong District, 6 mins from Dolwich College International School and 7 mins from Carrefour ;With a 500sqm ga...
Newly renovated, everything is brand new!! one master bedroom, one guest room. one reading room and one tea house. two balconies. central A/C floor heating.
It is an amazing single-family lane house with newly renovated with elegant decoration.
This house's highlights include two bright and spacious livingroom, wel...
This is an amazing apt, it was newly renovated, luxury decoration with bright and spacious livingroom and bedrooms, whole house floor heating and wall heating, ...