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.cnpropertyname like '%Green Court%' or b.enpropertyname like '%Green Court%') order by updateTime Desc, a.dftpic desc
T: +86-21-6333-0390, M: +86-185-1609-7608
Home > All for rent > Properties 1 to 4 of 4
Totle: 4 Properties
  • Green Court
  • ¥ 40,000/month
  • Layout: 3Br 3Bt
  • Size: 270 sqm
  • Antique decoration, large space living room and dining room, beauty furniture.
  • Green Court
  • ¥ 25,000/month
  • Layout: 2Br 2Bt
  • Size: 166 sqm
  • Luxury deco with spacious and bright livingroom and br, with a beauty balcony.
  • Green Court
  • ¥ 38,000/month
  • Layout: 4Br 2Bt
  • Size: 270 sqm
  • The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
  • Green Court
  • ¥ 35,000/month
  • Layout: 4Br 3Bt
  • Size: 238 sqm
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号.