lyle agreda

lyle agreda project case studies

home →

full-stack project case studies

All 13 projects by Lyle Agreda, a software developer, web developer, and app developer in Malaybalay City, Bukidnon — from public-service platforms and healthcare systems to business websites, hospitality experiences, and real estate operations.

Ideas into working experiences.

From community systems to business websites. Explore the work, from the first project to the latest.

the project indexselect a project to explore
01 Public servicesOne Dalwangan HubA digital front desk for the barangay.Deployed
One Dalwangan Hub project screenshot

01 / Public services

One Dalwangan Hub

An installable barangay service platform bringing document requests, incident reporting, announcements, and request tracking into one place.

Purpose

Make essential local services easier to access, especially for residents using mobile devices or limited connectivity.

Inside the project

  • Reference-based request tracking and document verification.
  • GPS-assisted incident submissions and offline-ready access.

Tech stack

Next.jsReactTypeScriptPostgreSQLSupabaseLeafletPWA

Security & operations

RBACTOTPCSRF protectionEncrypted resident dataWeb PushStaff admin portal
02 HealthcareSmart Health IntegrationConnected records. Better coordinated care.Deployed
Smart Health Integration project screenshot

02 / Healthcare

Smart Health Integration

AI-DSUHIS is a unified health information system for Malaybalay City, Bukidnon, supporting structured health records and data-informed service coordination.

Purpose

Help healthcare and LGU teams organize information and coordinate services through accessible, role-based workflows.

Inside the project

  • System analysis, database design, interface development, and documentation.
  • Health information modules with analytics and offline synchronization.

Tech stack

FlutterDartFirebaseCloud FirestoreSQLiteGetXFL ChartGoogle ML Kit

Security & operations

Firebase AuthenticationFirebase App CheckCloud FunctionsOffline syncSecure local storage
03 Food & hospitalityAthena’s Best Catering ServicesFrom finding a menu to planning a celebration.Deployed
Athena’s Best Catering Services project screenshot

03 / Food & hospitality

Athena’s Best Catering Services

A digital storefront for a home-based catering business, organizing food packages, pricing, and an ordering journey around real customer needs.

Purpose

Make catering options easier to compare and help customers plan an order with clear package information.

Inside the project

  • Curated food packages and transparent pricing.
  • Guided browsing and ordering suited to the business’s booking process.

Tech stack

ReactTypeScriptViteTailwind CSSLeafletZod

Security & operations

Cloudflare WorkersCloudflare TurnstileRate limitingServer-side price validationGoogle Sheets orders
04 Real estateProSmart Estate Web PlatformA clearer path from property discovery to inquiry.Deployed
ProSmart Estate Web Platform project screenshot

04 / Real estate

ProSmart Estate Web Platform

A business-facing real estate website presenting properties, company information, and inquiry pathways in a responsive interface.

Purpose

Strengthen the company’s digital presence and help prospective clients find properties and start a conversation.

Inside the project

  • Property presentation and location-based discovery.
  • Inquiry capture and organized business content.

Tech stack

ReactViteTailwind CSSFramer MotionLeafletReact RouterReact Icons

Security & operations

SendGridNodemailerVercel deployment
05 Tourism operationsTourism Accommodation & Booking ManagementOrganized stays, reservations, and availability.Proposed but 100% functional
Tourism Accommodation & Booking Management project screenshot

05 / Tourism operations

Tourism Accommodation & Booking Management

An accommodation management platform combining property listings, reservations, and role-based dashboards for clients, owners, and administrators.

Purpose

Bring accommodation operations into a shared workflow so staff can manage listings, availability, and bookings more consistently.

Inside the project

  • Listing and reservation management with owner and admin views.
  • Booking tracking and customer communication.

Tech stack

LaravelPHPBladeAlpine.jsTailwind CSS

Security & operations

Laravel BreezeSpatie PermissionSpatie MultitenancyRedisStripeDomPDFQR Code
06 Tourism & governmentTourism Destination Management & BookingOne place to discover destinations and manage visits.Proposed but 100% functional
Tourism Destination Management & Booking project screenshot

06 / Tourism & government

Tourism Destination Management & Booking

A tourism platform for destination promotion, visitor booking, and municipal reporting, connecting the public browsing experience with management tools.

Purpose

Help visitors plan trips while giving tourism staff an organized view of bookings and visitor activity.

Inside the project

  • Destination discovery, booking forms, and reference tracking.
  • Visitor analytics and downloadable management reports.

Tech stack

LaravelPHPBladeMySQLChart.js

Security & operations

Laravel SanctumGoogle API ClientDomPDFQR CodeRole-based adminServer-side validation
07 Legal servicesLaw Offices of Jay BernsteinA professional presence built around client inquiries.Deployed
Law Offices of Jay Bernstein project screenshot

07 / Legal services

Law Offices of Jay Bernstein

A law firm website presenting immigration, litigation, family law, and trial practice services through dedicated practice-area pages.

Purpose

Help prospective clients understand the firm’s services and make a consultation inquiry with confidence.

Inside the project

  • Focused practice-area pages and clear service navigation.
  • Responsive contact experience with spam-protected submissions.

