`db/seed.sql`

44 lines
-- Sample seed data so the UI renders immediately while the ingest pipeline is offline.
INSERT INTO listing (slug, source, source_id, title, headline, description, address_line1, city, state, postal_code, latitude, longitude, bedrooms, bathrooms, sleeps, property_type, amenities, hero_image, images, nightly_price, source_url)
VALUES
  ('malibu-ocean-bungalow', 'airbnb', 'ab-1000001',
   'Malibu Ocean Bungalow',
   'Cedar-clad 2BR steps from Zuma Beach, dawn-pink sunsets from the deck.',
   'Surf-and-sleep loop: wake up, walk 90 seconds to the sand, end the day watching the pelicans dive into the kelp line. The bungalow sits on a stretch of Pacific Coast Highway that locals call the quiet mile; no traffic noise, no tourist crush, just the Pacific.',
   '30874 PCH', 'Malibu', 'CA', '90265', 34.0191, -118.8156, 2, 2.0, 4, 'Entire home',
   '["Beach access","WiFi 300 Mbps","Outdoor shower","BBQ","Wood-burning fireplace"]'::jsonb,
   'https://images.unsplash.com/photo-1501183638710-841dd1904471?w=1600',
   '["https://images.unsplash.com/photo-1501183638710-841dd1904471?w=1600","https://images.unsplash.com/photo-1505691938895-1758d7feb511?w=1600"]'::jsonb,
   685.00, 'https://www.airbnb.com/rooms/ab-1000001'),

  ('echo-park-craftsman', 'airbnb', 'ab-1000002',
   'Echo Park Craftsman — Walk to the Lake',
   '1910 bungalow with the front porch that built East LA; steps from Sunset.',
   'A piece of pre-war Los Angeles kept intact — clawfoot tub, original mail slot, reed-glass interior doors. Walk to the lake in four minutes, to Elysian in ten, to the best tacos of your life in twelve.',
   '1421 Bellevue Ave', 'Los Angeles', 'CA', '90026', 34.0781, -118.2548, 3, 2.0, 6, 'Entire home',
   '["WiFi 500 Mbps","Washer/Dryer","EV charger","Dog friendly","Patio"]'::jsonb,
   'https://images.unsplash.com/photo-1570129477492-45c003edd2be?w=1600',
   '["https://images.unsplash.com/photo-1570129477492-45c003edd2be?w=1600"]'::jsonb,
   412.00, 'https://www.airbnb.com/rooms/ab-1000002'),

  ('joshua-tree-dome', 'airbnb', 'ab-1000003',
   'Joshua Tree Geodesic Dome',
   'Off-grid dome with an outdoor clawfoot tub under the Milky Way.',
   'Solar-powered, tucked into a canyon, the dome is built for long quiet nights: telescope on the deck, outdoor tub, wood-burning stove for the January cold snaps. Reception is intentionally patchy. Bring a book.',
   'Box Canyon Rd', 'Joshua Tree', 'CA', '92252', 34.1328, -116.3157, 1, 1.0, 2, 'Entire home',
   '["Outdoor bathtub","Telescope","Wood stove","Fire pit","Dark-sky location"]'::jsonb,
   'https://images.unsplash.com/photo-1542718610-a1d656d1884c?w=1600',
   '["https://images.unsplash.com/photo-1542718610-a1d656d1884c?w=1600"]'::jsonb,
   295.00, 'https://www.airbnb.com/rooms/ab-1000003'),

  ('big-bear-a-frame', 'airbnb', 'ab-1000004',
   'Big Bear A-Frame Cabin',
   'Vintage A-frame with a hot tub and a record collection that takes itself seriously.',
   'Four season cabin 12 minutes from Snow Summit. Primary bed loft has a skylight aimed at the lift lines. The living room turntable and the 300+ LPs stay with the house.',
   '1021 Fawnskin Rd', 'Big Bear Lake', 'CA', '92315', 34.2439, -116.9114, 2, 1.0, 4, 'Cabin',
   '["Hot tub","Ski storage","Record player","Fireplace","Mountain view"]'::jsonb,
   'https://images.unsplash.com/photo-1518780664697-55e3ad937233?w=1600',
   '["https://images.unsplash.com/photo-1518780664697-55e3ad937233?w=1600"]'::jsonb,
   378.00, 'https://www.airbnb.com/rooms/ab-1000004')
ON CONFLICT (slug) DO NOTHING;