\n 🏠\n

House Hunter

\n \n

Find your dream home today

\n );\n}",[160,82,80],"8a0666fc-31a2-11f0-9f95-569c3dd06744",["D",1747323461854],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Property, PropertyFilters, ProjectInfo } from \"../../shared/types.ts\";\nimport Header from \"./Header.tsx\";\nimport PropertyList from \"./PropertyList.tsx\";\nimport PropertyFiltersPanel from \"./PropertyFiltersPanel.tsx\";\nimport Footer from \"./Footer.tsx\";\n\ninterface AppProps {\n initialData: {\n properties: Property[];\n };\n}\n\nexport default function App({ initialData }: AppProps) {\n const [properties, setProperties] = useState(initialData.properties);\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [filters, setFilters] = useState({});\n const [cities, setCities] = useState([]);\n const [states, setStates] = useState([]);\n const [projectInfo, setProjectInfo] = useState(null);\n\n // Fetch cities and states for filter dropdowns\n useEffect(() => {\n const fetchFilterOptions = async () => {\n try {\n const [citiesRes, statesRes] = await Promise.all([\n fetch('/api/properties/cities'),\n fetch('/api/properties/states')\n ]);\n \n const citiesData = await citiesRes.json();\n const statesData = await statesRes.json();\n \n setCities(citiesData.cities);\n setStates(statesData.states);\n } catch (err) {\n console.error('Error fetching filter options:', err);\n }\n };\n\n fetchFilterOptions();\n }, []);\n\n // Fetch project info for footer\n useEffect(() => {\n const fetchProjectInfo = async () => {\n try {\n const res = await fetch('/api/project-info');\n const data = await res.json();\n setProjectInfo(data);\n } catch (err) {\n console.error('Error fetching project info:', err);\n }\n };\n\n fetchProjectInfo();\n }, []);\n\n // Apply filters and fetch properties\n const applyFilters = async (newFilters: PropertyFilters) => {\n setLoading(true);\n setError(null);\n setFilters(newFilters);\n \n try {\n // Build query string from filters\n const queryParams = new URLSearchParams();\n \n if (newFilters.minPrice) queryParams.append('minPrice', newFilters.minPrice.toString());\n if (newFilters.maxPrice) queryParams.append('maxPrice', newFilters.maxPrice.toString());\n if (newFilters.minBedrooms) queryParams.append('minBedrooms', newFilters.minBedrooms.toString());\n if (newFilters.minBathrooms) queryParams.append('minBathrooms', newFilters.minBathrooms.toString());\n if (newFilters.city) queryParams.append('city', newFilters.city);\n if (newFilters.state) queryParams.append('state', newFilters.state);\n if (newFilters.searchTerm) queryParams.append('searchTerm', newFilters.searchTerm);\n \n const response = await fetch(`/api/properties?${queryParams.toString()}`);\n \n if (!response.ok) {\n throw new Error('Failed to fetch properties');\n }\n \n const data = await response.json();\n setProperties(data.properties);\n } catch (err) {\n setError('Error fetching properties. Please try again.');\n console.error(err);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n \n

\n {/* Filters sidebar */}\n

\n \n

\n \n {/* Property listings */}\n

\n {error && (\n

\n {error}\n

\n )}\n \n \n

\n \n

