SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NE3 2DZ' order by fulladdress
NE3 2DZ - 293,000
- Leasehold Flat/Maisonette
NE3 2DZ - 346,000
- Leasehold Flat/Maisonette
NE3 2DZ - 306,000
- Leasehold Flat/Maisonette
NE3 2DZ - 304,000
- Leasehold Flat/Maisonette
NE3 2DZ - 225,000
- Leasehold Purpose built flat
NE3 2DZ - 342,000
- Leasehold Flat/Maisonette
NE3 2DZ - 215,000
- Leasehold Purpose built flat
NE3 2DZ - 269,000
- Leasehold Flat/Maisonette
NE3 2DZ - 252,000
- Leasehold Flat/Maisonette
NE3 2DZ - 275,000
- Leasehold Flat/Maisonette
NE3 2DZ - 275,000
- Leasehold Purpose built flat
NE3 2DZ - 812,000
- Leasehold Detached house
NE3 2DZ - 840,000
- Leasehold Detached house
NE3 2DZ - 844,000
- Freehold Detached bungalow
NE3 2DZ - 832,000
- Leasehold Detached bungalow
NE3 2DZ - 848,000
- Leasehold Detached property
NE3 2DZ - 826,000
- Leasehold Detached property
NE3 2DZ - 285,000
- Leasehold Flat/Maisonette
NE3 2DZ - 781,000
- Freehold Detached house
NE3 2DZ - 746,000
- Freehold Detached bungalow
NE3 2DZ - 776,000
- Freehold Detached property
NE3 2DZ - 780,000
- Freehold Detached house
NE3 2DZ - 835,000
- Freehold Detached house
NE3 2DZ - 1,439,000
- Freehold Detached house
NE3 2DZ - 1,230,000
- Leasehold Detached house
NE3 2DZ - 1,179,000
- Freehold Detached house
NE3 2DZ - 746,000
- Freehold Detached bungalow
NE3 2DZ - 761,000
- Leasehold Detached property
NE3 2DZ - 1,080,000
- Freehold Detached house
NE3 2DZ - 227,000
- Leasehold Purpose built flat
NE3 2DZ - 1,383,000
- Freehold Detached house
NE3 2DZ - 1,100,000
- Freehold Detached house
NE3 2DZ - 1,150,000
- Freehold Detached house
NE3 2DZ - 861,000
- Freehold Detached house
NE3 2DZ - 869,000
- Leasehold Detached property
NE3 2DZ - 1,009,000
- Freehold Detached house
NE3 2DZ - 815,000
- Freehold Detached bungalow
NE3 2DZ - 209,000
- Leasehold Flat/Maisonette
NE3 2DZ - 246,000
- Leasehold Purpose built flat
NE3 2DZ - 214,000
- Leasehold Flat/Maisonette
NE3 2DZ - 255,000
- Leasehold Purpose built flat
NE3 2DZ - 285,000
- Leasehold Purpose built flat
NE3 2DZ - 242,000
- Leasehold Flat/Maisonette
NE3 2DZ - 387,000
- Leasehold Flat/Maisonette
NE3 2DZ - 182,000
- Leasehold Purpose built flat
NE3 2DZ - 317,000
- Leasehold Flat/Maisonette
NE3 2DZ - 309,000
- Leasehold Flat/Maisonette
NE3 2DZ - 236,000
- Leasehold Purpose built flat
NE3 2DZ - 410,000
- Leasehold Flat/Maisonette
NE3 2DZ - 346,000
- Leasehold Flat/Maisonette
NE3 2DZ - 296,000
- Leasehold Flat/Maisonette
NE3 2DZ - 180,000
- Leasehold Flat/Maisonette
NE3 2DZ - 221,000
- Leasehold Purpose built flat
NE3 2DZ - 320,000
- Leasehold Purpose built flat
NE3 2DZ - 351,000
- Leasehold Flat/Maisonette
NE3 2DZ - 294,000
- Leasehold Flat/Maisonette