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>='1600387200')) ORDER BY pm1.meta_value DESC, post_date DESC
Solon
Found: 4/3/2020
ID: 13749
Name:
Type: Dog
Color: White/Black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - South
Found: 4/3/2020
ID: 13697
Name:
Type: Dog
Color: Black white chest
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
2 puppies found near sw 9th and porter ave
Corning
Found: 4/2/2020
ID: 13692
Name: Lincoln
Type: Dog
Color: Multi
Breed: Saint Bernard
Gender: Male
Fixed: Neutered
Age: Young
We let the dogs out before dinner and they haven’t returned.
Corning
Found: 4/2/2020
ID: 13691
Name: Carter
Type: Dog
Color: Blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
We let the dogs out before dinner and they have not returned.
Clive
Found: 3/31/2020
ID: 13678
Name:
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Ladora
Found: 3/31/2020
ID: 13676
Name: Ava
Type: Dog
Color: Black white gray
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Adult
Reb collar with a bell Last seen a mile from Lake Iowa
Urbandale
Found: 3/30/2020
ID: 13667
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
16800 Block of Madison Circle
West Des Moines
Found: 3/30/2020
ID: 13663
Name:
Type: Dog
Color: Tan
Breed: Cocker Spaniel
Gender: Unknown
Fixed: Unknown
Age: Adult
4700 Block of Westwood Drive
Clive
Found: 3/30/2020
ID: 13660
Name:
Type: Dog
Color: Black
Breed: Retriever, Labrador
Gender: Female
Fixed: Unknown
Age: Adult
9400 Block of Lincoln
Altoona
Found: 3/30/2020
ID: 13659
Name:
Type: Dog
Color: White w/ brown
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
By HyVee on 1st Ave SW
Clive
Found: 3/29/2020
ID: 13682
Name:
Type: Dog
Color: Brown and White
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Clive
Clive
Found: 3/29/2020
ID: 13681
Name:
Type: Dog
Color: Brown and White
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Clive
West Des Moines
Found: 3/29/2020
ID: 13658
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - North
Found: 3/29/2020
ID: 13656
Name: Unknown
Type: Dog
Color: Grayish
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
He’s staying with me till we find his family. He is neutered. Super friendly.
Des Moines - Central
Found: 3/29/2020
ID: 13653
Name:
Type: Dog
Color: Black and white
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Found near Moulton Elementary
Marion
Found: 3/26/2020
ID: 13633
Name:
Type: Cat
Color: Gray tabby
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
At MercyCare Marion clinic. Extremely friendly and comfortable with people and riding in the car. Looks like she has recently weaned kittens.
Clive
Found: 3/25/2020
ID: 13628
Name:
Type: Dog
Color: Tan and White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/22/2020
ID: 13616
Name:
Type: Small or Furry
Color: Black, Brown, and White
Breed: Ferret
Gender: Unknown
Fixed: Neutered
Age: Adult
Kum and Go Parking Lot on Mills Civic Parkway
Clive
Found: 3/22/2020
ID: 13615
Name:
Type: Cat
Color: Brown and gold Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
NW 87th Place in Clive
West Des Moines
Found: 3/21/2020
ID: 13614
Name:
Type: Dog
Color: Brown and White
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
700 Block of 11th Street in WDM
West Des Moines
Found: 3/21/2020
ID: 13611
Name: Bella
Type: Dog
Color: Yellow very hairy
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Very skiddish. Missing from 10th and Grand in WDM.
West Des Moines
Found: 3/21/2020
ID: 13607
Name:
Type: Dog
Color: Black and Grey
Breed: Poodle Miniature
Gender: Unknown
Fixed: Unknown
Age: Adult
50th Street and Ashworth Road
West Des Moines
Found: 3/21/2020
ID: 13605
Name:
Type: Dog
Color: Tan
Breed: Wheaten Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
50th Street & Ashworth Road
Rural Polk County
Found: 3/20/2020
ID: 13619
Name:
Type: Dog
Color: White and brown
Breed: English Setter
Gender: Male
Fixed: Not Neutered
Age: Adult
Urbandale
Found: 3/20/2020
ID: 13612
Name: Sweetie
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen on Aurora Ave by the Gloria Dei church