\n );\n}",[160,82,65],"pulls","branches",1,"forks","envVars",{"_179":26,"_181":26},"connections",{"_179":26,"_180":26},"count","unfilledCount","emptyCount",{"_34":346,"_13":287,"_63":281,"_44":-5,"_36":37,"_154":330,"_155":24,"_38":347,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":348,"_17":349},{"_34":342,"_13":326,"_63":320,"_44":281,"_36":37,"_154":330,"_155":24,"_38":343,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":344,"_17":345},{"_34":335,"_13":205,"_63":336,"_44":320,"_36":37,"_154":337,"_155":24,"_38":338,"_40":26,"_66":21,"_157":339,"_68":30,"_158":-5,"_209":340,"_17":341},{"_34":327,"_13":328,"_63":329,"_44":320,"_36":37,"_154":330,"_155":24,"_38":331,"_40":26,"_66":67,"_157":332,"_68":30,"_158":-5,"_209":333,"_17":334},{"_34":317,"_13":318,"_63":319,"_44":320,"_36":37,"_154":321,"_155":24,"_38":322,"_40":26,"_66":67,"_157":323,"_68":30,"_158":-5,"_209":324,"_17":325},{"_34":313,"_13":304,"_63":298,"_44":281,"_36":37,"_154":308,"_155":24,"_38":314,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":315,"_17":316},{"_34":305,"_13":306,"_63":307,"_44":298,"_36":37,"_154":308,"_155":24,"_38":309,"_40":26,"_66":67,"_157":310,"_68":30,"_158":-5,"_209":311,"_17":312},{"_34":295,"_13":296,"_63":297,"_44":298,"_36":37,"_154":299,"_155":24,"_38":300,"_40":26,"_66":67,"_157":301,"_68":30,"_158":-5,"_209":302,"_17":303},{"_34":288,"_13":205,"_63":289,"_44":281,"_36":37,"_154":290,"_155":24,"_38":291,"_40":26,"_66":21,"_157":292,"_68":30,"_158":-5,"_209":293,"_17":294},{"_34":278,"_13":279,"_63":280,"_44":281,"_36":37,"_154":282,"_155":24,"_38":283,"_40":26,"_66":67,"_157":284,"_68":30,"_158":-5,"_209":285,"_17":286},{"_34":274,"_13":160,"_63":153,"_44":-5,"_36":37,"_154":260,"_155":24,"_38":275,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":276,"_17":277},{"_34":152,"_13":82,"_63":81,"_44":153,"_36":37,"_154":41,"_155":24,"_38":271,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":272,"_17":273},{"_34":167,"_13":65,"_63":64,"_44":81,"_36":37,"_154":41,"_155":24,"_38":268,"_40":26,"_66":67,"_157":169,"_68":30,"_158":-5,"_209":269,"_17":270},{"_34":163,"_13":80,"_63":79,"_44":81,"_36":37,"_154":74,"_155":24,"_38":265,"_40":26,"_66":67,"_157":165,"_68":30,"_158":-5,"_209":266,"_17":267},{"_34":257,"_13":258,"_63":259,"_44":153,"_36":37,"_154":260,"_155":24,"_38":261,"_40":26,"_66":21,"_157":262,"_68":30,"_158":-5,"_209":263,"_17":264},{"_34":249,"_13":250,"_63":251,"_44":153,"_36":37,"_154":252,"_155":24,"_38":253,"_40":26,"_66":67,"_157":254,"_68":30,"_158":-5,"_209":255,"_17":256},{"_34":241,"_13":242,"_63":243,"_44":153,"_36":37,"_154":244,"_155":24,"_38":245,"_40":26,"_66":21,"_157":246,"_68":30,"_158":-5,"_209":247,"_17":248},{"_34":237,"_13":221,"_63":215,"_44":-5,"_36":37,"_154":225,"_155":24,"_38":238,"_40":26,"_66":83,"_157":-5,"_68":30,"_158":-5,"_209":239,"_17":240},{"_34":230,"_13":205,"_63":231,"_44":215,"_36":37,"_154":232,"_155":24,"_38":233,"_40":26,"_66":21,"_157":234,"_68":30,"_158":-5,"_209":235,"_17":236},{"_34":222,"_13":223,"_63":224,"_44":215,"_36":37,"_154":225,"_155":24,"_38":226,"_40":26,"_66":67,"_157":227,"_68":30,"_158":-5,"_209":228,"_17":229},{"_34":212,"_13":213,"_63":214,"_44":215,"_36":37,"_154":216,"_155":24,"_38":217,"_40":26,"_66":67,"_157":218,"_68":30,"_158":-5,"_209":219,"_17":220},{"_34":204,"_13":205,"_63":206,"_44":-5,"_36":37,"_154":173,"_155":24,"_38":207,"_40":26,"_66":21,"_157":208,"_68":30,"_158":-5,"_209":210,"_17":211},"20be28ce-31a2-11f0-9182-569c3dd06744","README.md","20be295a-31a2-11f0-9182-569c3dd06744",["D",1747323285222],"# House Hunter\n\nA web application to help people search for and find their ideal home.\n\n## Features\n\n- Search for properties by location, price range, and features\n- View detailed property listings with images and descriptions\n- Filter properties by various criteria (bedrooms, bathrooms, etc.)\n- Save favorite properties for later viewing\n- Responsive design for mobile and desktop use\n\n## Project Structure\n\n- `/backend` - Server-side code using Hono for API endpoints and SQLite for data storage\n- `/frontend` - Client-side code using React and TailwindCSS\n- `/shared` - Shared types and utilities used by both frontend and backend\n\n## Getting Started\n\nVisit the live application to start searching for properties.\n\n## Technologies Used\n\n- Hono (Backend API framework)\n- SQLite (Database)\n- React (Frontend UI)\n- TailwindCSS (Styling)\n- TypeScript (Type safety)","children",[],[205],"69847e5a-31a2-11f0-930e-569c3dd06744","utils.ts","69847f22-31a2-11f0-930e-569c3dd06744","9a4e2b49-3314-4d53-9d71-fe06c7f187ba",10,["D",1747323407318],"// Format price as currency\nexport function formatPrice(price: number): string {\n return new Intl.NumberFormat('en-US', {\n style: 'currency',\n currency: 'USD',\n maximumFractionDigits: 0\n }).format(price);\n}\n\n// Format number with commas\nexport function formatNumber(num: number): string {\n return new Intl.NumberFormat('en-US').format(num);\n}\n\n// Format bathrooms (handle .5 for half baths)\nexport function formatBathrooms(bathrooms: number): string {\n return bathrooms % 1 === 0 ? bathrooms.toString() : bathrooms.toFixed(1);\n}",[],[221,213],"shared","66331374-31a2-11f0-8ad0-569c3dd06744","types.ts","66331432-31a2-11f0-8ad0-569c3dd06744",9,["D",1747323401747],"// Property interface\nexport interface Property {\n id: number;\n title: string;\n description: string;\n price: number;\n bedrooms: number;\n bathrooms: number;\n sqft: number;\n address: string;\n city: string;\n state: string;\n zip: string;\n lat: number | null;\n lng: number | null;\n image_url: string | null;\n created_at: string;\n updated_at: string;\n}\n\n// Property filters interface\nexport interface PropertyFilters {\n minPrice?: number;\n maxPrice?: number;\n minBedrooms?: number;\n minBathrooms?: number;\n city?: string;\n state?: string;\n searchTerm?: string;\n}\n\n// Project info interface\nexport interface ProjectInfo {\n username: string;\n name: string;\n version: string;\n branch: string;\n projectUrl: string;\n}",[],[221,223],"6eab3e46-31a2-11f0-9b37-569c3dd06744","6eab3f04-31a2-11f0-9b37-569c3dd06744",11,["D",1747323415959],"# Shared\n\nThis directory contains code that is shared between the frontend and backend.\n\n## Files\n\n- `types.ts` - TypeScript interfaces used throughout the application\n- `utils.ts` - Utility functions for formatting and data manipulation\n\n## Usage\n\nThese files can be imported from both the frontend and backend code. They should not contain any environment-specific code (no Deno or browser-specific APIs).",[],[221,205],"66333174-31a2-11f0-8ad0-569c3dd06744",["D",1747323401747],[200,201,202],[221],"7a2c0d7c-31a2-11f0-b723-569c3dd06744","style.css","7a2c0e4e-31a2-11f0-b723-569c3dd06744",13,["D",1747323435260],"/* Custom styles beyond Tailwind */\n\n/* Smooth scrolling */\nhtml {\n scroll-behavior: smooth;\n}\n\n/* Custom focus styles */\n*:focus {\n outline: 2px solid #4f46e5;\n outline-offset: 2px;\n}\n\n/* Property card hover effect */\n.property-card {\n transition: transform 0.2s ease-in-out, box-shadow 0.2s ease-in-out;\n}\n\n.property-card:hover {\n transform: translateY(-4px);\n box-shadow: 0 10px 15px -3px rgba(0, 0, 0, 0.1), 0 4px 6px -2px rgba(0, 0, 0, 0.05);\n}\n\n/* Placeholder image style */\n.placeholder-image {\n background-color: #e5e7eb;\n background-image: linear-gradient(45deg, #f3f4f6 25%, transparent 25%, transparent 50%, #f3f4f6 50%, #f3f4f6 75%, transparent 75%, transparent);\n background-size: 20px 20px;\n}",[],[160,242],"7d995172-31a2-11f0-b723-569c3dd06744","index.tsx","7d995230-31a2-11f0-b723-569c3dd06744",14,["D",1747323441007],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\n// Get initial data injected by the server\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n properties: any[];\n };\n }\n}\n\n// Render the app\nconst root = createRoot(document.getElementById(\"app\")!);\nroot.render(\n \n \n \n);",[],[160,250],"7355a436-31a2-11f0-9090-569c3dd06744","index.html","7355a4ea-31a2-11f0-9090-569c3dd06744",12,["D",1747323423787],"\n\n\n \n \n House Hunter - Find Your Dream Home\n \n \n \n \n\n\n

