Available for Adoption

mitul

pug

Species Dog

Age 3 years old

Gender Male

Size Small

Location dhaka

Listed Aug 26, 2025

About mitul

good dog with good loking black colour

Health Information

in very good condation.

Similar Pets You Might Like

Max

German Shepherd

5 years Male

View Details

Charlie

Labrador Mix

4 years Male

View Details

Buddy

Golden Retriever

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