Tech stack

HTMLCSSJavaScriptNode.jsVercel

Security & operations

Cloudflare TurnstileResendCSRF protectionRate limitingCSPHSTS
08 Student welfare · web + mobileBukSU KaubanWeb platform with Android and iOS apps.Deployed
BukSU Kauban project screenshot

08 / Student welfare · web + mobile

BukSU Kauban

A student welfare and engagement platform for BukSU available as a web platform with companion Android and iOS apps, pairing a public information portal with private student profiles and appointment scheduling.

Purpose

Give students a clear, accessible way to connect with campus support and manage their appointments across web and mobile.

Inside the project

  • Verified email sign-in and private appointment management.
  • A web platform plus Android and iOS apps sharing the same student support experience.

Tech stack

ReactViteExpressPostgreSQLCapacitorAndroidiOS

Security & operations

Email OTPHttpOnly sessionsAndroid KeystoreiOS KeychainRBACResendGoogle CalendarRate limitingProtected admin APIAudit logs
09 Public serviceKonsehala Cecille PagalingA public record made easier to explore.Deployed
Konsehala Cecille Pagaling project screenshot

09 / Public service

Konsehala Cecille Pagaling

A public service portfolio organizing legislative records, community programs, partnerships, and engagements for Councilor Kathleen Cecille Pagaling.

Purpose

Make the councilor’s work easier for residents to understand through an organized, accessible public accomplishment record.

Inside the project

  • Browsable ordinances, resolutions, and community initiatives.
  • Engagement gallery, partnerships, and transparency information.

Tech stack

HTMLCSSJavaScript

Security & operations

CSPPermissions PolicyHTTPSSecurity headers
10 Business consultancyCloud Consultancy ServicesTurning complex services into clear next steps.Deployed
Cloud Consultancy Services project screenshot

10 / Business consultancy

Cloud Consultancy Services

A consultancy website presenting business registration, regulatory support, documentation, and operational services in a structured service catalog.

Purpose

Help business owners identify relevant support and move from exploring services to requesting a consultation.

Inside the project

  • Dedicated service information and a clear consultation pathway.
  • Company approach, client segments, and business insights.

Tech stack

Next.jsReactTypeScriptTailwind CSSMotionD3 GeoTopoJSONLucide

Security & operations

CSPHSTSPermissions PolicyVercel
11 Beauty & wellnessChrisz Aesthetics & Beauté SpotExplore treatments. Build a personalized visit.Deployed
Chrisz Aesthetics & Beauté Spot project screenshot

11 / Beauty & wellness

Chrisz Aesthetics & Beauté Spot

An aesthetics clinic website with a searchable treatment catalog, transparent pricing, client results, and a guided appointment request experience.

Purpose

Help clients compare treatments and assemble an appointment request while making the clinic’s services easier to navigate on mobile.

Inside the project

  • Treatment search and category browsing with persistent selections.
  • Step-by-step appointment requests and same-origin inquiry routes.

Tech stack

SvelteKitSvelteJavaScriptViteVercel

Security & operations

ResendAdmin API keyRate limitingCSPHSTSSame-origin APIsAdmin studio desk
12 Travel & hospitalityTulganan sa DahilayanA welcoming first look at a mountain stay.Proposed but 100% functional
Tulganan sa Dahilayan project screenshot

12 / Travel & hospitality

Tulganan sa Dahilayan

A homestay website showcasing rooms, rates, amenities, and property photos, with a date-and-guest selection flow for planning a stay in Dahilayan.

Purpose

Help families and groups understand the accommodation, compare room options, and prepare a booking inquiry.

Inside the project

  • Room details, rates, property gallery, and local travel information.
  • Responsive stay planning with date and guest selection.

Tech stack

Next.jsReactTypeScriptTailwind CSSMotiondate-fnsReact Day PickerLucideSonner

Security & operations

VercelDate availability validationBooking workflow
13 Real estate & operationsMindanao Properties by Prestigious Real Estate Management ServicesProperty discovery and operations for Malaybalay and Bukidnon.Deployed
Mindanao Properties by Prestigious Real Estate Management Services project screenshot

13 / Real estate & operations

Mindanao Properties by Prestigious Real Estate Management Services

A production real estate platform combining public property discovery with inquiry and viewing flows, media management, and an authenticated operations workspace for Prestigious Real Estate Management Services.

Purpose

Make property discovery more transparent while giving the real estate team a safer, structured workflow for listings and client operations.

Inside the project

  • URL-backed property catalog with pricing, availability, detail pages, and responsive inquiry and viewing flows.
  • Internal operations workspace for properties, media, inquiries, viewings, reports, notifications, and role-aware workflows.

Tech stack

ViteReactTypeScriptReact RouterSupabasePostgreSQLSupabase StorageCloudflare WorkersZodMotion

Security & operations

Supabase AuthPostgreSQL RLSRole-aware authorizationAllowlisted RPC commandsCloudflare TurnstileDistributed rate limitingStrict CORS allowlistCSP noncesHSTSPrivate media storageServer-side validationIdempotent inquiriesAudit logs
Deployed