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 3ET' order by fulladdress
Job

19 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 799,000
  • Flat/Maisonette
Job

24 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 0
  • Freehold Flat/Maisonette
Job

25 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 0
  • Freehold Terrace property
Job

25A LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 515,000
  • Flat/Maisonette
Job

26 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 0
  • Freehold Flat/Maisonette
Job

27 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 1,141,000
  • Freehold Flat/Maisonette
Job

28A LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 589,000
  • Leasehold Purpose built flat
Job

32 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 735,000
  • Flat/Maisonette
Job

32A LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 2,178,000
  • Freehold Terraced
Job

34 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 557,000
  • Flat/Maisonette
Job

FLAT 1 33 LEINSTER TERRACE LONDON W2 3ET

W2 3ET
  • 546,000
  • Leasehold Converted flat

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications