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 = 1 and (a.houseprice >= 30000 and a.houseprice <= 40000) and a.houseType = 4 and c.enDistrictName = 'Jingan' order by updateTime Desc, a.dftpic desc
280sqms indoor space with additional 80sqms outdoor space, an extra 50sqms terrace. Walk-in closet. Floor heating system and water filter in whole apartment.
Luxury decoration,perfect duplex layout style,Large livingroom and bedroom,open kitchen,High quality appliance,Comfortable living environment,Close to the subwa...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony