[imgLogo]

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_HITS_PROPERTY". The conflict occurred in database "SF_WEBDB", table "dbo.Property", column 'ID'. The statement has been terminated.
Back to top

Need a mortgage?

Back to search results

Print property details

Arrange a viewing

Last Properties Viewed

Conditions:

These particulars do not constitute an offer or contract or any part thereof and none of the statements contained in the particulars as to the property is to be relied on as a statement or representation of fact
The vendor does not make or give, nor is the Agent(s) or its staff authorized to make or give any representation or warranty in respect of this property
All descriptions, dimensions, references to condition and necessary permission for use and occupation, and other details are given in good faith and are believed to be correct but any intending purchaser or tenant should not rely on them as statements or representations of fact but must satisfy himself/herself by inspection or otherwise as to the correctness of each of them
In the event of any inconsistency between these particulars and the contract of sale, the latter shall prevail.
The terms, Vendor and Purchaser, where the context requires shall be deemed to refer to Lessor and Lessee and Landlord and Tenant respectively.