SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PO38 3EA' order by fulladdress
PO38 3EA - 310,000
- Freehold Semi-detached house
PO38 3EA - 452,000
- Freehold Detached house
PO38 3EA - 291,000
- Freehold Semi-detached house
PO38 3EA - 265,000
- Leasehold Semi-detached house
PO38 3EA - 290,000
- Freehold Semi-detached house
PO38 3EA - 338,000
- Freehold Semi-detached house
PO38 3EA - 336,000
- Freehold Detached bungalow
PO38 3EA - 324,000
- Freehold Detached bungalow
PO38 3EA - 364,000
- Freehold Detached bungalow
PO38 3EA - 242,000
- Freehold End terrace house
PO38 3EA - 240,000
- Freehold Mid terrace house
PO38 3EA - 314,000
- Freehold Semi-detached house
PO38 3EA - 373,000
- Freehold Detached property
PO38 3EA - 260,000
- Freehold End terrace house
PO38 3EA - 362,000
- Freehold Detached bungalow
PO38 3EA - 327,000
- Freehold Detached bungalow
PO38 3EA - 319,000
- Freehold Detached bungalow
PO38 3EA - 365,000
- Freehold Detached bungalow
PO38 3EA - 342,000
- Freehold Detached bungalow
PO38 3EA - 239,000
- Leasehold Semi-detached property
PO38 3EA - 365,000
- Freehold Detached property
PO38 3EA - 306,000
- Freehold Semi-detached bungalow
PO38 3EA - 341,000
- Freehold Detached bungalow
PO38 3EA - 323,000
- Leasehold Detached bungalow
PO38 3EA - 361,000
- Freehold Detached bungalow
PO38 3EA - 329,000
- Freehold Detached bungalow
PO38 3EA - 297,000
- Freehold Semi-detached house
PO38 3EA - 366,000
- Freehold Detached bungalow
PO38 3EA - 340,000
- Freehold Detached house
PO38 3EA - 507,000
- Freehold Detached house
PO38 3EA - 342,000
- Freehold Detached bungalow
PO38 3EA - 344,000
- Freehold Detached property
PO38 3EA - 302,000
- Freehold Semi-detached house
PO38 3EA - 367,000
- Freehold Detached bungalow
PO38 3EA - 380,000
- Freehold Detached property
PO38 3EA - 393,000
- Freehold Detached property
PO38 3EA - 316,000
- Freehold Semi-detached house
PO38 3EA - 154,000
- Leasehold Purpose built flat
