select top 20 Hd_CountyID_FK, Hd_LocalID_FK, Hd_Address, Hd_ShowAddress, Hd_AdvAddress,Hd_Longitude, Hd_Latitude, Hd_ImageStr,Hd_Price_Real,Hd_Price_Show,Hd_ImagePath,Hd_HouseArea,Hd_HouseArea_Show, Hd_Price_Unit, Hd_ObjID, Hd_UpdateTime, a.Ct_CountyName as CountyName, b.Lo_LocalName as Lo_LocalName from SF_HouseData left join SF_Address_County as a on a.Ct_CountyId = Hd_CountyID_FK left join SF_Address_Local as b on b.Lo_LocalId=Hd_LocalID_FK where Hd_ObjID is not null and Hd_ObjID not in (select TOP 0 Hd_ObjID from SF_HouseData where Hd_ObjID is not null and Hd_TradeType = 1 and hd_pay=1 and hd_display=1 and Hd_CountyID_FK=1 and dbo.fnGetDistance(121.563752146032700,25.037512898096512,Hd_Longitude, Hd_Latitude) <=2 order by Hd_updatetime desc) and Hd_TradeType = 1 and hd_pay=1 and hd_display=1 and Hd_CountyID_FK=1 and dbo.fnGetDistance(121.563752146032700,25.037512898096512,Hd_Longitude, Hd_Latitude) <=2 order by Hd_updatetime desc
System.Data.SqlClient.SqlException: Error converting data type varchar to real. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Database.GetDataSet(String cmdText, CommandType cmdType) at Database.GetDataTable(String cmdText, CommandType cmdType) at SearchShowObject.GetData(Int32 iCurrentPage) 台北市政府地標找屋-租屋類住宅地標找屋,雅房地標找屋,套房地標找屋,商辦地標找屋分析系統1.0 專利申請字號097143668
台灣租屋網Logo
1.地標機制採開放式管理,網友可自建新的地標,屋主可自行取用加以設定,而查詢的網友則可點選地標加以讀取讓地標所屬的房屋清單,目前資料庫中共有 541 個地標。
2.地標編輯小組會盡力核對地標的正確性,但並不保證所有地標或屋主的地標選取能正確無誤。
所有類別 > 政府機關、公共事業、醫院 > 台北市政府 >>返回地標查詢頁
台北市政府個鄰近的房子出租