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

72-74 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,929,000
Job

75 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,094,000
  • Flat/Maisonette
Job

76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,932,000
  • Flat/Maisonette
Job

77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,526,000
Job

78 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,304,000
  • Leasehold Flat/Maisonette
Job

79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,570,000
  • Share of freehold Flat/Maisonette
Job

80 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,162,000
  • Flat/Maisonette
Job

81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,041,000
  • Share of freehold Flat/Maisonette
Job

82 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,699,000
  • Leasehold Flat/Maisonette
Job

83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,489,000
  • Share of freehold Flat/Maisonette
Job

84 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,246,000
  • Flat/Maisonette
Job

85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,996,000
  • Leasehold Flat/Maisonette
Job

86 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,105,000
  • Share of freehold Flat/Maisonette
Job

87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,708,000
  • Mid terrace house
Job

88 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,181,000
Job

88A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,989,000
Job

89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,046,000
Job

APARTMENT 1 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 1 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 1 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,002,000
Job

APARTMENT 1 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,481,000
Job

APARTMENT 1 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,434,000
Job

APARTMENT 1 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 1 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,510,000
Job

APARTMENT 10 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 10 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,745,000
Job

APARTMENT 10 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,510,000
Job

APARTMENT 11 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 11 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,643,000
Job

APARTMENT 2 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,515,000
Job

APARTMENT 2 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 2 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,806,000
Job

APARTMENT 2 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,948,000
Job

APARTMENT 2 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,954,000
Job

APARTMENT 2 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,693,000
Job

APARTMENT 2 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,880,000
Job

APARTMENT 3 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,515,000
Job

APARTMENT 3 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 3 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 3 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,917,000
Job

APARTMENT 3 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,955,000
Job

APARTMENT 3 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,510,000
Job

APARTMENT 3 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,510,000
Job

APARTMENT 4 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 4 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 4 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 4 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,930,000
Job

APARTMENT 4 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,405,000
Job

APARTMENT 4 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 6,397,000
Job

APARTMENT 4 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 6,160,000
Job

APARTMENT 5 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 5 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 5 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,910,000
Job

APARTMENT 5 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,234,000
Job

APARTMENT 5 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 5,017,000
Job

APARTMENT 5 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,753,000
Job

APARTMENT 5 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,994,000
Job

APARTMENT 6 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 6 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 6 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 6 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,466,000
Job

APARTMENT 6 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,959,000
Job

APARTMENT 6 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,510,000
Job

APARTMENT 6 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,969,000
Job

APARTMENT 7 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 7 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 7 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 7 83 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,969,000
Job

APARTMENT 7 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,724,000
Job

APARTMENT 7 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,994,000
Job

APARTMENT 7 89 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,011,000
Job

APARTMENT 8 77 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

APARTMENT 8 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 8 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 8 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 4,278,000
Job

APARTMENT 8 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,910,000
Job

APARTMENT 80A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,484,000
  • Leasehold Flat/Maisonette
Job

APARTMENT 82A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,379,000
Job

APARTMENT 84A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,329,000
  • Leasehold Flat/Maisonette
Job

APARTMENT 86A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,507,000
  • Leasehold Flat/Maisonette
Job

APARTMENT 9 79 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 0
Job

APARTMENT 9 81 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,517,000
Job

APARTMENT 9 85 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 6,168,000
Job

APARTMENT 9 87 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 2,939,000
Job

BASEMENT APARTMENT 78A LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,320,000
  • Leasehold Purpose built flat
Job

FIRST FLOOR 76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

GROUND FLOOR 76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

LOWER GROUND FLOOR 76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

PITCH 134 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 135 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 136 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 137 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 138 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 139 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 140 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 141 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 142 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 143 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 144 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 145 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 146 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 147 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 148 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 149 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 150 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 151 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 152 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 153 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 154 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 155 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 156 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 157 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 158 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 159 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 160 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 161 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 162 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 163 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 164 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

PITCH 165 BAYSWATER ROAD LONDON W2 3NH

W2 3NH
  • 0
Job

SECOND FLOOR 76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 1,520,000
Job

SECOND FLOOR MAISONETTE 76 LANCASTER GATE LONDON W2 3NH

W2 3NH
  • 3,335,000

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications