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>='1613865600')) ORDER BY pm1.meta_value DESC, post_date DESC
Bevington
Lost: 9/26/2020
ID: 15060
Name: Charlie Brown
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15059
Name: Lemon Drop
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15058
Name: Hunter
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Des Moines - Central
Lost: 9/26/2020
ID: 15055
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He has unique tail see picture $500 reward
Des Moines - Central
Lost: 9/26/2020
ID: 15054
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
$500 reward
Des Moines - Central
Lost: 9/26/2020
ID: 15053
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 9/26/2020
ID: 15052
Name: Balian
Type: Cat
Color: Brown Marbel
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the home in the evening of 9/25/20. He has no claws and is very friendly and loves to me petted. He has green eyes. He was last seen in between 56th-63rd street in a blue townhouse complex, Frisbee Park 50312.
Ankeny
Lost: 9/25/2020
ID: 15070
Name: Mally Owen
Type: Cat
Color: Brown with white chest, underbelly, and feet
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
She is microchipped
Altoona
Lost: 9/25/2020
ID: 15056
Name: grey
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
missing the tip of her tail has a collar on with name and my phone number.
Des Moines - South
Lost: 9/24/2020
ID: 15578
Name: Kalena
Type: Dog
Color: White and Brown
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
She was last seen at 6808 Chaffee Road at the The Fort Living Apts. She was taken from my apt while I was at work. She is a Staffshire Terrior, 14 wks when went missing. It's been 2 months and I will not give up lookn for my baby girl. She is very friendly and is very much loved and missed. Anyone knowing of her whereabouts plz contact me at 515 689 5731 Reward to anyone who brings her home
Urbandale
Lost: 9/24/2020
ID: 15100
Name: Gabe
Type: Cat
Color: Orange and White Long hair
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
Long hair Very shy and sly. Likes to hide. Has a chip, Very small and light but may look larger because of long hair
Cumming
Lost: 9/24/2020
ID: 15041
Name: Maizy
Type: Dog
Color: Flashy brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Headed west on 140th toward Cumming highway
Cumming
Lost: 9/24/2020
ID: 15040
Name: Maizy
Type: Dog
Color: Flashy brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Headed west on 140th st in Madison county
Des Moines - South
Lost: 9/24/2020
ID: 15039
Name: E
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Se 5th and E Phillip
Des Moines - South
Lost: 9/24/2020
ID: 15038
Name: E
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
On e Phillip and 5th on the south side of des moines
Ankeny
Lost: 9/24/2020
ID: 15034
Name: Rainey
Type: Dog
Color: Black tri
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
In NW Ankeny. Got out around NW North Creek Dr.
Des Moines - East
Lost: 9/24/2020
ID: 15032
Name: Blanca and Guala
Type: Dog
Color: Guala-tan Blanca-brown and white
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
East Des Moines. Offering $200 a reward for the return of both of my puppies.
Des Moines - East
Lost: 9/24/2020
ID: 15031
Name: Blanca and Guala
Type: Dog
Color: Brown and white. And the other is tan
Breed: American Bulldog
Gender: Unknown
Fixed: Unknown
Age: Baby
East Des Moines.
Des Moines - East
Lost: 9/21/2020
ID: 15027
Name: Jr
Type: Cat
Color: White/grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
Live on Cleveland Idaho st, not an outdoor cat. Super nice but he is scared of new people. About 3 years old
Des Moines - East
Lost: 9/21/2020
ID: 15026
Name: Jr
Type: Cat
Color: White/grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
Live on Cleveland Idaho st, not an outdoor cat. Super nice but he is scared of new people. About 3 years old
Des Moines - East
Lost: 9/21/2020
ID: 15024
Name: Jr
Type: Cat
Color: White/grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Cleveland and idaho at our home. He is in indoor cat who has never been outside so I'm guess he is scared.
Des Moines - East
Lost: 9/21/2020
ID: 15014
Name: Jazzy
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Last seen along our street ENDEN LN (EASTSIDE)
Des Moines - East
Lost: 9/21/2020
ID: 15013
Name: Jazzy
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen along our street ENDEN LN (EASTSIDE)
Creston
Lost: 9/21/2020
ID: 15008
Name: Angel
Type: Dog
Color: multi
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
She is skittish. Is a friends dog that I gave to him and his late wife. Think she and other dog were stolen from yard.
Des Moines - East
Lost: 9/21/2020
ID: 15007
Name: Gigi
Type: Dog
Color: White and brown
Breed: American Bulldog
Gender: Unknown
Fixed: Not Neutered
Age: Young
E 9th and university