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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 2/13/2019
Animal ID: 168791
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
Des Moines - North
Found: 2/11/2019
Animal ID: 158562
Des Moines - Central
Found: 2/11/2019
Animal ID: 168752
Urbandale
Found: 2/11/2019
ID: 10596
Name: Rex
Type: Dog
Color: Red
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Adult
63rd and Aurora
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
Urbandale
Found: 2/9/2019
ID: 10583
Name:
Type: Cat
Color: Tabby/Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
found behind dumpster corral at Timberland Springs Apartments 3816 106th Street
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 - North
Found: 1/26/2019
ID: 10516
Name: Bernie Sanders
Type: Cat
Color: Orange
Breed: Schnauzer Standard
Gender: Male
Fixed: Neutered
Age: Adult
He’s a very loveable, indoor/outdoor cat. He snuck out and usually stays on our block. Concerned about freezing temps
Des Moines - North
Found: 1/26/2019
ID: 10515
Name: Bernie Sanders
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
He’s a very loveable, indoor/outdoor cat. He snuck out and usually stays on our block. Concerned about freezing temps
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