ReactViteSupabasePostgreSQLReact RouterVercelReal Estate PlatformReal Estate AdvisoryPune Real EstateResponsive DesignLead Management
VPP Realtech - Real Estate Platform
A modern real estate advisory and listing platform for Pune, built with React, Vite, and Supabase to showcase verified projects and capture high-intent property enquiries.
Project Overview
VPP Realtech is a full-stack real estate platform designed for property buyers and developers in Pune. It combines a fast React + Vite frontend with Supabase-backed authentication, database, and storage to manage projects, mandates, blogs, and customer leads in a single, scalable system.
Key Features & Functionality
🏠Public Experience
- Projects Showcase: Browse RERA-verified real estate projects across Pune.
- Mandates Listing: Highlight exclusive developer mandates and sole-selling partnerships.
- Real Estate Blog: Articles and insights on locations, pricing, and investments.
- Advanced Filtering: Search properties by location, property type, budget, and status.
- Lead Capture Forms: Contact and enquiry forms with WhatsApp integration.
- Responsive, mobile-first UI for buyers researching on phones and tablets.
🛠️Admin & Operations
- Secure Authentication: Supabase Auth-protected admin area.
- Admin Dashboard: Snapshot of leads, projects, and content performance.
- Project Management: CRUD operations for real estate projects and key metadata.
- Mandate Management: Track exclusive mandates and developer relationships.
- Blog Management: Create, edit, and publish blog posts.
- Lead Management: Store and track enquiries from multiple entry points.
🔐Security & Reliability
- Row Level Security on all core tables with role-based access rules.
- Public read access for published content and restricted writes for admins.
- Environment-variable driven configuration for sensitive keys and URLs.
- Hardened image upload flow using Supabase Storage policies.
Technology Stack
Frontend
- React 19 with Vite: Modern SPA architecture for fast navigation and DX.
- Vanilla CSS with CSS Variables: Lightweight styling with a consistent design system.
- React Router v7: Client-side routing for public and admin sections.
- Responsive layout tuned for mobile, tablet, and desktop breakpoints.
Backend & Database
- Supabase: Managed backend combining PostgreSQL, Auth, and Storage.
- PostgreSQL: Structured relational database for projects, blogs, leads, and contacts.
- Row Level Security (RLS): Table-level security policies for safe multi-role access.
Platform & Services
- Supabase Storage: Public bucket for project and blog imagery.
- Supabase Auth: Secure email/password authentication for admin users.
- WhatsApp Integration: Lead handoff via direct WhatsApp contact.
- Vercel: Production-grade deployment optimized for static assets and SPA routing.
Developer Experience
- Environment-driven configuration via VITE_ variables for Supabase and WhatsApp.
- SQL schema file (supabase-schema.sql) for reproducible database setup.
- Clear project structure with separated services, hooks, and pages.