The following SQL statement was executed:
select * from (select distinct properties_s_h.* from properties_s_h,property_keywords where property_keywords.keyword_id='21080' and property_keywords.property_id=properties_s_h.id and properties_s_h.id!='1146025' and properties_s_h.block is null and properties_s_h.status!='n' order by property_keywords.rank desc ) sponsors union select * from ( select properties_s_h.* from properties_s_h, keyword_relationships where properties_s_h.keyword_id=keyword_relationships.related_keyword_id and keyword_relationships.keyword_id='21080' and properties_s_h.block is null and properties_s_h.status ='n' and properties_s_h.id!='1146025' order by keyword_relationships.rank desc, properties_s_h.id desc ) normal limit 0,8

The following SQL statement was executed:
select keywords.* from keywords,keyword_relationships where keywords.id=keyword_relationships.related_keyword_id and keyword_relationships.keyword_id ='21080' order by rank desc limit 16

The following SQL statement was executed:
select * from keywords where district_id='594' and idf2>0 and status is not null and idf2>0 order by idf2 asc limit 16

The following SQL statement was executed:
select count(distinct(code)) counter,count(*) total from properties_s_h where telephone = '13305327809' and block is null

The following SQL statement was executed:
select count(*) counter from properties_s_h where telephone = '13305327809' and block is null

青岛

[ 切换城市 ]

| 发布房源信息

抗震救灾，爱心捐助

青岛市胶州市海尔大道

发布日期：2008年04月04日

区域：胶州

地址：青岛市胶州市海尔大道

楼层：第3层

使用面积：1500平方米

房价：297.0万元

交通状况：不详

更多信息：
该网点共三层1500 m²，欲整体出售。位于青岛市胶州市海尔大道诺贝尔山庄南1000米，距青黄高速胶州收费口2000米，是通往济青、青黄、同三高速和青岛市区、青岛开发区、城阳区的必经之路。一层428 m²，二、三各536 m²，共计1500 m²。简易装修，三层各自独立卫生间、电表、水表，塑钢门窗，防盗门。适合于银行、保险、酒店、商场、洗浴中心、企事业单位办公等