Filter By
     
SELECT * FROM ipa_wp_posts LEFT JOIN ipa_wp_postmeta AS pm ON( ipa_wp_posts.ID = pm.post_id AND pm.meta_key = 'pet_listings_listing_type' ) LEFT JOIN ipa_wp_postmeta AS pm1 ON( ipa_wp_posts.ID = pm1.post_id AND pm1.meta_key = 'pet_listings_date_lost_found' ) LEFT JOIN ipa_wp_postmeta AS pm2 ON( ipa_wp_posts.ID = pm2.post_id AND pm2.meta_key = 'pet_listings_listing_status' ) LEFT JOIN ipa_wp_postmeta AS pm3 ON( ipa_wp_posts.ID = pm3.post_id AND pm3.meta_key = 'pet_listings_shelterid' ) WHERE ipa_wp_posts.post_status = 'publish' AND ipa_wp_posts.post_type = 'pet_listings' AND pm.meta_value = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Westgate
Found: 10/8/2020
ID: 15180
Name: Jabba
Type: Dog
Color: Black and brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
Dog is chipped but was re homed and new owner did not register him
Des Moines - Central
Found: 10/8/2020
ID: 15164
Name:
Type: Dog
Color: Tri color
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Found: 10/8/2020
ID: 15158
Name:
Type: Dog
Color: Brown and cream
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/8/2020
ID: 15157
Name:
Type: Dog
Color: Grey
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/7/2020
ID: 15150
Name:
Type: Dog
Color: white
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Ashworth Road and 40th Street
Grimes
Found: 10/7/2020
ID: 15149
Name: Lydia
Type: Cat
Color: White and grey, some black
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Around SE 35th St in Grimes, Iowa near Cutty's/Johnston area
Des Moines - North
Found: 10/6/2020
ID: 15146
Name:
Type: Dog
Color: Brown white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Pit mix skittish but a good boy. Call me and come get him if he is yours
West Des Moines
Found: 10/5/2020
ID: 15136
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/4/2020
ID: 15135
Name:
Type: Dog
Color: White and Tan
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Johnston
Found: 10/4/2020
ID: 15134
Name: Unknown
Type: Cat
Color: Black with a white patch on it's chest and 2 white spots on it's tummy
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Very friendly but can tell it is scared a little. Kept it segregated from the rest of the cats last night to make it feel more comfortable. I will be taking this kitty to my vet today to see if he/she has a chip and determine what sex it is. I think it is female but not sure. Found on Hyperion Point in Johnston.
West Des Moines
Found: 10/4/2020
ID: 15128
Name:
Type: Dog
Color: white
Breed: Poodle
Gender: Male
Fixed: Not Neutered
Age: Adult
600 block of 17th street, found with small tricolor terrier mix
West Des Moines
Found: 10/4/2020
ID: 15127
Name:
Type: Dog
Color: Black, White and tan tricolor
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
600 block of 17th street, found with a small, white poodle mix
Urbandale
Found: 10/4/2020
ID: 15125
Name:
Type: Cat
Color: Black, white flecks in fur
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
12800 block of Walnut Ridge
West Des Moines
Found: 10/4/2020
ID: 15124
Name: Queen
Type: Cat
Color: Brown & White Tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Pointe West Apartments
Waukee
Found: 10/3/2020
ID: 15152
Name:
Type: Cat
Color: Gray
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Found: 10/3/2020
ID: 15118
Name:
Type: Dog
Color: Fawn
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
600 block Boston Ave
Clive
Found: 10/1/2020
ID: 15104
Name:
Type: Dog
Color: Tan & White
Breed: Mastiff
Gender: Male
Fixed: Unknown
Age: Adult
Near Crestview School
Des Moines - South
Found: 9/30/2020
ID: 15096
Name: Otto
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 9/30/2020
ID: 15093
Name:
Type: Dog
Color: Tan & Black
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
600 block of Maple Street
West Des Moines
Found: 9/30/2020
ID: 15091
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
200 block of 27th street
West Des Moines
Found: 9/29/2020
ID: 15087
Name: Sassy
Type: Dog
Color: Red
Breed: Dachshund-Miniature
Gender: Unknown
Fixed: Not Neutered
Age: Senior
Last seen at home.
Elkhart
Found: 9/28/2020
ID: 15083
Name:
Type: Cat
Color: Brown and white
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Baby
Elkhart
Found: 9/28/2020
ID: 15082
Name:
Type: Cat
Color: Brown and white
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
Clive
Found: 9/28/2020
ID: 15076
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Urbandale
Found: 9/27/2020
ID: 15073
Name:
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Front declawed