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
Des Moines - East
Found: 8/8/2020
ID: 14654
Name:
Type: Dog
Color: Light brown
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
E 41st street holding in back yard until ARL comes
Des Moines - East
Found: 8/8/2020
ID: 14653
Name:
Type: Dog
Color: Light brown
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Holding in backyard until ARL comestyy6
Central City
Found: 8/7/2020
ID: 14643
Name: Unknown
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 8/7/2020
ID: 14633
Name:
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Grimes
Found: 8/6/2020
ID: 14634
Name:
Type: Cat
Color: Black & white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 8/6/2020
ID: 14628
Name:
Type: Dog
Color: Black and brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Missing 3 toes on his back left foot and 1 toe on his back right foot. He is with me for the night
Urbandale
Found: 8/5/2020
ID: 14624
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Altoona
Found: 8/5/2020
ID: 14619
Name:
Type: Dog
Color:
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Young
Found in Altoona. Please message with description if this may be your dog
Bondurant
Found: 8/5/2020
ID: 7922
Name: unknown
Type: Cat
Color: Black with white markings
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 8/4/2020
ID: 14651
Name: Ruby
Type: Cat
Color: Black
Breed: Bombay
Gender: Female
Fixed: Neutered
Age: Adult
Ruby is primarily an inside cat, but has been both inside/outside. Ruby will respond if you call out her name. She is fast and likes to run and hunt, when she gets the chance. She is very sweet. I rescued both her and her sister Pearl(pictured above) a little over five years ago. We miss her terribly, and hope someone sees this and brings her home.
Des Moines - Central
Found: 8/4/2020
ID: 14650
Name: Ruby
Type: Cat
Color: Black
Breed: Bombay
Gender: Unknown
Fixed: Unknown
Age: Baby
Ruby has been both an inside /outside cat, but primarily inside. She is pictured above with her sister, who I rescued a little over five years ago. Ruby is spayed, vaccinations are updated, and she is microchipped.(however, I cannot get ahold of the company to update my phone number). She will respond to her name if you call out to her. She is the sweetest cat, and we miss her terribly, as does her sister, Pearl.
West Des Moines
Found: 8/4/2020
ID: 14616
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Johnston
Found: 8/3/2020
ID: 14617
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
This cat has been around off and on since last winter. Declawed in front.
West Des Moines
Found: 8/3/2020
ID: 14603
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 8/2/2020
ID: 14599
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Adult
800 block & 15th street. Has a bob tail.
Des Moines - South
Found: 8/1/2020
ID: 14601
Name: Unknown
Type: Dog
Color: Black, brown, white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Near East Des Moines Softball Field. We are caring for him until we find his owner.
Cumming
Found: 8/1/2020
ID: 14597
Name: Unknown
Type: Dog
Color: White and tan
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Found: 7/31/2020
ID: 14593
Name:
Type: Dog
Color: White
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Senior
West Des Moines
Found: 7/31/2020
ID: 14590
Name:
Type: Dog
Color: White and yellow
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 7/30/2020
ID: 14589
Name:
Type: Cat
Color: Gray
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Found by county line road in greenfield plaza. Not declawed.
Urbandale
Found: 7/30/2020
ID: 14581
Name:
Type: Dog
Color: Brown black and white
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
Milo
Found: 7/29/2020
ID: 14580
Name:
Type: Cat
Color: Tortise
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Has been in the area a couple weeks. Not sure if she is lost or was dumped. I will adopt if nobody claims her.
Des Moines - Central
Found: 7/29/2020
ID: 14579
Name:
Type: Bird
Color: White
Breed: Pigeon
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Found: 7/29/2020
ID: 14573
Name:
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Found him walking through the yard at 1529 56th st Des Moines. He is lost.
Urbandale
Found: 7/29/2020
ID: 14571
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult