Back to Browse
Charlie
Available for Adoption

Charlie

Labrador Mix

Species Dog
Age 4 years old
Gender Male
Size Large
Location South Town Shelter
Listed Aug 26, 2025

About Charlie

Gentle giant who loves long walks and treats. Charlie has a calm temperament and is great with people of all ages. He would be an excellent therapy dog candidate due to his gentle nature.

Health Information

Neutered, microchipped. Recent blood work shows perfect health. Heartworm negative and on monthly prevention.

Similar Pets You Might Like

mitul

mitul

pug

3 years Male
View Details
Buddy

Buddy

Golden Retriever

3 years Male
View Details
Max

Max

German Shepherd

5 years Male
View Details

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.pet_id = ?

Query 2:

SELECT pet_id, name, breed, age, gender, photo_url, status 
                FROM pets 
                WHERE species = ? AND pet_id != ? AND status = 'available' 
                ORDER BY RAND() 
                LIMIT 4