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.houseType = 5 and (a.houseArea >= 300 and a.houseArea <= 400) and c.enDistrictName = 'Qingpu' order by updateTime Desc, a.dftpic desc
T: +86-21-6333-0390, M: +86-185-1609-7608
HOME APARTMENTS VILLAS OLDHOUSES SERVICED APARTMENTS OFFICE ONLINE REQUEST 业主委托 中文

My Favorites My Saved Searches

Home > All for rent > Properties 1 to 5 of 5
Totle: 5 Properties
  • Le Chambord
  • ¥ 50,000/month
  • Layout: 5Br 4Bt
  • Size: 368 sqm
  • Morden European Classic Design with luxourious fitting outs / Full marble Floorings on first floo，DaiKin Central Air conditioning syste，Full house fresh air sys...
  • Long Beach Garden Villa
  • ¥ 30,000/month
  • Layout: 5Br 4Bt
  • Size: 340 sqm
  • 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...
  • Le Chambord
  • ¥ 38,000/month
  • Layout: 5Br 5Bt
  • Size: 400 sqm
  • Le Chambord
  • ¥ 50,000/month
  • Layout: 5Br 4Bt
  • Size: 369 sqm
  • 900平方的大花园。

My Favorites My Saved Searches

My dashboard
  • This is your property dashboard...
  • Recently viewed properties and searches will appear here for quicker reference.
Call (+86-21)6333 0390 to get more information,or Online Request
  1. About Us
    Why Michael Realty
    About Michael Realty
    Careers
    Contact Us
  2. Property Guides
    Yanlord Garden
    Shimao Riviera Garden
    IFC
    Central Residence
    Casa Lakeville
    Ladoll International City
    The Greenhills
  3. Links
    FAQ
    Mandarin Inn
    Immigration
    Healthcare
    Utility bill & Maid
    Others
Copyright © 2014 Michael Realty All Rights Reserved. 沪ICP备14038152号