SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='MK4 1HD' order by fulladdress
MK4 1HD - 502,000
- Freehold Detached house
MK4 1HD - 1,108,000
- Freehold Detached house
MK4 1HD - 420,000
- Freehold Detached house
MK4 1HD - 503,000
- Freehold Semi-detached property
MK4 1HD - 395,000
- Freehold Semi-detached property
MK4 1HD - 416,000
- Freehold Detached house
MK4 1HD - 324,000
- Freehold End terrace house
MK4 1HD - 492,000
- Freehold Detached property
MK4 1HD - 258,000
- Freehold Mid terrace house
MK4 1HD - 143,000
- Leasehold Flat/Maisonette
MK4 1HD - 153,000
- Leasehold Purpose built flat
MK4 1HD - 155,000
- Leasehold Purpose built flat
MK4 1HD - 206,000
- Freehold End terrace house
MK4 1HD - 236,000
- Freehold Semi-detached house
MK4 1HD - 338,000
- Freehold Terrace property
MK4 1HD - 235,000
- Freehold Semi-detached house
MK4 1HD - 466,000
- Freehold Detached house
MK4 1HD - 158,000
- Leasehold Purpose built flat
MK4 1HD - 266,000
- Freehold Mid terrace house
MK4 1HD - 261,000
- Freehold Mid terrace house
MK4 1HD - 164,000
- Leasehold Purpose built flat
MK4 1HD - 168,000
- Leasehold Purpose built flat
MK4 1HD - 153,000
- Leasehold Flat/Maisonette
MK4 1HD - 203,000
- Freehold Mid terrace house
MK4 1HD - 206,000
- Freehold Mid terrace house
MK4 1HD - 555,000
- Freehold Detached house
MK4 1HD - 214,000
- Freehold Terrace property
MK4 1HD - 185,000
- Freehold Terrace property
MK4 1HD - 160,000
- Leasehold Purpose built flat
MK4 1HD - 163,000
- Leasehold Flat/Maisonette
MK4 1HD - 195,000
- Leasehold Mid terrace house
MK4 1HD - 249,000
- Freehold Mid terrace house
MK4 1HD - 309,000
- Freehold End terrace house
MK4 1HD - 875,000
- Freehold Detached house
MK4 1HD - 826,000
- Freehold Detached house
MK4 1HD - 532,000
- Freehold Detached house
MK4 1HD - 853,000
- Freehold Detached house
MK4 1HD - 825,000
- Freehold Detached house
MK4 1HD - 848,000
- Freehold Detached house
MK4 1HD - 941,000
- Freehold Detached house
MK4 1HD - 791,000
- Freehold Detached house
MK4 1HD - 819,000
- Freehold Detached house
MK4 1HD - 758,000
- Freehold Detached house
MK4 1HD - 689,000
- Freehold Detached house
MK4 1HD - 872,000
- Freehold Detached house
MK4 1HD - 907,000
- Freehold Detached house