-- ==========================================
-- LUNIAR ESTATE - DATABASE SCHEMA (MYSQL)
-- ==========================================

-- Create Database if not exists
CREATE DATABASE IF NOT EXISTS `luniar_estate` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `luniar_estate`;

-- 1. AGENTS TABLE
DROP TABLE IF EXISTS `agents`;
CREATE TABLE `agents` (
  `id` VARCHAR(50) NOT NULL,
  `name` VARCHAR(100) NOT NULL,
  `role` VARCHAR(100) NOT NULL,
  `image` TEXT NOT NULL,
  `email` VARCHAR(100) NOT NULL UNIQUE,
  `phone` VARCHAR(30) NOT NULL,
  `bio` TEXT NOT NULL,
  `propertiesCount` INT DEFAULT 0,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 2. PROPERTIES TABLE
DROP TABLE IF EXISTS `properties`;
CREATE TABLE `properties` (
  `id` VARCHAR(50) NOT NULL,
  `title` VARCHAR(150) NOT NULL,
  `slug` VARCHAR(100) NOT NULL,
  `category` ENUM('villas', 'apartments', 'houses', 'commercial') NOT NULL,
  `location` VARCHAR(150) NOT NULL,
  `city` ENUM('Bali', 'Jakarta', 'Surabaya', 'Bandung') NOT NULL,
  `price` BIGINT NOT NULL,
  `beds` INT NOT NULL,
  `baths` DECIMAL(3,1) NOT NULL,
  `area` INT NOT NULL, -- SQFT
  `lotSize` VARCHAR(50) DEFAULT NULL,
  `yearBuilt` INT NOT NULL,
  `heroImage` TEXT NOT NULL,
  `images` TEXT NOT NULL, -- JSON formatted array of URLs ["url1", "url2", ...]
  `narrativeTitle` VARCHAR(255) NOT NULL,
  `narrativeDescription` TEXT NOT NULL,
  `specifications` TEXT NOT NULL, -- JSON formatted array of specs ["spec1", "spec2", ...]
  `lat` DECIMAL(10,8) NOT NULL,
  `lng` DECIMAL(11,8) NOT NULL,
  `agentId` VARCHAR(50) NOT NULL,
  `isFeatured` BOOLEAN DEFAULT FALSE,
  `recentlyAdded` BOOLEAN DEFAULT TRUE,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`agentId`) REFERENCES `agents` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 3. INQUIRIES TABLE
DROP TABLE IF EXISTS `inquiries`;
CREATE TABLE `inquiries` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `email` VARCHAR(100) NOT NULL,
  `phone` VARCHAR(50) DEFAULT NULL,
  `interest` VARCHAR(150) NOT NULL,
  `agent` VARCHAR(100) NOT NULL,
  `message` TEXT NOT NULL,
  `transactionId` VARCHAR(50) NOT NULL UNIQUE,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- ==========================================
-- HIGH-END SEED DATA
-- ==========================================

-- Populate Agents
INSERT INTO `agents` (`id`, `name`, `role`, `image`, `email`, `phone`, `bio`, `propertiesCount`) VALUES
('agent-alistair', 'Alistair Vance', 'Global Architectural Advisor', 'https://images.unsplash.com/photo-1534528741775-53994a69daeb?auto=format&fit=crop&q=80&w=600', 'alistair@luniarestate.com', '+62 811 992 481', 'With over fifteen years of experience in the luxury architectural market, Alistair specializes in rare premium assets that demonstrate exceptional structural integrity and spatial purity.', 6),
('agent-clara', 'Clara Moreau', 'Director of Curations', 'https://images.unsplash.com/photo-1573496359142-b8d87734a5a2?auto=format&fit=crop&q=80&w=600', 'clara@luniarestate.com', '+62 812 774 910', 'Clara possesses an uncompromising eye for minimalist aesthetics. She works closely with international collectors to curate homes that function as living sculptures.', 5),
('agent-hiroshi', 'Hiroshi Tanaka', 'Commercial & Private Accounts', 'https://images.unsplash.com/photo-1507003211169-0a1dd7228f2d?auto=format&fit=crop&q=80&w=600', 'hiroshi@luniarestate.com', '+62 813 881 223', 'Specializing in premium high-density apartments and sculptural commercial architecture, Hiroshi bridges development vision with sophisticated private capital.', 4);

-- Populate Properties
INSERT INTO `properties` (`id`, `title`, `slug`, `category`, `location`, `city`, `price`, `beds`, `baths`, `area`, `lotSize`, `yearBuilt`, `heroImage`, `images`, `narrativeTitle`, `narrativeDescription`, `specifications`, `lat`, `lng`, `agentId`, `isFeatured`, `recentlyAdded`) VALUES
(
  'prop-glass-pavilion',
  'The Glass Pavilion',
  'luxury-villas-bali',
  'villas',
  'Uluwatu, Bali',
  'Bali',
  14500000000,
  4,
  5.5,
  6200,
  '1.2 Acres',
  2023,
  'https://lh3.googleusercontent.com/aida-public/AB6AXuBUh4ZZAkF4M6Gfn-xxdWXbiVbyIKCtwFgQ6-VoKB_lETepfmYnlyem_6gqLzCwIuLnjyeoAUzR6LcCCAK9-RGga_8Vl8qmPGvIfSKUVnYCzZNMn5TPBjfZdkpEXHvCkRRE4NkK6-H8nrc5ISuhPdd6unPMIXWBchaYlpgyE7899q7v-olV3FDrtuY70X7R2q-3dVORybtpdTH1n3MF8AvO6hfkmcpnGLuSBx9Jhe8lDlkOUrTve4ed6m_KS7Oa7IFh7s0GUbuzoKc',
  '[\"https://lh3.googleusercontent.com/aida-public/AB6AXuBUh4ZZAkF4M6Gfn-xxdWXbiVbyIKCtwFgQ6-VoKB_lETepfmYnlyem_6gqLzCwIuLnjyeoAUzR6LcCCAK9-RGga_8Vl8qmPGvIfSKUVnYCzZNMn5TPBjfZdkpEXHvCkRRE4NkK6-H8nrc5ISuhPdd6unPMIXWBchaYlpgyE7899q7v-olV3FDrtuY70X7R2q-3dVORybtpdTH1n3MF8AvO6hfkmcpnGLuSBx9Jhe8lDlkOUrTve4ed6m_KS7Oa7IFh7s0GUbuzoKc\",\"https://lh3.googleusercontent.com/aida-public/AB6AXuAp0_bmJs46Mo6zUkP3isAv1doUwFMDxgXcGDBqzxnAMZkKmgpTE1oIuWnVDexpIzNd2BjtKgB1p__mEDWWEUg-0OUuWPms3MJAVo4KnmshPKezNPDjDUqI2SSmnGYOetZPPRkUf-Mx4Oa3BJE6Xsb4AjIcVFKvL6y0C83h1NFZcknPaTfLyyZfkhRPZtnnvr0nTnoMX7RpC218wKfwKotDtMeqhK7l_elA9ADbt1w3V7dS16qK5milEXo4MvvM1lNH0xJogpg7qpQ\",\"https://lh3.googleusercontent.com/aida-public/AB6AXuBPAsZyETQCpXbNrQJ0FJFiiG63C1m0jR6NXy9Q30udJDt17msB-mUZgSBgSPejTfnTt1UvGCsMN6F9CV5YPo_bHO65jomcPeWqSKCPflvkVajHv1XVZP1R3dkpZEV6SuxA5PxR0zTBAwRAkJ83_R5HEGOL62TjUB2d7jrfc4liBKXCWKV2vADqCoLDsHAMEH1_aKGmFYbGUUWA75k5RpP1cGfJ6OU4KF6prdK_EcK8bzls1PVgP8V8jKIcXCdl6jxeTIcOCmOgXZ0\"]',
  'The Architectural Narrative',
  'Conceived as a dialogue between form and landscape, The Glass Pavilion stands as a testament to minimalist restraint. The architect, leveraging the natural topography, crafted a structure that appears to float above the valley. Every sightline was meticulously planned to draw the exterior environment inward, blurring the boundary between shelter and nature.\n\nThe material palette is intentionally subdued—board-formed concrete, brushed steel, and expansive planes of low-iron glass—allowing the changing light of the day to become the primary decorative element. It is an exercise in quiet luxury, designed not to shout, but to resonate deeply with those who appreciate spatial purity.',
  '[\"Honed dark stone monolithic kitchen island\",\"Expansive low-iron structural glass facade\",\"Imported premium Italian marble bathroom elements\",\"Integrated smart climatic airflow system\",\"18-meter heated outdoor infinity saltwater pool\",\"Professional-grade chef\'s kitchen\"]',
  -8.84500000,
  115.12500000,
  'agent-clara',
  1,
  0
),
(
  'prop-cliff-retreat',
  'The Uluwatu Monolith',
  'luxury-villas-bali',
  'villas',
  'Pecatu Cliffside, Bali',
  'Bali',
  9800000000,
  5,
  6,
  7100,
  '1.5 Acres',
  2024,
  'https://images.unsplash.com/photo-1512917774080-9991f1c4c750?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1512917774080-9991f1c4c750?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600585154340-be6161a56a0c?auto=format&fit=crop&q=80&w=1200\"]',
  'A Dialogue of Stone and Sea',
  'Overlooking the azure depths of the Indian Ocean, this villa represents an absolute commitment to brutalist elegance. Giant geometric volumes of local hand-cut volcanic rock contrast with refined light timber framing.',
  '[\"Full volcanic rock master walling\",\"Uninterrupted 180° ocean sightlines\",\"Underground limestone wine vault\",\"Private cliffside elevator access\",\"Custom integrated Bose outdoor sound acoustics\"]',
  -8.84100000,
  115.10500000,
  'agent-alistair',
  1,
  1
),
(
  'prop-canggu-bamboo',
  'Canggu Bamboo Sanctum',
  'luxury-villas-bali',
  'villas',
  'Canggu, Bali',
  'Bali',
  8700000000,
  3,
  3.5,
  3800,
  '0.8 Acres',
  2023,
  'https://images.unsplash.com/photo-1583037189850-1921ae7c6c22?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1583037189850-1921ae7c6c22?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600566753190-17f0baa2a6c3?auto=format&fit=crop&q=80&w=1200\"]',
  'Symphony of Eco-Minimalism',
  'Sculpted entirely from treated black bamboo and sustainable light teakwood, the Canggu Bamboo Sanctum functions as a living breathing organism. Fluid structural curves and open common pavilions leverage natural cross-ventilation, completely minimizing energy layouts.\n\nA private lotus pond mirrors the architecture under natural light, while individual suites contain quiet recessed concrete pools and hand-chiseled basalt bathrooms.',
  '[\"Treated sustainable Petung black bamboo superstructure\",\"Private riverfront natural pool integration\",\"Hand-rolled structural reed-weaving ceilings\",\"Fully solar powered grid storage network\",\"Preconditioned copper-accented master bath fixtures\"]',
  -8.64700000,
  115.13800000,
  'agent-clara',
  0,
  1
),
(
  'prop-sayan-ridge',
  'The Sayan Ridge Pavilion',
  'luxury-villas-bali',
  'villas',
  'Sayan Ridge, Ubud, Bali',
  'Bali',
  24200000000,
  4,
  4.5,
  5900,
  '2.1 Acres',
  2024,
  'https://images.unsplash.com/photo-1613490493576-7fde63acd811?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1613490493576-7fde63acd811?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600607687920-4e2a09cf159d?auto=format&fit=crop&q=80&w=1200\"]',
  'Suspended Forest Geometry',
  'Seated on Ubud\'s most premium valley ridge, this masterpiece features dramatic raw concrete cantilevers projecting boldly over the sacred Ayung River canopy. The design leverages physical elevation, framing a flawless floor-to-ceiling emerald forest panorama.\n\nFrom the entry portal, a suspended stone bridge draws guests across a tranquil rainwater filtration stream into a central soaring visual atrium.',
  '[\"Cantilevered 25-meter black basalt infinity lap pool\",\"Subterranean volcanic thermal wellness studio\",\"Solid custom-carved volcanic rock fireplace\",\"Daikin VRV soundless indoor cooling integration\",\"Integrated secure multi-tiered panic room setup\"]',
  -8.50200000,
  115.24100000,
  'agent-alistair',
  1,
  1
),
(
  'prop-jakarta-residence',
  'The Menteng Penthouse',
  'apartments-jakarta',
  'apartments',
  'Menteng, South Jakarta',
  'Jakarta',
  12500000000,
  3,
  3.5,
  4800,
  NULL,
  2022,
  'https://images.unsplash.com/photo-1545324418-cc1a3fa10c00?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1545324418-cc1a3fa10c00?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?auto=format&fit=crop&q=80&w=1200\"]',
  'Sovereignty Above the Sky',
  'Soaring high above the historic leafy enclave of Menteng, this exclusive duplex penthouse is designed for the discerning individual who values urban privacy. High ceilings and custom structural steel frame panoramic city views.',
  '[\"Private high-speed keycard elevator\",\"Double-height soaring formal parlor\",\"Honed Calacatta gold marble countertops\",\"State-of-the-art secure entry system\",\"24-hour dedicated resident concierge\"]',
  -6.20800000,
  106.83200000,
  'agent-hiroshi',
  1,
  0
),
(
  'prop-senopati-tower',
  'Minimalist High-Rise Loft',
  'apartments-jakarta',
  'apartments',
  'Senopati, Jakarta',
  'Jakarta',
  4900000000,
  2,
  2,
  2100,
  NULL,
  2023,
  'https://images.unsplash.com/photo-1560448204-e02f11c3d0e2?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1560448204-e02f11c3d0e2?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1502672260266-1c1ef2d93688?auto=format&fit=crop&q=80&w=1200\"]',
  'Industrial Architectural Purity',
  'Exposed architectural concrete columns meet refined walnut timber floors in this high-floor studio penthouse. Large commercial windows flood the living area with soft natural northern orientation light.',
  '[\"Floor-to-ceiling panoramic glass facade\",\"Solid smoked oak solid hardwood floors\",\"Danish minimalist custom kitchen setup\",\"Climate control layout by Daikin\"]',
  -6.22300000,
  106.80800000,
  'agent-hiroshi',
  0,
  1
),
(
  'prop-jakarta-scbd-obsidian',
  'The SCBD Obsidian Loft',
  'apartments-jakarta',
  'apartments',
  'SCBD, Jakarta',
  'Jakarta',
  32000000000,
  3,
  3.5,
  4200,
  NULL,
  2024,
  'https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1502672017483-70b180ee4b36?auto=format&fit=crop&q=80&w=1200\"]',
  'Gilded Urban Minimalism',
  'Located at the absolute center of Jakarta\'s premier financial cluster. The Obsidian Loft employs dark sound-blocking triple-glazed glass panes and structural matte-black steel framework to isolate the resident from industrial city hums.\n\nThe penthouse includes a fully automated command desk, secure mechanical keycard parking access, and an open-air dynamic sky parlor.',
  '[\"Integrated fingerprint security system by Assa Abloy\",\"Private sky parlor with fireplace and heated pool\",\"Sound-damped walnut study quarters\",\"Substandard 2-car subterranean mechanical lift vault\",\"German high-end structural kitchen hardware by Gaggenau\"]',
  -6.22500000,
  106.81100000,
  'agent-hiroshi',
  1,
  1
),
(
  'prop-jakarta-kemang-canopy',
  'The Kemang Canopy Villa',
  'houses-jakarta',
  'houses',
  'Kemang South, Jakarta',
  'Jakarta',
  18500000000,
  5,
  5.5,
  6800,
  '0.6 Acres',
  2023,
  'https://images.unsplash.com/photo-1580587771525-78b9dba3b914?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1580587771525-78b9dba3b914?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1582268611958-ebfd161ef9cf?auto=format&fit=crop&q=80&w=1200\"]',
  'Tropical Urban Canopy',
  'A gorgeous luxury estate that introduces raw rainforest elements into suburban South Jakarta. Centered around a massive protected Bodhi tree, the structure divides into separate pavilions connected by raised timber skyways.\n\nEvery bedroom features private garden orientation slots, while the central reception features double-height board-formed concrete and a monolithic stone water basin.',
  '[\"Raised ironwood timber forest walks\",\"Salt-treated slate stone courtyard swimming pool\",\"Fully soundproofed underground private theater\",\"Custom integrated climate cooling and air purification\",\"Dedicated 24/7 client-concierge security guard lodge\"]',
  -6.27300000,
  106.81600000,
  'agent-clara',
  0,
  1
),
(
  'prop-surabaya-famili',
  'The Graha Sanctuary',
  'houses-surabaya',
  'houses',
  'Graha Famili, Surabaya',
  'Surabaya',
  8200000000,
  6,
  6.5,
  8500,
  '0.8 Acres',
  2021,
  'https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600210492486-724fe5c67fb0?auto=format&fit=crop&q=80&w=1200\"]',
  'Contemporary Oasis in East Java',
  'Positioned within the most prestigious gated avenue of Graha Famili, this custom structural concrete mansion integrates indoor courtyards and Koi ponds with spacious family dynamic zones.',
  '[\"Three interconnected internal courtyard layouts\",\"Dual temperature commercial wet and dry kitchen\",\"Custom basalt stone internal pathways\",\"Automated subterranean sprinkler systems\",\"Private multi-car underground gallery\"]',
  -7.28800000,
  112.68400000,
  'agent-alistair',
  1,
  0
),
(
  'prop-citraland-villa',
  'The White Pavilion',
  'houses-surabaya',
  'houses',
  'Citraland, Surabaya',
  'Surabaya',
  6100000000,
  4,
  4.5,
  5200,
  '0.5 Acres',
  2023,
  'https://images.unsplash.com/photo-1600585154526-990dced4db0d?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600585154526-990dced4db0d?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600607687920-4e2a09cf159d?auto=format&fit=crop&q=80&w=1200\"]',
  'Classic Architectural Proportions',
  'A gorgeous study of natural shadows, classical lines, and stark white masonry. Perfect vertical columns frame high glass windows overlooking a manicured formal European-style garden.',
  '[\"Triple height formal entry atrium\",\"Preconditioned solid teak doors and fittings\",\"Italian Travertine stone floors throughout\",\"Bespoke security and panic room suite\"]',
  -7.29100000,
  112.64500000,
  'agent-clara',
  0,
  1
),
(
  'prop-surabaya-dharmahusada',
  'Dharmahusada Monolith',
  'houses-surabaya',
  'houses',
  'Dharmahusada, Surabaya',
  'Surabaya',
  15600000000,
  5,
  5,
  7200,
  '0.9 Acres',
  2022,
  'https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600566753376-12c8ab7fb75b?auto=format&fit=crop&q=80&w=1200\"]',
  'Brutalist Urban Sanctuary',
  'Crafted as a solid geometric shield against the Surabaya heat, this Dharmahusada sanctuary combines monolithic volcanic stone slabs and raw structural board-formed concrete. The house is centered around a quiet cooling courtyard pool and continuous natural-flowing stream canals.\n\nAll glass facades are recessed deeply from sunlight angles to control climatic impacts without sacrificing organic view currents.',
  '[\"Custom basalt stone internal water conduits\",\"Massive raw timber dynamic double-height sliding screens\",\"Deeply recessed heat-insulated clear glass panes\",\"Subterranean gallery for 6 curated vehicles\",\"Professional stainless steel chef dry and wet ranges\"]',
  -7.26500000,
  112.77100000,
  'agent-alistair',
  1,
  1
),
(
  'prop-bandung-dago',
  'The Dago Creative Pavilion',
  'commercial-property-bandung',
  'commercial',
  'Dago Hills, Bandung',
  'Bandung',
  11200000000,
  0,
  4,
  9400,
  '1.1 Acres',
  2022,
  'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1497366216548-37526070297c?auto=format&fit=crop&q=80&w=1200\"]',
  'A Monument of Pine and Concrete',
  'This architectural marvel in the cool hills of Dago serves as an premier design studio or high-end commercial headquarters. Crafted from raw concrete, and local structural pine louvers that filter natural daylight.',
  '[\"Award-winning passive ventilation framework\",\"Soaring cantilevered open-air studio tier\",\"Pine daylight-directing external louvres\",\"High capacity optical fiber connection framework\",\"40-vehicle secure parking zone\"]',
  -6.86800000,
  107.62100000,
  'agent-alistair',
  1,
  0
),
(
  'prop-bandung-braga',
  'Braga Heritage Studio',
  'commercial-property-bandung',
  'commercial',
  'Braga, Central Bandung',
  'Bandung',
  5400000000,
  0,
  2,
  4100,
  '0.3 Acres',
  1930,
  'https://images.unsplash.com/photo-1497215728101-856f4ea42174?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1497215728101-856f4ea42174?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1497366811353-6870744d04b2?auto=format&fit=crop&q=80&w=1200\"]',
  'Dutch-Indies Minimalist Revival',
  'Originally built in 1930, this Braga gem was lovingly updated in 2024 by an award-winning local architect. Perfect structural preservations meet hyper-modern polished concrete and black metal frames.',
  '[\"Strict preservation of 1930 structural facade\",\"Modern high-voltage energy grid infrastructure\",\"Internal tranquil Zen garden courtyard\",\"Double insulated structural glass barriers\"]',
  -6.91800000,
  107.60900000,
  'agent-clara',
  0,
  1
),
(
  'prop-bandung-dago-peak',
  'Dago Peak Glass Atelier',
  'commercial-property-bandung',
  'commercial',
  'Dago Pakar, Bandung',
  'Bandung',
  19800000000,
  4,
  4.5,
  8100,
  '1.4 Acres',
  2024,
  'https://images.unsplash.com/photo-1497366216548-37526070297c?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1497366216548-37526070297c?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1497215842964-222b430db094?auto=format&fit=crop&q=80&w=1200\"]',
  'High-Altitude Creative Atelier',
  'Seated at the absolute peak of Dago Pakar, this atelier features soaring vertical steel columns and continuous low-iron structural glass walls overlooking the entire Bandung mountain basin.\n\nDesigned primarily for high-end advisory, galleries, or creative workspace layouts, it provides absolute private retreat capabilities balanced with dramatic panoramic reception spaces.',
  '[\"Continuous 360-degree high-altitude ridge line vistas\",\"Passive solar climate heating and natural timber ventilation\",\"Custom structural fire pit pavilion seating 24 guests\",\"Secure encrypted fiber data integration pipelines\",\"Dedicated helipad accessibility blueprint\"]',
  -6.85200000,
  107.63500000,
  'agent-clara',
  1,
  1
),
(
  'prop-bali-nusadua-cliff',
  'Nusa Dua Cliff Sanctum',
  'luxury-villas-bali',
  'villas',
  'Nusa Dua Heights, Bali',
  'Bali',
  17500000000,
  5,
  5.5,
  5800,
  '1.1 Acres',
  2024,
  'https://images.unsplash.com/photo-1540555700478-4be289fbecef?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1540555700478-4be289fbecef?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1512917774080-9991f1c4c750?auto=format&fit=crop&q=80&w=1200\"]',
  'Ocean-Facing Minimalist Monolith',
  'Perched on a high cliff in Nusa Dua, this villa offers unparalleled views of the Indian Ocean. Designed with floor-to-ceiling glass and pristine white limestone walls, it blends seamless architecture with natural beauty. Large terraces, open pavilion lounges, and a 20-meter infinity pool provide an exquisite sanctuary for luxury living.',
  '[\"Panoramic cliffside ocean views\",\"20-meter heated saltwater infinity pool\",\"Limestone structural masonry\",\"Italian marble floors\",\"Smart climate control system\"]',
  -8.80500000,
  115.22800000,
  'agent-clara',
  1,
  1
),
(
  'prop-jakarta-sudirman-crown',
  'Sudirman Crown Duplex',
  'apartments-jakarta',
  'apartments',
  'Sudirman Central, Jakarta',
  'Jakarta',
  41000000000,
  4,
  4.5,
  5600,
  NULL,
  2025,
  'https://images.unsplash.com/photo-1502672260266-1c1ef2d93688?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1502672260266-1c1ef2d93688?auto=format&fit=crop&q=80&w=1200\"]',
  'Sovereign Heights Above the City',
  'Located on the highest floor of the Sudirman residential tower, this duplex penthouse features double-height ceilings, a private glass pool, and customized German kitchen systems. A stunning statement of vertical luxury and city center convenience.',
  '[\"Double-height ceiling gallery\",\"Private swimming pool in the sky\",\"Bespoke kitchen by Poggenpohl\",\"Dedicated private elevator entrance\",\"Fully integrated automated home system\"]',
  -6.21500000,
  106.82100000,
  'agent-hiroshi',
  1,
  1
),
(
  'prop-jakarta-pondokindah-mansion',
  'The Pondok Indah Monolith',
  'houses-jakarta',
  'houses',
  'Pondok Indah, South Jakarta',
  'Jakarta',
  29000000000,
  5,
  6,
  7500,
  '0.7 Acres',
  2023,
  'https://images.unsplash.com/photo-1600585154340-be6161a56a0c?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600585154340-be6161a56a0c?auto=format&fit=crop&q=80&w=1200\",\"https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?auto=format&fit=crop&q=80&w=1200\"]',
  'Modernist Brutalist Courtyard',
  'Crafted from board-formed concrete and warm Indonesian teak, this sprawling Pondok Indah estate centers around an indoor tropical forest courtyard. Massive sliding glass walls connect the master suite directly to a stone-lined lap pool.',
  '[\"Central tropical garden courtyard\",\"Hand-crafted teak wood ceilings\",\"Subterranean gallery for 5 cars\",\"Private yoga studio and spa area\",\"State-of-the-art security room\"]',
  -6.26200000,
  106.78300000,
  'agent-clara',
  0,
  1
),
(
  'prop-surabaya-kertajaya-mansion',
  'The Kertajaya Pavilions',
  'houses-surabaya',
  'houses',
  'Kertajaya Indah, Surabaya',
  'Surabaya',
  13200000000,
  5,
  5,
  6400,
  '0.6 Acres',
  2024,
  'https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?auto=format&fit=crop&q=80&w=1200\"]',
  'Teak and Basalt Sanctuary',
  'This luxury estate blends modern structural minimalism with traditional East Javanese privacy. Constructed around deep water channels and Zen stone gardens, the pavilions keep the living spaces naturally cool and serene.',
  '[\"Solid volcanic rock features\",\"Deep cooling water channels\",\"Wet and dry kitchen arrays\",\"Teak timber louvers for solar protection\",\"Full home automation network\"]',
  -7.27500000,
  112.78400000,
  'agent-alistair',
  0,
  1
),
(
  'prop-bandung-dago-pavilion',
  'Dago Pine Creative Labs',
  'commercial-property-bandung',
  'commercial',
  'Dago Atas, Bandung',
  'Bandung',
  16800000000,
  0,
  5,
  8900,
  '1.2 Acres',
  2023,
  'https://images.unsplash.com/photo-1497366216548-37526070297c?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1497366216548-37526070297c?auto=format&fit=crop&q=80&w=1200\"]',
  'Biophilic Design Hub',
  'Suspended over a pine-wooded valley in Dago, this commercial compound is designed for high-end operations, art galleries, or creative agencies. Featuring double-insulated glass walls and a passive biophilic air-recycling system.',
  '[\"Passive biophilic air-ventilation system\",\"360-degree pine valley views\",\"Cantilevered floating boardroom\",\"Solar power grid integration\",\"30-car parking spaces\"]',
  -6.85800000,
  107.62500000,
  'agent-hiroshi',
  0,
  1
),
(
  'prop-bandung-pakar-retreat',
  'Dago Pakar Corporate Retreat',
  'commercial-property-bandung',
  'commercial',
  'Dago Pakar, Bandung',
  'Bandung',
  21500000000,
  4,
  4.5,
  7900,
  '1.5 Acres',
  2024,
  'https://images.unsplash.com/photo-1600585154526-990dced4db0d?auto=format&fit=crop&q=80&w=1200',
  '[\"https://images.unsplash.com/photo-1600585154526-990dced4db0d?auto=format&fit=crop&q=80&w=1200\"]',
  'Brutalist Corporate Escape',
  'A multi-use luxury architectural project perched on Dago Pakar. Designed with bold raw concrete slabs and floor-to-ceiling glass, this hybrid compound offers an ultra-premium executive retreat, client showroom, and living suites.',
  '[\"Raw board-formed concrete structure\",\"Heated outdoor mineral springs pool\",\"Stunning panoramic city lights view\",\"Secure server rooms and satellite uplinks\",\"Chef-standard executive dining room\"]',
  -6.84800000,
  107.63200000,
  'agent-alistair',
  1,
  1
);