We've tightened what earns a Pursue. A home now needs a published valuation, a strategy that still makes money after real running costs and lender stress tests, and no listing problems that would stop a mortgage. You'll see fewer Pursues, and each one has been checked harder.
See how verdicts work2-bedroom flat · TD12 4AS
For saleListed today
Opportunity summary
See Archie’s verdict, returns by strategy and what to check before viewing.
About
A delightful first-floor Victorian flat, full of original character and charm.
This spacious two-bedroom property offers versatile accommodation, including a generous kitchen/dining room that could easily be used as a kitchen/living space, allowing the existing living room to be used as a third bedroom.
The property benefits from gas central heating, a fitted kitchen and a bathroom with a shower over the bath.
Period features include the original Victorian tenement entry system, sash and case windows, high ceilings and solid four-panel doors complete with original-style doorknobs and panels.
The living room features an impressive bay window, while the dining area boasts a beautiful cast-iron fireplace.
To the rear, the property enjoys fantastic open views across the rooftops towards the Cheviot Hills.
Bright, spacious and full of character, this charming flat would make an ideal first home or holiday retreat.
LOCATION Ideally situated in the heart of Coldstream, one of the first border towns in Scotland, this location offers an appealing blend of convenience, character and beautiful surrounding countryside.
Steeped in history, Coldstream was once home to the Earl of Home, with the historic Hirsel estate providing a wonderful destination just a short distance from the town.
The Hirsel is particularly popular for its scenic walks, abundant wildlife and peaceful countryside, as well as its welcoming cafe and collection of independent craft shops.
The River Tweed also forms an important part of the local landscape, renowned for its salmon fishing and providing a picturesque setting for enjoying the outdoors.
Coldstream itself provides an excellent range of everyday amenities, including local shops, cafes, traditional pubs, a community centre, doctors’ and dentists’ surgeries and other useful services.
Its position close to the Scottish Borders also makes it an attractive base for exploring the wider area, with the Cheviot Hills and surrounding countryside offering plentiful opportunities for walking, cycling and outdoor pursuits.
For those requiring further amenities and transport connections, the historic market town of Kelso is approximately 9 miles away, while Berwick-upon-Tweed and its East Coast railway station are approximately 15 miles away, providing convenient links further afield.
Together, these nearby towns complement Coldstream’s quieter pace of life while ensuring that a broader range of shopping, leisure and transport facilities are within easy reach.
With its attractive setting, rich heritage, strong sense of community and excellent access to both countryside and neighbouring towns, Coldstream represents an appealing location for those seeking a relaxed Scottish Borders lifestyle without sacrificing everyday convenience.
ACCOMMODATION HALL (2.12M X 1.98M) LIVING ROOM (4.92M X 4.59M) into bay window KITCHEN / DINING ROOM (5.15M X 3.95M) at widest BATHROOM (2.76M X 1.43M) BEDROOM 1 (4.00M X 2.99M) BEDROOM 2 (2.69M X 1.99M) Interested In EXTERNALLY To the rear, the property benefits from its own garden area, situated beyond the gardens belonging to the flats above and below.
The garden can be accessed directly from the property, with a further exit down onto Duke Street.
Offering a blank canvas, this outdoor space presents an excellent opportunity to create a private haven for relaxing and entertaining.
The property also benefits from access to a shared basement storage area, which includes a dedicated individual storage areas belonging to each flat.
SERVICES Mains Electricity, Gas, Drainage and Water Council Tax: Band B EPC: Band C VIEWING By appointment with Melrose & Porteous SURVEY/ENTRY By mutual arrangement. Home report available.
Additional arrangements through agents Offers should be submitted to Melrose & Porteous, 47 Market Square, Duns, Berwickshire, TD11 3BX (DX 556 522 DUNS) Only those parties who have formally requested their interest may be advised of any closing date fixed for offers.
These particulars are for guidance only. All measurements were taken by a laser tape measure and may be subject to small discrepancies.
Although a high level of care has been taken to ensure these details are correct, no guarantees are given to the accuracy of the above information.
While the information is believed to be correct and accurate any potential purchaser must review the details themselves to ensure they are satisfied with our findings.
Value & comps
Land Registry doesn’t cover Scotland or Northern Ireland, so previous sales may not be on record.
Returns
Set an offer; the calculator follows it.
Short-let licence or registration needed
We're still gathering serviced-accommodation data for this area.
Archie refurb estimate: a Pro feature
0.0% below asking
This is not financial or investment advice. Prop AI Deals is not authorised by the Financial Conduct Authority (FCA) to provide investment advice.
All investment calculators, property analyses, and AI-generated insights are for informational purposes only. Property investment carries risk and may result in financial loss. All calculations should be independently verified and you should consult with FCA-authorised financial advisers before making any investment decisions.
Past performance does not guarantee future results. Tax implications vary by individual circumstances.
Deal
Properties like this can earn 2–3x BTL yields when converted to HMO, with retrofit costs around £10k/room. Sign in to see the full tier, yield projection, and cost breakdown.
Commercial properties like this can earn 30-50% higher yields when converted to residential under Class MA / Q / P / PA, with prior approval costing ~GBP 96/unit. Sign in to see the recommended route, yield uplift, and cost breakdown.
BRRR-suited properties can recycle 80-100% of investor capital on refi, leaving a high-yielding rental with most of the money out. Sign in to see the refurb cost stack, ARV projection, and refinance maths.
Detached + large garden = sub-division play. Pro tier unlocks the tier badge, plot size, uplift estimate, and regional land benchmark.
Short-lease flats trade at deep discount, but extending under the 1993 Act often costs far less than the discount. Pro tier unlocks the tier badge, premium breakdown, long-lease ARV and arbitrage maths.
See projected short-stay revenue vs a vanilla BTL for this property.
See real sub-let margins (HMO room rates & SA nightly rates) vs the landlord rent.
Area
Agent & docs

FAQ
About Helensville, High Street, Coldstream, Scottish Borders
Explore nearby