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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 4/20/2021Animal ID: 199795
Ankeny
Found: 4/20/2021Animal ID: 199792
Black and white male cat found off of NE 22nd St
Des Moines - South
Found: 4/20/2021ID: 16518Name: Type: DogColor: Black and white Breed: UnknownGender: MaleFixed: UnknownAge: Adult
Found at sw 12th and Amos
Waterloo
Found: 4/20/2021Animal ID: 10161
Found on 200blk Palmer Drive. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM (closed over 12-1PM lunch hour).
Des Moines - Central
Found: 4/19/2021Animal ID: 199798
Des Moines - Central
Found: 4/19/2021Animal ID: 199796
Des Moines - Central
Found: 4/19/2021Animal ID: 199762
Des Moines - Central
Found: 4/19/2021Animal ID: 199750
Carlisle
Found: 4/19/2021Animal ID: 199746
Waterloo
Found: 4/19/2021Animal ID: 10158
Found on W 4th St. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM (closed over 12-1PM lunch hour).
Des Moines - Central
Found: 4/19/2021Animal ID: 199713
Des Moines - Central
Found: 4/19/2021Animal ID: 199710
Waukee
Found: 4/18/2021ID: 16503Name: Type: CatColor: BlackBreed: UnknownGender: UnknownFixed: UnknownAge: Young
I don't know how old the cat is. Seems young but could be an adult. Very friendly.
Cedar Falls
Found: 4/18/2021Animal ID: 10151
Found on 4300 blk Wynnewood Dr. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM (closed over 12-1PM lunch hour).
Des Moines - West
Found: 4/18/2021Animal ID: 199678
Cedar Falls
Found: 4/18/2021Animal ID: 10150
Found on 12th Street. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM (closed over 12-1PM lunch hour).
Des Moines - North
Found: 4/18/2021Animal ID: 199673
Waterloo
Found: 4/18/2021Animal ID: 9013
Found on 800 blk Rhiel St. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM (closed over 12-1PM lunch hour).
Des Moines - Central
Found: 4/17/2021Animal ID: 199709
Des Moines - Central
Found: 4/17/2021Animal ID: 153499
Des Moines - Central
Found: 4/17/2021Animal ID: 199711
Des Moines - Central
Found: 4/17/2021Animal ID: 199671
Approx 1 y/o male
Des Moines - Central
Found: 4/17/2021Animal ID: 199684
Approx 10 month Male
Des Moines - Central
Found: 4/17/2021Animal ID: 199681
Approx 4 y/o Female
Des Moines - Central
Found: 4/17/2021Animal ID: 199679
1 y/o Male
