Real Estate Listings Sample Dataset: Free Property Data for Dashboards and SQL
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.
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, 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. 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.
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.
Related tool pages
- 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: 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: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- 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: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- 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
- SQL practice questions
- Data Transformation
- Free test data generator: all datasets
How to use the Data Generator: step by step
- Open the Data Generator and choose Property listings.
- Choose the number of rows.
- Pick CSV, Excel, JSON or Parquet.
- 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.