SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NE63 8XP' order by fulladdress
NE63 8XP - 371,000
- Freehold Detached house
NE63 8XP - 261,000
- Leasehold Detached property
NE63 8XP - 293,000
- Leasehold Detached house
NE63 8XP - 229,000
- Freehold Detached house
NE63 8XP - 259,000
- Leasehold Detached house
NE63 8XP - 293,000
- Leasehold Detached property
NE63 8XP - 300,000
- Leasehold Detached house
NE63 8XP - 254,000
- Freehold Detached house
NE63 8XP - 291,000
- Freehold Detached house
NE63 8XP - 299,000
- Leasehold Detached house
NE63 8XP - 335,000
- Freehold Detached house
NE63 8XP - 352,000
- Freehold Detached house
NE63 8XP - 288,000
- Leasehold Detached bungalow
NE63 8XP - 204,000
- Leasehold Semi-detached house
NE63 8XP - 201,000
- Leasehold Semi-detached house
NE63 8XP - 208,000
- Freehold Semi-detached house
NE63 8XP - 209,000
- Leasehold Semi-detached house
NE63 8XP - 207,000
- Leasehold Semi-detached house
NE63 8XP - 202,000
- Leasehold Semi-detached house
NE63 8XP - 313,000
- Leasehold Detached house
NE63 8XP - 325,000
- Leasehold Detached house
NE63 8XP - 320,000
- Leasehold Detached property
NE63 8XP - 327,000
- Freehold Detached house
NE63 8XP - 334,000
- Freehold Detached house
NE63 8XP - 270,000
- Freehold Detached property
NE63 8XP - 254,000
- Leasehold Detached house
NE63 8XP - 266,000
- Freehold Detached house
NE63 8XP - 250,000
- Leasehold Detached house
NE63 8XP - 267,000
- Freehold Detached house
NE63 8XP - 282,000
- Freehold Detached house
