SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NP16 6DR' order by fulladdress
NP16 6DR - 269,000
- Leasehold Purpose built flat
NP16 6DR - 562,000
- Freehold Detached house
NP16 6DR - 364,000
- Freehold Semi-detached house
NP16 6DR - 351,000
- Freehold Semi-detached house
NP16 6DR - 333,000
- Freehold End terrace house
NP16 6DR - 448,000
- Freehold Detached house
NP16 6DR - 381,000
- Freehold Mid terrace house
NP16 6DR - 498,000
- Freehold Detached house
NP16 6DR - 550,000
- Freehold Detached house
NP16 6DR - 535,000
- Freehold Detached house
NP16 6DR - 239,000
- Leasehold Detached house
NP16 6DR - 317,000
- Freehold End terrace house
NP16 6DR - 382,000
- Freehold Mid terrace house
NP16 6DR - 429,000
- Freehold End terrace house
NP16 6DR - 574,000
- Freehold Detached house
NP16 6DR - 582,000
- Freehold Detached house
NP16 6DR - 551,000
- Freehold Detached property
NP16 6DR - 209,000
- Leasehold Flat/Maisonette
NP16 6DR - 207,000
- Leasehold Purpose built flat
NP16 6DR - 545,000
- Freehold Detached house
NP16 6DR - 370,000
- Freehold Semi-detached house
NP16 6DR - 548,000
- Freehold Detached property
NP16 6DR - 666,000
- Freehold Detached property
NP16 6DR - 598,000
- Freehold Detached house
NP16 6DR - 280,000
- Freehold End terrace house
NP16 6DR - 372,000
- Freehold Terrace property
NP16 6DR - 430,000
- Freehold Mid terrace house
NP16 6DR - 568,000
- Freehold Detached house
NP16 6DR - 548,000
- Freehold Detached house
NP16 6DR - 374,000
- Freehold Semi-detached property
NP16 6DR - 405,000
- Freehold Terrace property
NP16 6DR - 539,000
- Freehold Detached house
NP16 6DR - 448,000
- Freehold End terrace house
NP16 6DR - 384,000
- Freehold Semi-detached house
NP16 6DR - 337,000
- Freehold Mid terrace house
NP16 6DR - 546,000
- Freehold Detached house
NP16 6DR - 209,000
- Leasehold Purpose built flat
NP16 6DR - 546,000
- Freehold Detached bungalow
NP16 6DR - 421,000
- Freehold Terrace property
NP16 6DR - 372,000
- Freehold Mid terrace house
NP16 6DR - 374,000
- Freehold End terrace house
NP16 6DR - 566,000
- Freehold Detached property
NP16 6DR - 317,000
- Freehold Semi-detached house
NP16 6DR - 423,000
- Freehold Semi-detached house
NP16 6DR - 228,000
- Leasehold Detached house
NP16 6DR - 226,000
- Leasehold Detached house
NP16 6DR - 438,000
- Freehold End terrace house
NP16 6DR - 367,000
- Freehold Terrace property
NP16 6DR - 371,000
- Freehold Mid terrace house
NP16 6DR - 338,000
- Freehold End terrace house
NP16 6DR - 196,000
- Leasehold Flat/Maisonette
NP16 6DR - 302,000
- Freehold Terrace property
NP16 6DR - 549,000
- Freehold Detached house
NP16 6DR - 313,000
- Freehold Mid terrace house
NP16 6DR - 365,000
- Freehold End terrace property
NP16 6DR - 342,000
- Freehold Mid terrace house
NP16 6DR - 466,000
- Freehold Mid terrace house
NP16 6DR - 456,000
- Freehold Semi-detached house