select * from house where (infoFlag=1 or house.infoFlag=2) and (spOffer>=10000 OR pid=515) and Pid not in(48,51,77,85,123,244) and spOffer>0 order by house.isPic desc,house.order_dujiadaili desc,Frashtime desc,house.hID desc,house.orderNum Property Search | Joanna Real Estate Of Beijing Skip to main content
Sort by:
2315 Properties found
Area : Lufthansa

Four Seasons

¥ 50,000   /month
Apartments
Web ID: AFS0021168
3
2
260 m²
Area : Shunyi Central Villa

Cathay View

¥ 48,000   /month
Villas
Web ID: VVCV043739
4+1
4
400 m²
Area : CBD

World City

¥ 15,000   /month
Apartments
Web ID: AWC0030058
1
1
76 m²
Area : Dongzhimen

East Gate Plaza

¥ 55,000   /month
Service Apartments
Web ID: AAELP49192
3+1
3
310 m²
Area : CBD

Windsor Avenue

¥ 24,000   /month
Apartments
Web ID: AWA0020629
2
2
158 m²
Area : CBD

Windsor Avenue

¥ 15,000   /month
Apartments
Web ID: AWA0006812
1
1
100 m²
¥ 55,000   /month
Service Apartments
Web ID: AAGMB45245
3
3
255 m²
Area : Chaoyang Park

Parkview Tower

¥ 18,000   /month
Apartments
Web ID: APT0000825
2
2
164 m²
Area : CBD

Central Park

¥ 30,000   /month
Apartments
Web ID: ACP0004290
2
2
135 m²
¥ 21,000   /month
Apartments
Web ID: ACCP028481
2
2
106 m²
Area : CBD

Central Park

¥ 19,000   /month
Apartments
Web ID: ACP0009183
1
1
88 m²
Area : Chaoyang Park

Boya Garden

¥ 16,000   /month
Apartments
Web ID: AABG049242
2
2
125 m²
Area : Shunyi Central Villa

River Garden Villa

¥ 33,000   /month
Villas
Web ID: VRGV007295
4
3
220 m²
¥ 33,000   /month
Apartments
Web ID: A000003313
3
2
239 m²
Area : Lufthansa

Beijing SOHO Residences

¥ 32,000   /month
Apartments
Web ID: ABSR021171
2
2
220 m²

Pages