Find Your Perfect Companion

Connect loving pets with caring families through adoption and fostering

Happy pets

7

Pets Available

0

Successful Adoptions

0

Pets in Foster Care

2

Community Members

How It Works

Browse Pets

Explore our database of wonderful pets looking for homes

Apply

Submit an adoption or foster application for your chosen pet

Meet & Greet

Meet your potential new family member in person

Take Home

Welcome your new furry friend to their forever home

SQL Queries Used on This Page

×

Query 1:

SELECT p.*, 
        CASE 
            WHEN p.status = 'available' THEN 'Available for Adoption'
            WHEN p.status = 'adopted' THEN 'Adopted'
            WHEN p.status = 'fostered' THEN 'Currently Fostered'
            ELSE p.status
        END as status_text
        FROM pets p 
        WHERE p.status = 'available' 
        ORDER BY p.created_at DESC 
        LIMIT 6

Query 2:

SELECT 
    (SELECT COUNT(*) FROM pets WHERE status = 'available') as available_pets,
    (SELECT COUNT(*) FROM pets WHERE status = 'adopted') as adopted_pets,
    (SELECT COUNT(*) FROM pets WHERE status = 'fostered') as fostered_pets,
    (SELECT COUNT(*) FROM users WHERE role = 'adopter') as total_adopters