Washington Ultimate

By shrijeetverma13 · April 8, 2026

This dataset captures 12,017 verified sold properties across the state of Washington, the Pacific coast, eastern Washington farmland, and everything in…

The bar chart shows how median last sold prices vary by the decade in which properties were built. Each bar represents a decade (e.g., 1950s, 1960s, etc.) with the sample size labeled on top, giving you a clear picture of both price levels and data coverage across different eras of construction.

The analysis identified the top 10 zip codes with the highest median last sold prices, representing the most premium real estate markets in the dataset. A bar chart has been generated showing each zip code ranked by its median sale price, with color intensity indicating relative price levels.

A chart and data table were generated showing the median last sold price and median price per square foot broken down by number of bedrooms. The bar chart displays median sold prices alongside a line tracking median $/sqft for each bedroom configuration, making it easy to compare value across different home sizes.

Interestingly, homes without a garage actually sell for MORE than homes with a garage. The median last sold price for homes with a garage is $489,803, while homes without a garage have a higher median of $599,592 — a difference of $109,789. This means having a garage is associated with an 18.3% lower price, not a premium. A bar chart has been generated to visually compare these two groups.

The analysis produced a chart and data table showing how the number of stories (1–4) relates to median last sold price and median price per square foot. The dual-axis chart displays bars for median sold price and a red line for price per sqft across story counts, making it easy to compare both metrics at a glance.

The bar chart shows the top 20 zip codes with the highest average list-to-sold ratios, revealing where homes are selling above or near their list price — a strong indicator of competitive bidding wars. Zip codes with ratios above 1.0 (the green dashed line) are markets where buyers are consistently paying more than the asking price.

The analysis identified the top 15 zip codes commanding the highest median price per square foot. A horizontal bar chart and supporting data tables were generated, clearly ranking each zip code from highest to lowest median price per sqft.

The analysis produced a side-by-side bar chart and data table comparing median last sold price and median price per square foot across different property types. The visualization clearly shows how each property type ranks in terms of both overall sale value and price efficiency (per square foot).

The bar chart shows the average list-to-sold ratio for each property type, with a dashed line at 1.0 representing the asking price. Bars shown in green indicate property types that sell above asking price (ratio 1.0), while red bars indicate those that sell below asking price (ratio < 1.0). The visualization makes it easy to see which property types are most in-demand versus those where buyers negotiate discounts.

The analysis identified 65 zip codes that signal undervalued rising markets — those with below-median price per square foot (under $316) and above-median list-to-sold ratios (above 0.9912). Two visualizations were generated to help explore these markets.

The analysis produced a stacked bar chart and supporting tables showing how different property types are distributed across the 10 highest-volume zip codes in the dataset. The chart displays each zip code on the x-axis, with bars color-coded by property type, making it easy to compare the mix of property types within and across zip codes.

Recently built properties (2015 or newer) sell for significantly more than older ones. The median sale price for recent homes is $674,944 compared to $544,930 for older homes — a difference of about $130,000, or 23.9% more. Looking at average prices, recent homes average $824,172 vs. $655,222 for older ones, a gap of $128,950 (+18.5%). A box plot visualization has been generated showing the full price distribution for both groups.

The analysis identified the most affordable zip codes for investment based on median last sold price, filtering for areas with at least 50 transactions to ensure reliability. A bar chart and supporting data tables have been generated showing the top 15 most affordable zip codes ranked by median sale price.

The analysis produced a bar chart ranking property types by their average list-to-sold ratio. Property types with ratios below 1.0 indicate systematic overpricing — sellers listed those properties above what buyers ultimately paid. The chart uses a red-to-green color scale, making it easy to spot the most overpriced types (shown in red) versus fairly priced ones (shown in green). A dashed reference line at 1.0 marks the 'fair pricing' threshold.

The grouped bar chart and pivot table show median last sold prices across four square footage quartiles (Q1: 120–1,340 sqft up to Q4: 2,440–29,680 sqft) for each property type. As expected, prices generally rise with size across most property types. Single-family homes go from $417K in Q1 to $920K in Q4, condos jump from $370K to $1.49M, and townhomes climb from $577K to $1.56M. Multi-family properties also increase steadily from $367K to $765K.

Yes, smaller homes (under 1,500 sqft) generally achieve higher price per square foot — but it depends on the property type. Across 6 property types analyzed, 4 showed smaller homes commanding a premium, while 2 did not. Two bar charts and detailed data tables were generated to visualize these comparisons.

The analysis examined 517 top 5% priced properties (list price ≥ $1,664,062) and compared their characteristics to the overall market. A bar chart and box plot were generated showing how these luxury properties compare across key metrics, along with detailed data tables. Top 5% properties are significantly larger in square footage, tend to have more beds and baths, and may differ in build year compared to the overall market average.

Yes, a higher baths-to-beds ratio does correlate with higher price per square foot, but the relationship is weak. Across 10,795 properties, the Pearson correlation coefficient is 0.211, indicating a weak positive link between the two variables. A scatter plot with a trend line and a bar chart showing average price per sqft by ratio range were both generated to visualize this relationship.