SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG42 3SJ' order by fulladdress
RG42 3SJ - 539,000
- Freehold Detached house
RG42 3SJ - 300,000
- Leasehold Purpose built flat
RG42 3SJ - 297,000
- Leasehold Purpose built flat
RG42 3SJ - 297,000
- Leasehold Purpose built flat
RG42 3SJ - 317,000
- Leasehold Purpose built flat
RG42 3SJ - 331,000
- Leasehold Purpose built flat
RG42 3SJ - 296,000
- Leasehold Flat/Maisonette
RG42 3SJ - 540,000
- Freehold Detached house
RG42 3SJ - 541,000
- Freehold Detached house
RG42 3SJ - 650,000
- Freehold Detached house
RG42 3SJ - 754,000
- Freehold Detached house
RG42 3SJ - 552,000
- Freehold Detached house
RG42 3SJ - 555,000
- Freehold Detached house
RG42 3SJ - 509,000
- Freehold Semi-detached house
RG42 3SJ - 368,000
- Freehold Purpose built flat
RG42 3SJ - 513,000
- Freehold Semi-detached house
RG42 3SJ - 542,000
- Freehold Detached house
RG42 3SJ - 881,000
- Freehold Detached house
RG42 3SJ - 338,000
- Leasehold Purpose built flat
RG42 3SJ - 323,000
- Share of freehold Purpose built flat
RG42 3SJ - 322,000
- Leasehold Purpose built flat
RG42 3SJ - 781,000
- Freehold Detached house
RG42 3SJ - 771,000
- Freehold Detached house
RG42 3SJ - 779,000
- Freehold Detached house
RG42 3SJ - 738,000
- Freehold Detached house
RG42 3SJ - 740,000
- Freehold Detached house
RG42 3SJ - 313,000
- Leasehold Purpose built flat
RG42 3SJ - 782,000
- Freehold Detached house
RG42 3SJ - 808,000
- Freehold Detached house
RG42 3SJ - 778,000
- Freehold Detached house
RG42 3SJ - 784,000
- Freehold Detached house
RG42 3SJ - 780,000
- Freehold Detached house
RG42 3SJ - 781,000
- Freehold Detached house
RG42 3SJ - 327,000
- Leasehold Flat/Maisonette
RG42 3SJ - 315,000
- Leasehold Purpose built flat
RG42 3SJ - 545,000
- Freehold Detached house
RG42 3SJ - 320,000
- Freehold Purpose built flat
RG42 3SJ - 775,000
- Freehold Detached house
RG42 3SJ - 706,000
- Freehold Detached house
RG42 3SJ - 745,000
- Freehold Detached house
RG42 3SJ - 781,000
- Freehold Detached house
RG42 3SJ - 766,000
- Freehold Detached house
RG42 3SJ - 701,000
- Freehold Detached house
RG42 3SJ - 532,000
- Freehold Detached house