求租
杭州 宁波 浙江

求全部：求写字楼 求商铺 求厂房库房 求其它 求英文 求成功

  • 编号
  • 位置需求
  • 房型
  • 城区
  • 面积
  • 价格
  • 发布日期
Select Req_ID,Req_HouseType,Req_Province,Req_City,Req_Region,Req_ShopA,Req_Type,Req_IsAct,Req_Period,Req_Title,Req_ComName,Req_People,Req_Tel,Req_Area,Req_AreaUnit,Req_Price,Req_PriceUnit,Req_PriceSM,Req_IntoTime,Req_AskAddress,Req_Special,Req_AddTime,Req_Publish,Req_Shop,Req_ShopType,Req_Email,Req_IP,Req_Source,Req_Remind,Req_Userid,Req_inputName,Req_IsOpen,Req_IsGuest,Req_IsService,Req_IsLock,Req_Locktime,Req_LockMan,ucase,ucasetime,Req_CaseUsersid,Req_IsCase,Req_CaseTime,Req_IsDel,Req_FromWeb,Req_FromClass,Req_IsReg,Req_MessIntent,(select ClassName from [Pub_ConfigClass] sw where sw.C_ID=r.Req_Type) as sw_classname,(select ClassName from [Pub_ConfigClass] h where h.C_ID=r.Req_HouseType) as h_classname from [FC_Request] r where r.Req_IsDel=0 and Req_IsLock = 1 and Req_IsCase=0 and req_ID not in (0) and Req_city in ('') order by Req_Publish desc
  • 暂无相关信息
发布专区
精品楼盘
    Select * From [V_Ad] where 1=1 and ADpalce_Web='o571' and ADpalce_Screen='1' and ADpalce_Channels='出租中心' and ADpalce_Place='按钮旗帜' order by ADpalce_Sort
  • 东园大楼商铺
  • 元通大厦写字楼
  • 浙江外经贸广场写字楼
  • 德源大楼写字楼
地铁口求租求购
浙江各地求租购
    Select Req_ID,Req_HouseType,Req_Province,Req_City,Req_Region,Req_ShopA,Req_Type,Req_IsAct,Req_Period,Req_Title,Req_ComName,Req_People,Req_Tel,Req_Area,Req_AreaUnit,Req_Price,Req_PriceUnit,Req_PriceSM,Req_IntoTime,Req_AskAddress,Req_Special,Req_AddTime,Req_Publish,Req_Shop,Req_ShopType,Req_Email,Req_IP,Req_Source,Req_Remind,Req_Userid,Req_inputName,Req_IsOpen,Req_IsGuest,Req_IsService,Req_IsLock,Req_Locktime,Req_LockMan,ucase,ucasetime,Req_CaseUsersid,Req_IsCase,Req_CaseTime,Req_IsDel,Req_FromWeb,Req_FromClass,Req_IsReg,Req_MessIntent,(select ClassName from [Pub_ConfigClass] sw where sw.C_ID=r.Req_Type) as sw_classname,(select ClassName from [Pub_ConfigClass] h where h.C_ID=r.Req_HouseType) as h_classname from [FC_Request] r where r.Req_IsDel=0 and Req_IsLock = 1 and Req_IsCase=0 and req_ID not in (0) and Req_city not in ('杭州') and Req_province in ('浙江') and Req_city in ('') order by Req_Publish desc