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 = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 8/29/2021
ID: 17588
Name: Orlando
Type: Cat
Color: brown and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Brown and white male tabby. He is very docile. He is declawed. He weighs about 8-9lbs and is a senior cat.
Des Moines - East
Lost: 8/29/2021
ID: 17582
Name: Bandit
Type: Dog
Color: Yello/white
Breed: Akita
Gender: Male
Fixed: Neutered
Age: Adult
Fairgrounds neighborhood. Went missing with black and white pitbull puppy
New Albin
Lost: 8/29/2021
ID: 17581
Name: Lucky
Type: Dog
Color: White and black
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Senior
New Albin area..by historical church in country
Des Moines - Central
Lost: 8/29/2021
ID: 17579
Name: Buttons
Type: Dog
Color: Black brown and white
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Adult
She is very nice. She got out last night around grandview university
Nashua
Lost: 8/28/2021
ID: 17586
Name: Willow
Type: Dog
Color: Red/Brown
Breed: GoldenDoodle
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen @ 830am. Setter took off & she followed. Setter came back home at 1am
Earlham
Lost: 8/26/2021
ID: 17563
Name: Toby
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly
Earlham
Lost: 8/26/2021
ID: 17562
Name: Frank
Type: Dog
Color: White
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
He has a half blue eye. Very friendly
Waterloo
Lost: 8/25/2021
ID: 17688
Name: Nova
Type: Dog
Color: Brown with a tint of black and gray
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
On Newell St.
Des Moines - Central
Lost: 8/24/2021
ID: 17578
Name: Fifi
Type: Cat
Color: Gray tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
Last seen behind Hampton House apartments at 42nd and Grand. No collar. She is microchipped. Friendly.
Des Moines - North
Lost: 8/24/2021
ID: 17556
Name: Aurora
Type: Cat
Color: Calico
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Young
In door cat sneak out around nw 11th and Aurora
Marion
Lost: 8/24/2021
ID: 17554
Name: Roman
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Keosauqua
Lost: 8/23/2021
ID: 17664
Name: Aurora
Type: Dog
Color: Brown-Tan: Black
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Applicable
Age: Young
On Route J40 going towards Pittsburgh. 1 and a half years old gsd.
Des Moines - North
Lost: 8/23/2021
ID: 17559
Name: kitty
Type: Cat
Color: grey and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
last seen at night, responds to kitty or richard most times he’s nice but he’s not an out door cat so he might be freaked out
Maxwell
Lost: 8/23/2021
ID: 17557
Name: Honey
Type: Cat
Color: Multi - Grey/Orange specks
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen by Chichaqua Bottoms. Has seven kittens that are a month old, was still nursing them.
Oakland Acres
Lost: 8/23/2021
ID: 17553
Name: Caesar
Type: Dog
Color: brown and white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Baby
hes only 4 months old and is scared of everything.. he ran off after we were in a car accident
Pleasant Hill
Lost: 8/23/2021
ID: 17549
Name: Precious
Type: Cat
Color: Grey
Breed: Nebelung
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 8/23/2021
ID: 17543
Name: Enzo
Type: Dog
Color: Golden brown
Breed: Coonhound
Gender: Male
Fixed: Unknown
Age: Adult
Last seen at 1am on watrous ave near se14th
Des Moines - South
Lost: 8/22/2021
ID: 17631
Name: Dracula
Type: Cat
Color: Black
Breed: Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
All black has a tiny bit of grey in his long hair. Fluffy legs and tail. Friendly. South side by Easter lake and Ewing park area. Very vocal cat.
Granger
Lost: 8/22/2021
ID: 17547
Name:
Type: Cat
Color:
Breed: Coonhound
Gender: Female
Fixed: Unknown
Age: Baby
Urbandale
Lost: 8/22/2021
ID: 17539
Name: Max
Type: Dog
Color: White
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Clive
Lost: 8/22/2021
ID: 17529
Name: Romeo
Type: Dog
Color: Blonde/golden
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Young
Last seen around forest ave in Clive
West Des Moines
Lost: 8/21/2021
ID: 17546
Name: Payton / Halas
Type: Dog
Color: One brown on black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Oh thanks for saying running east towards 92 W. Apartment in West Des Moines. They were behind global brew/wasabi around the townhomes under new construction. Brown dog and girl. Her name is Payton. Black dog is a boy and his name is Halas.
West Des Moines
Lost: 8/21/2021
ID: 17544
Name: Payton / Halas
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
By townhomes behind Global Brew/Wasabi on University in West Des Moines . Both were running East towards 92 West Apartments around 9pm
West Des Moines
Lost: 8/21/2021
ID: 17526
Name: Tank
Type: Dog
Color: Black/white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen around 12:30 pm
Pleasantville
Lost: 8/20/2021
ID: 17603
Name: Katara
Type: Dog
Color: Fawn
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
Super sweet comes to her name. Reward if found.