{
  "properties": [
    {
      "id": "prop_001",
      "mls_number": "MLS-2024-1001",
      "address": "123 Oak Street",
      "city": "San Francisco",
      "state": "CA",
      "zip": "94102",
      "full_address": "123 Oak Street, San Francisco, CA 94102",
      "price": 1250000,
      "monthly_rent": null,
      "transaction_type": "sale",
      "property_type": "single_family",
      "bedrooms": 3,
      "bathrooms": 2.5,
      "sqft": 2100,
      "lot_size": 5000,
      "year_built": 2018,
      "parking": "2-car garage",
      "features": [
        "Hardwood floors throughout",
        "Chef's kitchen with granite countertops",
        "Master suite with walk-in closet",
        "Private backyard with deck",
        "Smart home technology",
        "Energy efficient appliances"
      ],
      "description": "Beautifully renovated single-family home in prime San Francisco location. This stunning property features modern finishes, an open floor plan, and a private backyard perfect for entertaining.",
      "images": [
        "https://images.unsplash.com/photo-1580587771525-78b9dba3b914",
        "https://images.unsplash.com/photo-1600596542815-ffad4c1539a9",
        "https://images.unsplash.com/photo-1600607687939-ce8a6c25118c"
      ],
      "listing_agent": {
        "name": "Jessica Lee",
        "phone": "(415) 555-9876",
        "email": "jessica.lee@realty.com",
        "agency": "Premium Realty Group"
      },
      "status": "active",
      "days_on_market": 15,
      "virtual_tour_url": "https://tours.example.com/prop_001",
      "hoa_fee": 200,
      "taxes_annual": 12500,
      "school_district": "San Francisco Unified",
      "nearby_schools": [
        {
          "name": "Lincoln Elementary",
          "distance": "0.3 miles",
          "rating": "8/10"
        },
        {
          "name": "Roosevelt Middle School",
          "distance": "0.8 miles",
          "rating": "7/10"
        }
      ]
    },
    {
      "id": "prop_002",
      "mls_number": "MLS-2024-1002",
      "address": "456 Market Street, Unit 12B",
      "city": "San Francisco",
      "state": "CA",
      "zip": "94103",
      "full_address": "456 Market Street, Unit 12B, San Francisco, CA 94103",
      "price": 750000,
      "monthly_rent": null,
      "transaction_type": "sale",
      "property_type": "condo",
      "bedrooms": 2,
      "bathrooms": 2,
      "sqft": 1200,
      "lot_size": null,
      "year_built": 2020,
      "parking": "1 parking space",
      "features": [
        "Floor-to-ceiling windows",
        "City views",
        "In-unit washer/dryer",
        "Stainless steel appliances",
        "Building amenities: gym, rooftop terrace",
        "Concierge service"
      ],
      "description": "Modern luxury condo in the heart of downtown. Enjoy stunning city views and world-class amenities in this contemporary living space.",
      "images": [
        "https://images.unsplash.com/photo-1545324418-cc1a3fa10c00",
        "https://images.unsplash.com/photo-1522708323590-d24dbb6b0267"
      ],
      "listing_agent": {
        "name": "Michael Torres",
        "phone": "(415) 555-3456",
        "email": "m.torres@realty.com",
        "agency": "Urban Living Realty"
      },
      "status": "active",
      "days_on_market": 8,
      "virtual_tour_url": "https://tours.example.com/prop_002",
      "hoa_fee": 550,
      "taxes_annual": 7500,
      "school_district": "San Francisco Unified",
      "nearby_schools": []
    },
    {
      "id": "prop_003",
      "mls_number": "MLS-2024-1003",
      "address": "789 Valencia Street",
      "city": "San Francisco",
      "state": "CA",
      "zip": "94110",
      "full_address": "789 Valencia Street, San Francisco, CA 94110",
      "price": null,
      "monthly_rent": 4200,
      "transaction_type": "rent",
      "property_type": "townhouse",
      "bedrooms": 3,
      "bathrooms": 2.5,
      "sqft": 1800,
      "lot_size": null,
      "year_built": 2019,
      "parking": "2 parking spaces",
      "features": [
        "Private entrance",
        "Modern kitchen",
        "Rooftop deck",
        "Hardwood floors",
        "Central heating/AC",
        "Pet friendly"
      ],
      "description": "Spacious townhouse in vibrant Mission District. Perfect for families or roommates. Walk to restaurants, cafes, and public transit.",
      "images": [
        "https://images.unsplash.com/photo-1512917774080-9991f1c4c750"
      ],
      "listing_agent": {
        "name": "Sarah Martinez",
        "phone": "(415) 555-7890",
        "email": "s.martinez@realty.com",
        "agency": "Mission Properties"
      },
      "status": "active",
      "days_on_market": 3,
      "virtual_tour_url": "https://tours.example.com/prop_003",
      "deposit": 4200,
      "lease_term": "12 months",
      "available_date": "2025-01-15",
      "pets_allowed": true,
      "school_district": "San Francisco Unified",
      "nearby_schools": []
    }
  ],
  "viewings": [
    {
      "id": "view_001",
      "property_id": "prop_001",
      "property_address": "123 Oak Street, San Francisco, CA 94102",
      "client_name": "Michael Smith",
      "client_email": "m.smith@example.com",
      "client_phone": "(555) 234-5678",
      "date": "2024-12-28",
      "time": "14:00",
      "type": "virtual",
      "status": "scheduled",
      "meeting_link": "https://zoom.us/j/123456789",
      "agent_name": "Jessica Lee"
    },
    {
      "id": "view_002",
      "property_id": "prop_002",
      "property_address": "456 Market Street, Unit 12B, San Francisco, CA 94103",
      "client_name": "Emily Johnson",
      "client_email": "emily.j@example.com",
      "client_phone": "(555) 345-6789",
      "date": "2024-12-27",
      "time": "15:30",
      "type": "in_person",
      "status": "confirmed",
      "meeting_location": "Building lobby",
      "agent_name": "Michael Torres"
    }
  ],
  "open_houses": [
    {
      "id": "oh_001",
      "property_id": "prop_001",
      "property_address": "123 Oak Street, San Francisco, CA 94102",
      "date": "2024-12-28",
      "start_time": "13:00",
      "end_time": "16:00",
      "description": "Open house this Saturday! Come see this beautiful home and ask questions.",
      "rsvp_required": false,
      "rsvp_count": 12,
      "agent_name": "Jessica Lee",
      "agent_phone": "(415) 555-9876"
    },
    {
      "id": "oh_002",
      "property_id": "prop_002",
      "property_address": "456 Market Street, Unit 12B, San Francisco, CA 94103",
      "date": "2024-12-29",
      "start_time": "14:00",
      "end_time": "17:00",
      "description": "Downtown luxury condo open house. Refreshments provided!",
      "rsvp_required": true,
      "rsvp_count": 8,
      "agent_name": "Michael Torres",
      "agent_phone": "(415) 555-3456"
    }
  ],
  "mortgage_rates": {
    "30_year_fixed": {
      "rate": 6.75,
      "apr": 6.89,
      "description": "30-year fixed-rate mortgage"
    },
    "15_year_fixed": {
      "rate": 6,
      "apr": 6.15,
      "description": "15-year fixed-rate mortgage"
    },
    "5_1_arm": {
      "rate": 5.5,
      "apr": 6.25,
      "description": "5/1 Adjustable Rate Mortgage"
    },
    "fha": {
      "rate": 6.25,
      "apr": 6.45,
      "description": "FHA 30-year fixed"
    }
  },
  "rsvps": []
}