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>='1605657600')) ORDER BY pm1.meta_value DESC, post_date DESC
Nevada
Found: 2/17/2019
ID: 10647
Name:
Type: Dog
Color: Tri
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Found: 2/16/2019
ID: 10618
Name: Lucy
Type: Dog
Color: white/Tan
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Young
lost in the Saydel area off of NE 2nd Ave
Orient
Found: 2/14/2019
ID: 10631
Name:
Type: Dog
Color: Black brown white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Polk City
Found: 2/14/2019
ID: 10609
Name:
Type: Cat
Color: Tabby or Tiger
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
No microchip, believe female or neutered male, not declawed. About 6 lbs. Very sweet!
Des Moines - South
Found: 2/12/2019
ID: 10597
Name: Unknown
Type: Dog
Color: White/black spots
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Baby
Adel
Found: 2/10/2019
ID: 10594
Name: Ollie
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Near panther creek road
Adel
Found: 2/10/2019
ID: 10593
Name: Finn
Type: Dog
Color: Blue
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen near panther creek road
Deep River
Found: 2/9/2019
ID: 10587
Name:
Type: Dog
Color:
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Young
Found on highway 21 10 mins south of interstate 80 in poweshiek county
Des Moines - Central
Found: 2/9/2019
ID: 10584
Name:
Type: Cat
Color: Mostly gray and white with just a tinge of carame
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Has been seen in the neighborhood for maybe 3 weeks but first time we could grab her
Des Moines - South
Found: 2/9/2019
ID: 10581
Name: Papas
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
We finally found him with the help of my other dog. Thank you for the support I had to find him.
Des Moines - Central
Found: 2/8/2019
ID: 10592
Name:
Type: Cat
Color: Gray and white
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Has been feeding in my neighborhood for maybe 3 weeks. Just able to bring her in
Des Moines - South
Found: 2/6/2019
ID: 10567
Name: Unknown
Type: Dog
Color: brown and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Had the ARL come pick up this little guy on 2/6 as he was shivering very severely and had a small puncture on his paw. Contact the ARL to reach him as I no longer have him.
West Des Moines
Found: 2/5/2019
ID: 10561
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Found in West Glen area
West Des Moines
Found: 2/3/2019
ID: 10544
Name:
Type: Dog
Color: Chocolate
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Found in west Des Moines near Norwalk/cumming line. Now with wdm animal control.
Des Moines - South
Found: 2/2/2019
ID: 10541
Name:
Type: Dog
Color: Brindle
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Se 14th and indionola, was sleeping outside all night homeless man woke up amd he was at his feet
Des Moines - South
Found: 1/31/2019
ID: 10538
Name:
Type: Cat
Color: Orange tabby with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Found at approximately 10pm at apartment complex at South Union and McKinley
Leland
Found: 1/30/2019
ID: 10532
Name: ???
Type: Cat
Color: Grey
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Showed up at backdoor @ 7:30 pm on 1/30/2019
Leland
Found: 1/30/2019
ID: 10531
Name: ???
Type: Cat
Color: Grey
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Found 30 min ago @ 7:30pm. Leland IA. Call (816)914-3093
Ankeny
Found: 1/30/2019
ID: 10528
Name:
Type: Dog
Color: White and brown
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Was on corporate woods drive.
Runnells
Found: 1/28/2019
ID: 10527
Name:
Type: Cat
Color: brown and gray tabby
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found on University Ave near Runnels
Remsen
Found: 1/28/2019
ID: 10521
Name: Smuckers
Type: Dog
Color: Black
Breed: Schnauzer Standard
Gender: Male
Fixed: Unknown
Age: Young
Found Smuckers, he came walking on to the porch around 3:30...just glad to have him back home...thank you!
Des Moines - East
Found: 1/26/2019
ID: 10506
Name:
Type: Dog
Color: Brown/black
Breed: Shepherd
Gender: Unknown
Fixed: Unknown
Age: Young
Keeping until owner found
Altoona
Found: 1/25/2019
ID: 10502
Name: Unknown
Type: Dog
Color: Black and white
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Found: 1/21/2019
ID: 10556
Name:
Type: Cat
Color: Brown/Gray Tiger
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Adult
This cat has been showing up at our house off and on for several weeks to eat food we put out beneath our deck. Usually comes in the evening, but can't get close enough to catch it. Have fixed a small dog house under our deck with blankets, but have never seen it inside. West of Lower Beaver Road area near Samuelson School.
Melcher-Dallas
Found: 1/16/2019
ID: 10475
Name:
Type: Cat
Color:
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult