# Real Estate Listings Sample Dataset: Free Property Data for Dashboards and SQL

> Free real estate sample dataset: property listings with type, bedrooms, area, price, city and status. Download as CSV, Excel, JSON or Parquet, no signup.

Page: https://datautility.in/blog/real-estate-listings-sample-dataset
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-15 · Create · real estate dataset csv, property listings data, real estate sample data, housing dataset sample, house listings csv

A property dashboard, a map demo or an SQL lesson needs listings with sizes, prices and statuses. Generate a real estate listings dataset in your browser and download it free.

Open the tool: [Data Generator](https://datautility.in/mock-data-generator)

## What is in the dataset

Property listings has a listing id, property type (Apartment, Detached house, Townhouse, Condo, Studio or Land), bedrooms, area in square feet, city, year built, price, listing status and listing date. You can choose from 10 rows to 500,000 in the Data Generator and download CSV, Excel, JSON or Parquet.

## Shapes that look right

Apartments are the most common type, and most homes have two or three bedrooms. Area follows a bell curve around 1,450 sq ft, so very small and very large homes are rare. Listing status is weighted: many are Active or Sold, and few are Withdrawn.

Price is generated independently from size, so a large house can be cheap. The data is good for charts, joins and filters but not for a price-prediction model. If you need price to follow size, add a calculated column in [Data Transformation](https://datautility.in/data-transformation), for example price per square foot as price divided by area, and use it for a sanity check.

## Questions to answer with it

Try: SELECT city, property_type, COUNT(*) AS listings, ROUND(AVG(price)) AS avg_price FROM property_listings WHERE listing_status = 'Active' GROUP BY city, property_type ORDER BY listings DESC; Run it in [SQL on Your Files](https://datautility.in/sql-on-your-files). Build a map or bar chart of listings by city, a pivot table of average price by bedrooms, or a filter for listings older than 90 days.

## What to use it for

Use it to demo a real estate app, practise pivot tables and SQL, test an import, or prototype a search filter. For more practice sets, see [free practice datasets](https://datautility.in/blog/free-practice-datasets-sql-excel-data-science).

## What it is not

Everything is random. City names are real, but no listing exists, and prices do not reflect any real market. Do not use it for valuations, market research or forecasts.

## How to use the Data Generator: step by step

1. Open the Data Generator and choose Property listings.
2. Choose the number of rows.
3. Pick CSV, Excel, JSON or Parquet.
4. Download the file and open it in your tool.

## When to use the Data Generator

- Demo a property search or dashboard
- Practise pivot tables on price by bedrooms
- Test a listings import
- Teach SQL filters and group by

## Example

Input:

```
Dataset: Customers, 3 rows
```

Output:

```
id,name,email
1,Maya Patel,maya.patel@example.com
2,Leo Fischer,leo.fischer@example.com
```

## Frequently asked questions

### Is this real property data?
No. The listings are random. City names are real, but prices, areas and listings do not describe real properties or any real market.

### Does price depend on size and location?
No. Price, area and city are generated independently, so use the data for charts, joins and filters, not for price prediction.

### How many rows can I get?
Up to 500,000 rows in the Data Generator. Choose the row count before you download.

Tip: Download Excel if you want to practise pivot tables straight away, or CSV for SQL and pandas.

## Related tool pages

- [Fake Data Generator](https://datautility.in/fake-data-generator): Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Test Data Generator](https://datautility.in/test-data-generator): Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Student Data Generator: Fake Student Records](https://datautility.in/student-data-generator): Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- [Student Marks Dataset Generator](https://datautility.in/student-marks-dataset-generator): Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- [Sample Data for SQL Practice](https://datautility.in/sample-data-for-sql-practice): Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- [Dummy Data for Excel Practice](https://datautility.in/dummy-data-for-excel-practice): Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

## Also try

- [Free practice datasets](https://datautility.in/blog/free-practice-datasets-sql-excel-data-science)
- [SQL practice questions](https://datautility.in/blog/sql-practice-queries-for-students-with-sample-data)
- [Data Transformation](https://datautility.in/data-transformation)
- [Free test data generator: all datasets](https://datautility.in/blog/fake-datasets-by-industry-orders-healthcare-finance-climate)

## More guides

- [Free Mock Data Generator: Realistic Test Data in 1 Minute](https://datautility.in/blog/free-mock-data-generator-test-data)
- [Generate Test Data from a CREATE TABLE (500k Rows)](https://datautility.in/blog/generate-test-data-from-schema)
- [Synthetic Data vs Random Fake Data: What Is the Difference?](https://datautility.in/blog/synthetic-data-vs-fake-data-generator)
