id | city | median_home_price |
---|---|---|
1 | New York | 650000.0 |
2 | Los Angeles | 780000.0 |
3 | Chicago | 390000.0 |
4 | Miami | 550000.0 |
5 | San Francisco | 1200000.0 |
agent_id | name | years_experience |
---|---|---|
1 | John Doe | 10 |
2 | Jane Smith | 5 |
3 | Michael Brown | 15 |
4 | Emily Johnson | 7 |
5 | William Davis | 20 |
agency_id | name | rating |
---|---|---|
1 | Fannie Mae | AAA |
2 | Freddie Mac | AAA |
3 | Ginnie Mae | AA+ |
4 | Quicken Loans | A+ |
5 | Wells Fargo Home Mortgage | A+ |
program_id | description | interest_rate |
---|---|---|
1 | Conventional Loan | 3.5 |
2 | Adjustable Rate Mortgage | 3.25 |
3 | Fixed-Rate Mortgage | 3.75 |
4 | First-Time Home Buyer Program | 3.25 |
5 | VA Loan | 2.75 |
housing_finance_agency_id | loan_program_id |
---|---|
(→ Housing_Finance_Agencies.agency_id) | (→ Loan_Programs.program_id) |
1 | 4 |
2 | 4 |
3 | 4 |
4 | 4 |
5 | 4 |
5 | 1 |