\n \n\n",[],[160,258],["D",1747323469313],[],[160,82,80],["D",1747323461854],[],[160,82,65],["D",1747323461854],[194,195],[160,82],"7355c6aa-31a2-11f0-9090-569c3dd06744",["D",1747323423787],[193,196,197,198],[160],"5aa23198-31a2-11f0-9f5d-569c3dd06744","index.ts","5aa23260-31a2-11f0-9f5d-569c3dd06744","b6289973-3597-4d0f-8f10-904260ef7a11",7,["D",1747323382348],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { cors } from \"https://esm.sh/@hono/cors@0.0.8\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport properties from \"./routes/properties.ts\";\nimport static_routes from \"./routes/static.ts\";\nimport { parseProject } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Add CORS middleware\napp.use(\"*\", cors());\n\n// Get project info for view source link\nconst projectInfo = parseProject(import.meta.url);\n\n// Add API routes\napp.route(\"/api/properties\", properties);\n\n// Add a route to get project info\napp.get(\"/api/project-info\", (c) => {\n return c.json({\n username: projectInfo.username,\n name: projectInfo.name,\n version: projectInfo.version,\n branch: projectInfo.branch,\n projectUrl: projectInfo.links.self.project\n });\n});\n\n// Add static routes\napp.route(\"/\", static_routes);\n\n// Initialize database on startup\nrunMigrations().catch(err => {\n console.error(\"Failed to run migrations:\", err);\n});\n\n// Export the app for HTTP vals\nexport default app.fetch;",[],[287,279],"backend","61498d52-31a2-11f0-aaec-569c3dd06744","61498de8-31a2-11f0-aaec-569c3dd06744",8,["D",1747323393509],"# Backend\n\nThis directory contains the server-side code for the House Hunter application.\n\n## Structure\n\n- `index.ts` - Main entry point for the backend\n- `database/` - Database schema and queries\n- `routes/` - API route handlers\n\n## API Endpoints\n\n### Properties\n\n- `GET /api/properties` - Get all properties with optional filtering\n - Query parameters:\n - `minPrice` - Minimum price\n - `maxPrice` - Maximum price\n - `minBedrooms` - Minimum number of bedrooms\n - `minBathrooms` - Minimum number of bathrooms\n - `city` - Filter by city\n - `state` - Filter by state\n - `searchTerm` - Search in title, description, address, and city\n- `GET /api/properties/:id` - Get a single property by ID\n- `GET /api/properties/cities` - Get list of available cities\n- `GET /api/properties/states` - Get list of available states\n\n### Project Info\n\n- `GET /api/project-info` - Get information about the project for the view source link\n\n## Static Files\n\nThe backend serves static files from the `/frontend` and `/shared` directories.",[],[287,205],"52a5c2e8-31a2-11f0-b340-569c3dd06744","static.ts","52a5c3a6-31a2-11f0-b340-569c3dd06744","04ce77fb-3e60-41d5-b63c-76fe06079d85",6,["D",1747323368947],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { getProperties } from \"../database/queries.ts\";\n\nconst static_routes = new Hono();\n\n// Serve frontend files\nstatic_routes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve shared files\nstatic_routes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html with initial data\nstatic_routes.get(\"/\", async (c) => {\n try {\n // Get initial properties data\n const initialProperties = await getProperties();\n \n // Read the HTML file\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index:\", error);\n return c.text(\"Server error\", 500);\n }\n});\n\nexport default static_routes;",[],[287,304,296],"routes","4b86386c-31a2-11f0-9b37-569c3dd06744","properties.ts","4b863902-31a2-11f0-9b37-569c3dd06744",5,["D",1747323356991],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { getProperties, getPropertyById, getCities, getStates, PropertyFilters } from \"../database/queries.ts\";\n\nconst properties = new Hono();\n\n// Get all properties with optional filtering\nproperties.get(\"/\", async (c) => {\n const { \n minPrice, maxPrice, minBedrooms, minBathrooms, \n city, state, searchTerm \n } = c.req.query();\n\n const filters: PropertyFilters = {};\n \n // Parse and validate filters\n if (minPrice) filters.minPrice = parseInt(minPrice);\n if (maxPrice) filters.maxPrice = parseInt(maxPrice);\n if (minBedrooms) filters.minBedrooms = parseInt(minBedrooms);\n if (minBathrooms) filters.minBathrooms = parseFloat(minBathrooms);\n if (city) filters.city = city;\n if (state) filters.state = state;\n if (searchTerm) filters.searchTerm = searchTerm;\n\n try {\n const properties = await getProperties(filters);\n return c.json({ properties });\n } catch (error) {\n console.error(\"Error fetching properties:\", error);\n return c.json({ error: \"Failed to fetch properties\" }, 500);\n }\n});\n\n// Get a single property by ID\nproperties.get(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid property ID\" }, 400);\n }\n \n try {\n const property = await getPropertyById(id);\n \n if (!property) {\n return c.json({ error: \"Property not found\" }, 404);\n }\n \n return c.json({ property });\n } catch (error) {\n console.error(\"Error fetching property:\", error);\n return c.json({ error: \"Failed to fetch property\" }, 500);\n }\n});\n\n// Get cities for dropdown\nproperties.get(\"/cities\", async (c) => {\n try {\n const cities = await getCities();\n return c.json({ cities });\n } catch (error) {\n console.error(\"Error fetching cities:\", error);\n return c.json({ error: \"Failed to fetch cities\" }, 500);\n }\n});\n\n// Get states for dropdown\nproperties.get(\"/states\", async (c) => {\n try {\n const states = await getStates();\n return c.json({ states });\n } catch (error) {\n console.error(\"Error fetching states:\", error);\n return c.json({ error: \"Failed to fetch states\" }, 500);\n }\n});\n\nexport default properties;",[],[287,304,306],"4b866d50-31a2-11f0-9b37-569c3dd06744",["D",1747323356991],[188,189],[287,304],"3e7cfe9e-31a2-11f0-8f58-569c3dd06744","queries.ts","3e7cff52-31a2-11f0-8f58-569c3dd06744","898e3450-a2c8-4c8b-9742-4042639f9071",3,["D",1747323335125],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PROPERTIES_TABLE } from \"./migrations.ts\";\n\nexport interface Property {\n id: number;\n title: string;\n description: string;\n price: number;\n bedrooms: number;\n bathrooms: number;\n sqft: number;\n address: string;\n city: string;\n state: string;\n zip: string;\n lat: number | null;\n lng: number | null;\n image_url: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface PropertyFilters {\n minPrice?: number;\n maxPrice?: number;\n minBedrooms?: number;\n minBathrooms?: number;\n city?: string;\n state?: string;\n searchTerm?: string;\n}\n\n// Get all properties with optional filtering\nexport async function getProperties(filters: PropertyFilters = {}): Promise {\n let query = `SELECT * FROM ${PROPERTIES_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n // Apply filters\n if (filters.minPrice !== undefined) {\n query += ` AND price >= ?`;\n params.push(filters.minPrice);\n }\n \n if (filters.maxPrice !== undefined) {\n query += ` AND price <= ?`;\n params.push(filters.maxPrice);\n }\n \n if (filters.minBedrooms !== undefined) {\n query += ` AND bedrooms >= ?`;\n params.push(filters.minBedrooms);\n }\n \n if (filters.minBathrooms !== undefined) {\n query += ` AND bathrooms >= ?`;\n params.push(filters.minBathrooms);\n }\n \n if (filters.city) {\n query += ` AND city LIKE ?`;\n params.push(`%${filters.city}%`);\n }\n \n if (filters.state) {\n query += ` AND state = ?`;\n params.push(filters.state);\n }\n \n if (filters.searchTerm) {\n query += ` AND (\n title LIKE ? OR \n description LIKE ? OR \n address LIKE ? OR \n city LIKE ?\n )`;\n const term = `%${filters.searchTerm}%`;\n params.push(term, term, term, term);\n }\n \n query += ` ORDER BY price ASC`;\n \n const result = await sqlite.execute(query, params);\n return result.rows as Property[];\n}\n\n// Get a single property by ID\nexport async function getPropertyById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${PROPERTIES_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as Property;\n}\n\n// Get cities for dropdown\nexport async function getCities(): Promise {\n const result = await sqlite.execute(\n `SELECT DISTINCT city FROM ${PROPERTIES_TABLE} ORDER BY city ASC`\n );\n \n return result.rows.map(row => row.city);\n}\n\n// Get states for dropdown\nexport async function getStates(): Promise {\n const result = await sqlite.execute(\n `SELECT DISTINCT state FROM ${PROPERTIES_TABLE} ORDER BY state ASC`\n );\n \n return result.rows.map(row => row.state);\n}",[],[287,326,318],"database","34445eae-31a2-11f0-a011-569c3dd06744","migrations.ts","34445f62-31a2-11f0-a011-569c3dd06744",2,["D",1747323317977],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const PROPERTIES_TABLE = \"properties_v1\";\n\n// Create tables if they don't exist\nexport async function runMigrations() {\n // Properties table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${PROPERTIES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n price INTEGER NOT NULL,\n bedrooms INTEGER NOT NULL,\n bathrooms REAL NOT NULL,\n sqft INTEGER NOT NULL,\n address TEXT NOT NULL,\n city TEXT NOT NULL,\n state TEXT NOT NULL,\n zip TEXT NOT NULL,\n lat REAL,\n lng REAL,\n image_url TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n // Check if we need to seed initial data\n const count = await sqlite.execute(`SELECT COUNT(*) as count FROM ${PROPERTIES_TABLE}`);\n \n if (count.rows[0].count === 0) {\n await seedInitialData();\n }\n}\n\n// Seed some initial property data\nasync function seedInitialData() {\n const properties = [\n {\n title: \"Modern Downtown Condo\",\n description: \"Beautiful modern condo in the heart of downtown with amazing city views. Features include hardwood floors, stainless steel appliances, and a spacious balcony.\",\n price: 450000,\n bedrooms: 2,\n bathrooms: 2,\n sqft: 1200,\n address: \"123 Main St\",\n city: \"Seattle\",\n state: \"WA\",\n zip: \"98101\",\n lat: 47.6062,\n lng: -122.3321,\n image_url: \"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8NHx8YXBhcnRtZW50fGVufDB8fDB8fHww&auto=format&fit=crop&w=800&q=60\"\n },\n {\n title: \"Suburban Family Home\",\n description: \"Spacious family home in a quiet suburban neighborhood. Features a large backyard, updated kitchen, and finished basement.\",\n price: 650000,\n bedrooms: 4,\n bathrooms: 2.5,\n sqft: 2400,\n address: \"456 Oak Ave\",\n city: \"Bellevue\",\n state: \"WA\",\n zip: \"98004\",\n lat: 47.6101,\n lng: -122.2015,\n image_url: \"https://images.unsplash.com/photo-1568605114967-8130f3a36994?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8NXx8aG91c2V8ZW58MHx8MHx8fDA%3D&auto=format&fit=crop&w=800&q=60\"\n },\n {\n title: \"Waterfront Luxury Villa\",\n description: \"Stunning waterfront property with panoramic views. Features include a gourmet kitchen, home theater, and private dock.\",\n price: 1250000,\n bedrooms: 5,\n bathrooms: 4,\n sqft: 3800,\n address: \"789 Lake Dr\",\n city: \"Kirkland\",\n state: \"WA\",\n zip: \"98033\",\n lat: 47.6769,\n lng: -122.2060,\n image_url: \"https://images.unsplash.com/photo-1613490493576-7fde63acd811?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8Mnx8bHV4dXJ5JTIwaG91c2V8ZW58MHx8MHx8fDA%3D&auto=format&fit=crop&w=800&q=60\"\n },\n {\n title: \"Cozy Starter Home\",\n description: \"Perfect starter home in a friendly neighborhood. Recently renovated with new appliances and updated bathroom.\",\n price: 350000,\n bedrooms: 3,\n bathrooms: 1,\n sqft: 1500,\n address: \"101 Pine St\",\n city: \"Renton\",\n state: \"WA\",\n zip: \"98055\",\n lat: 47.4829,\n lng: -122.2171,\n image_url: \"https://images.unsplash.com/photo-1605276374104-dee2a0ed3cd6?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8MTJ8fGhvdXNlfGVufDB8fDB8fHww&auto=format&fit=crop&w=800&q=60\"\n },\n {\n title: \"Historic Craftsman\",\n description: \"Beautifully maintained historic craftsman with original woodwork and modern updates. Features include a covered porch and mature garden.\",\n price: 750000,\n bedrooms: 3,\n bathrooms: 2,\n sqft: 2100,\n address: \"222 Maple Rd\",\n city: \"Tacoma\",\n state: \"WA\",\n zip: \"98403\",\n lat: 47.2529,\n lng: -122.4443,\n image_url: \"https://images.unsplash.com/photo-1570129477492-45c003edd2be?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8M3x8aG91c2V8ZW58MHx8MHx8fDA%3D&auto=format&fit=crop&w=800&q=60\"\n },\n {\n title: \"Urban Loft\",\n description: \"Stylish urban loft in a converted warehouse. Features high ceilings, exposed brick, and an open floor plan.\",\n price: 525000,\n bedrooms: 1,\n bathrooms: 1.5,\n sqft: 1100,\n address: \"333 Industrial Blvd\",\n city: \"Seattle\",\n state: \"WA\",\n zip: \"98107\",\n lat: 47.6615,\n lng: -122.3720,\n image_url: \"https://images.unsplash.com/photo-1560448204-e02f11c3d0e2?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxzZWFyY2h8MTd8fGxvZnR8ZW58MHx8MHx8fDA%3D&auto=format&fit=crop&w=800&q=60\"\n }\n ];\n\n // Insert properties\n for (const property of properties) {\n await sqlite.execute(`\n INSERT INTO ${PROPERTIES_TABLE} (\n title, description, price, bedrooms, bathrooms, sqft, \n address, city, state, zip, lat, lng, image_url\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n property.title, property.description, property.price, \n property.bedrooms, property.bathrooms, property.sqft,\n property.address, property.city, property.state, property.zip,\n property.lat, property.lng, property.image_url\n ]);\n }\n}",[],[287,326,328],"4422bc3a-31a2-11f0-96f5-569c3dd06744","4422bcc6-31a2-11f0-96f5-569c3dd06744",4,["D",1747323344602],"# Database Layer\n\nThis directory contains the database schema and query functions for the House Hunter application.\n\n## Files\n\n- `migrations.ts` - Contains the database schema definitions and initial data seeding\n- `queries.ts` - Contains functions for querying the database\n\n## Schema\n\nThe main table is `properties_v1` which stores all property listings with the following fields:\n\n- `id` - Unique identifier\n- `title` - Property title\n- `description` - Detailed description\n- `price` - Price in USD\n- `bedrooms` - Number of bedrooms\n- `bathrooms` - Number of bathrooms\n- `sqft` - Square footage\n- `address` - Street address\n- `city` - City\n- `state` - State\n- `zip` - ZIP code\n- `lat` - Latitude (for map display)\n- `lng` - Longitude (for map display)\n- `image_url` - URL to the property image\n- `created_at` - Creation timestamp\n- `updated_at` - Last update timestamp\n\n## Usage\n\nThe database is automatically initialized when the application starts. The `runMigrations` function creates the necessary tables and seeds initial data if needed.",[],[287,326,205],"34448a5a-31a2-11f0-a011-569c3dd06744",["D",1747323317977],[184,185,186],[287,326],"3444883e-31a2-11f0-a011-569c3dd06744",["D",1747323317977],[183,187,190,191],[287],["D",1747323244003],{"_11":12,"_130":71},{"_11":12,"_126":-5,"_70":71,"_31":69,"_127":128,"_129":30},{"_40":74,"_13":16,"_34":37,"_118":85,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_53":-5,"_149":387,"_388":389,"_390":391,"_392":30,"_393":30,"_394":30,"_395":24,"_396":-5,"_397":-7,"_398":-7,"_399":26,"_400":30,"_401":30,"_402":-5,"_403":30,"_404":30,"_405":30,"_406":-5},"ENV",{"_358":359,"_360":361,"_362":16,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · components