Back to Browse
Buddy
Available for Adoption

Buddy

Golden Retriever

Species Dog
Age 3 years old
Gender Male
Size Large
Location Downtown Shelter
Listed Aug 26, 2025

About Buddy

Friendly and energetic dog who loves playing fetch and swimming. He gets along well with children and other pets, making him an ideal family companion. Buddy enjoys outdoor activities and would thrive in a home with a yard where he can play and exercise.

Health Information

Vaccinated, neutered, microchipped. Recent health check shows excellent condition. Up to date on all vaccinations including rabies, DHPP, and Bordetella.

Similar Pets You Might Like

Charlie

Charlie

Labrador Mix

4 years Male
View Details
Max

Max

German Shepherd

5 years Male
View Details
mitul

mitul

pug

3 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