Selected Property

SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W2 2NR' order by fulladdress
Job

1 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,036,000
Job

10 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,857,000
  • Freehold Mid terrace house
Job

11 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,603,000
  • End terrace house
Job

12 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,849,000
Job

14 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,580,000
  • Freehold Mid terrace house
Job

15 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,935,000
Job

16 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,855,000
  • Freehold Mid terrace house
Job

17 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,215,000
  • Freehold Terrace property
Job

2 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,033,000
Job

3 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,975,000
Job

4 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,934,000
Job

5 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 2,157,000
  • Freehold Mid terrace house
Job

6 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,849,000
  • Freehold Mid terrace house
Job

7 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,689,000
  • Freehold Terrace property
Job

8 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,757,000
  • Freehold Mid terrace house
Job

9 CLARENDON MEWS LONDON W2 2NR

W2 2NR
  • 1,893,000

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications