Brown Harris Stevens
Sorry, an error occured while processing this request. Please try again in a few minutes.
System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 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, String srcTable) at BHS.V23.Core.PropertyDetails(Int32 listingNumber, String print, String ClosedListing, String PhotoDemo) ClientConnectionId:1a45df7f-2a30-47ec-b92a-b6c2c6c2b1ad Error Number:1205,State:52,Class:13All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any description. All measurements and square footages are approximate and all descriptive information should be confirmed by customer. All rights to content, photographs and graphics are reserved to Brown Harris Stevens. Customer should consult with its counsel regarding all closing and tax costs. Broker represents the seller/owner on Broker's own exclusives, except if another agent of Broker represents the buyer/tenant, in which case Broker will be a dual agent, in Connecticut, or , in New York State and New Jersey, a dual agent with designated or disclosed agents representing seller/owner and buyer/tenant. Broker represents the buyer/tenant when showing the exclusives of other real estate firms. In Florida, Broker acts as a Transaction Broker with all sellers and buyers, unless a different form of agency has been established in writing. If you are looking to purchase or rent housing, are using a screen reader, and are having problems using this website, please call 1-212-712-1163 for assistance. All phone charges will be reimbursed by Brown Harris Stevens. Broker actively supports Fair Housing and Equal Housing Opportunities. BHS has adopted the attached policy statement - Prior to showing a homebuyer a property or providing services: (1) BHS does not require identification from a prospective homebuyer, (2) BHS may require a written agreement from a homebuyer before showing properties; and (3) BHS does not require a pre-approval for a mortgage loan in order to show a homebuyer properties. However, based upon the requirements of the seller, the building in which the properties is located, or others, some or all of the foregoing items may be required. Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York's Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer's personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. 2025 The Real Estate Board of New York, Inc., all rights reserved. RLS Data display by Brown Harris Stevens. Powered by Terra Holdings.
