## Properties

property_id | Street_Address | City | Real_Estate_Offices | Price | Property_Type | Square_Feet
--- | --- | --- | --- | --- | --- | ---
1 | 123 Main St | Anytown | 2 | 300000.0 | Single Family Home | 2000
2 | 456 Elm St | Othertown | 1 | 400000.0 | Condo | 1200
3 | 789 Oak St | Anytown | 3 | 500000.0 | Townhouse | 2500
4 | 999 Pine St | Downtown | 1 | 600000.0 | Loft | 2000
5 | 222 Maple Ave | Suburbia | 2 | 450000.0 | Single Family Home | 3000

## RealEstateOffices

real_estate_office_id | Name | Address | PhoneNumber
--- | --- | --- | ---
1 | ABC Realty | 123 Office Rd | 555-123-4567
2 | XYZ Real Estate | 456 Agency Blvd | 555-234-5678
3 | Mega Brokers | 789 Listing Ln | 555-345-6789
4 | Local Agents | 999 Open House Dr | 555-456-7890
5 | First Choice Homes | 222 Sell Now St | 555-567-8901

## Clients

client_id | Name | Email | PhoneNumber
--- | --- | --- | ---
1 | John Doe | john@example.com | 555-111-2222
2 | Jane Smith | janemsmith@email.com | 555-333-4444
3 | Alice Johnson | alice.johnson@yahoo.com | 555-555-6666
4 | Bob Brown | bobbrown@gmail.com | 555-777-8888
5 | Carol White | carolwhite@hotmail.com | 555-999-0000

## ClientProperties

client_id | property_id | InterestedDate
--- | --- | ---
(→ Clients.client_id) | (→ Properties.property_id) |
1 | 1 | 2023-01-01 10:00:00
2 | 2 | 2023-02-01 10:00:00
3 | 3 | 2023-03-01 10:00:00
4 | 4 | 2023-04-01 10:00:00
5 | 5 | 2023-05-01 10:00:00

## Transactions

transaction_id | TransactionDate | client_id | property_id | TypeOfTransaction
--- | --- | --- | --- | ---
|  | (→ Clients.client_id) | (→ Properties.property_id) |
1 | 2023-01-10 10:00:00 | 1 | 1 | Purchase
2 | 2023-02-10 10:00:00 | 2 | 2 | Rent
3 | 2023-03-10 10:00:00 | 3 | 3 | Lease
4 | 2023-04-10 10:00:00 | 4 | 4 | Purchase
5 | 2023-05-10 10:00:00 | 5 | 5 | Rent