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 = 5 and (a.houseArea >= 300 and a.houseArea <= 400) order by updateTime Desc, a.dftpic desc
Morden European Classic Design with luxourious fitting outs / Full marble Floorings on first floo,DaiKin Central Air conditioning syste,Full house fresh air sys...
Fully furnishing, electrical appliances, floor heating, central air conditioner, hood, stove, dishwasher, oven, central water purifier, satellite receiver etc.
It is an amazing single-family lane house , newly renovated with elegant decoration.This house's highlights include a bright and spacious livingroom, well equip...