SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU1 1FY' order by fulladdress
GU1 1FY - 304,000
- Leasehold Flat/Maisonette
GU1 1FY - 281,000
- Leasehold Purpose built flat
GU1 1FY - 270,000
- Leasehold Purpose built flat
GU1 1FY - 246,000
- Leasehold Purpose built flat
GU1 1FY - 296,000
- Leasehold Flat/Maisonette
GU1 1FY - 384,000
- Leasehold Purpose built flat
GU1 1FY - 401,000
- Leasehold Flat/Maisonette
GU1 1FY - 360,000
- Leasehold Flat/Maisonette
GU1 1FY - 347,000
- Leasehold Flat/Maisonette
GU1 1FY - 359,000
- Leasehold Flat/Maisonette
GU1 1FY - 357,000
- Leasehold Flat/Maisonette
GU1 1FY - 367,000
- Leasehold Flat/Maisonette
GU1 1FY - 355,000
- Leasehold Flat/Maisonette
GU1 1FY - 373,000
- Leasehold Flat/Maisonette
GU1 1FY - 352,000
- Leasehold Flat/Maisonette
GU1 1FY - 265,000
- Leasehold Purpose built flat
GU1 1FY - 287,000
- Leasehold Purpose built flat
GU1 1FY - 256,000
- Leasehold Purpose built flat
GU1 1FY - 275,000
- Leasehold Flat/Maisonette
GU1 1FY - 247,000
- Leasehold Flat/Maisonette
GU1 1FY - 249,000
- Leasehold Flat/Maisonette
GU1 1FY - 344,000
- Leasehold Flat/Maisonette
GU1 1FY - 303,000
- Leasehold Flat/Maisonette
GU1 1FY - 374,000
- Leasehold Flat/Maisonette
GU1 1FY - 348,000
- Leasehold Flat/Maisonette
GU1 1FY - 362,000
- Leasehold Flat/Maisonette
GU1 1FY - 353,000
- Leasehold Flat/Maisonette
GU1 1FY - 381,000
- Leasehold Converted flat
GU1 1FY - 358,000
- Leasehold Flat/Maisonette
GU1 1FY - 337,000
- Leasehold Flat/Maisonette
GU1 1FY - 364,000
- Leasehold Flat/Maisonette
GU1 1FY - 360,000
- Leasehold Flat/Maisonette
GU1 1FY - 353,000
- Leasehold Flat/Maisonette
GU1 1FY - 253,000
- Leasehold Flat/Maisonette
GU1 1FY - 247,000
- Leasehold Flat/Maisonette
GU1 1FY - 284,000
- Leasehold Flat/Maisonette
GU1 1FY - 245,000
- Leasehold Flat/Maisonette
GU1 1FY - 297,000
- Leasehold Flat/Maisonette
GU1 1FY - 266,000
- Leasehold Flat/Maisonette
GU1 1FY - 276,000
- Leasehold Flat/Maisonette
GU1 1FY - 346,000
- Leasehold Flat/Maisonette
GU1 1FY - 516,000
- Leasehold Flat/Maisonette
GU1 1FY - 408,000
- Leasehold Flat/Maisonette
GU1 1FY - 347,000
- Leasehold Flat/Maisonette
GU1 1FY - 414,000
- Leasehold Purpose built flat
GU1 1FY - 205,000
- Leasehold Flat/Maisonette
GU1 1FY - 348,000
- Leasehold Purpose built flat
GU1 1FY - 311,000
- Leasehold Purpose built flat
GU1 1FY - 310,000
- Leasehold Flat/Maisonette
GU1 1FY - 149,000
- Leasehold Purpose built flat
GU1 1FY - 278,000
- Leasehold Flat/Maisonette
GU1 1FY - 201,000
- Leasehold Purpose built flat
GU1 1FY - 304,000
- Leasehold Flat/Maisonette
GU1 1FY - 251,000
- Leasehold Purpose built flat
GU1 1FY - 130,000
- Leasehold Flat/Maisonette
GU1 1FY - 165,000
- Leasehold Purpose built flat
GU1 1FY - 365,000
- Leasehold Flat/Maisonette
GU1 1FY - 171,000
- Leasehold Flat/Maisonette
GU1 1FY - 221,000
- Feudal Purpose built flat
GU1 1FY - 187,000
- Leasehold Purpose built flat
GU1 1FY - 352,000
- Leasehold Flat/Maisonette
GU1 1FY - 257,000
- Leasehold Flat/Maisonette