SET ROWCOUNT 0 SET DATEFORMAT dmy SELECT p.property_id,p.auction_id,p.lot_number,p.city,p.address_1,p.address_2,p.state,p.zip,p.sector_code,CONVERT(VARCHAR(10), p.guide_price_min)+' - '+CONVERT(VARCHAR(10), p.guide_price_max) AS guide_price,p.guide_price_symbol,p.result_price,available_at_price_min,available_at_price_max,CONVERT(decimal(5,2),p.yield) AS yield,p.status_code,a.date_1,a.date_2,sale_price_yield,byline,early,a.set_in_marketing,property_reference,sector_summary,lot_label FROM bpProperties p INNER JOIN bpAuctions a ON p.auction_id=a.auction_id WHERE a.auction_id = 119 AND ( (p.auction_id = 65 AND ((p.guide_price_max = 0 AND (p.guide_price_min >= 0 AND p.guide_price_min <= 999999999)) OR (p.guide_price_max > 0 AND (NOT (p.guide_price_min > 999999999) AND NOT (p.guide_price_max < 0))))) OR (NOT(p.auction_id = 65) AND (p.result_price >= 0 AND p.result_price <= 999999999)) ) ORDER BY CASE WHEN p.auction_id=65 THEN 0 ELSE 1 END DESC, date_1 DESC, lot_number ASC SET ROWCOUNT 0
By clicking the Submit button I confirm that I would like to get updates on this Property. Please email me updates when they are published.
If you have a query, please fill in the box below, otherwise click the Submit button.
We will keep you updated about lot xthis property.
In the meantime, if you would like to speak to the Surveyor about this property, please call on .
Are you sure you want to remove this property from your Watch List?
Are you sure you are no longer interested in this property?
Are you sure you want to delete your Account?
The guide is an indication of the minimum price at which the seller may be prepared to sell at the date the guide is published. If a guide range is provided, it represents a price bracket within which the seller may consider selling. The guide may be subject to change up to the time of the auction.
The guide does not include either VAT which may apply to the sale or other amounts the seller may charge. The seller’s Special Conditions of Sale and addendum if any, will state whether there are other seller’s charges and whether the seller has elected to charge VAT on the sale price.
The reserve is the minimum price acceptable to the seller and the price below which the auctioneer cannot sell. The reserve may be subject to change up to the time of the auction.
This is the price at which the property is sold.
Guide yield – The rent reserved divided by the guide.
Sale price yield – The rent reserved divided by the sale price plus standard purchaser’s costs including stamp duty.
Risk Profile info
Click here to set up a Property Profile in your online account (which covers all your buying criteria, ie location, type of property, price), we are able to notify you of properties for sale that match your requirements the moment they are entered into the auction or become available for sale.
This is the addendum that will form part of the contract of sale and the buyer buys with knowledge of it