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
Pleasant Hill
Found: 9/15/2020
ID: 14957
Name:
Type: Dog
Color: White with tan curls
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
I-235 Eastbound Lane. Found with Black dog. Both on covered porch with food and water in Pleasant Hill.
West Des Moines
Found: 9/15/2020
ID: 14951
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Pleasant Hill
Found: 9/15/2020
ID: 14950
Name:
Type: Dog
Color: Grey/tan
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 9/14/2020
ID: 14966
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4600 Block of Pleasant Street
Des Moines - Central
Found: 9/14/2020
ID: 14953
Name: Harry
Type: Dog
Color: Brown and black
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen running away from 1914 King Ave Des Moines. He chases cars.
Johnston
Found: 9/14/2020
ID: 14948
Name: Ivovry
Type: Cat
Color: White and grey
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Adult
Very skirmish, last seen in Johnston
West Des Moines
Found: 9/14/2020
ID: 14947
Name:
Type: Dog
Color: black and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
500 block 1st street
Urbandale
Found: 9/14/2020
ID: 14946
Name:
Type: Cat
Color: Grey and Black
Breed: Himalayan
Gender: Unknown
Fixed: Unknown
Age: Adult
2700 block Beverly Drive
Urbandale
Found: 9/14/2020
ID: 14943
Name:
Type: Dog
Color: Yellow
Breed: Retriever, Labrador
Gender: Male
Fixed: Unknown
Age: Adult
Oskaloosa
Found: 9/13/2020
ID: 14940
Name: Unknown
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
West Des Moines
Found: 9/13/2020
ID: 14939
Name:
Type: Dog
Color: white
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
1200 block of Locus Street
Des Moines - South
Found: 9/13/2020
ID: 14937
Name:
Type: Dog
Color: Black with white on belly and feet
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Dog came in our garage dragging a chain. On Lacona Avenue. Please call 515-991-3547 if this is your pet.
West Des Moines
Found: 9/12/2020
ID: 14931
Name: Nova Rain
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
5900 Block of Vista Drive
West Des Moines
Found: 9/11/2020
ID: 14928
Name: Slate
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Jasper County
Des Moines - North
Found: 9/10/2020
ID: 14933
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale
Found: 9/10/2020
ID: 14930
Name:
Type: Cat
Color: persian long hair
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Friendly, approached me, has all claws. No microchip.
Ames
Found: 9/10/2020
ID: 14921
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Collar says Remington, has burrs on his back, looks like he has been running.
Clive
Found: 9/8/2020
ID: 14914
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 9/7/2020
ID: 14910
Name:
Type: Dog
Color: Grey
Breed: Poodle Miniature
Gender: Male
Fixed: Unknown
Age: Senior
High and 28th street
Urbandale
Found: 9/7/2020
ID: 14909
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Norwalk
Found: 9/7/2020
ID: 14908
Name: Willie
Type: Cat
Color: White with block tiger stripe spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Willie has been found! Thank you!
Norwalk
Found: 9/7/2020
ID: 14907
Name: Willie
Type: Cat
Color: White with block tiger stripe spots
Breed: Munchkin
Gender: Male
Fixed: Neutered
Age: Adult
Willie has been found! Thank you!
Des Moines - South
Found: 9/6/2020
ID: 14934
Name:
Type: Cat
Color: Tuxedo
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Front declawed. Very friendly.
Ankeny
Found: 9/6/2020
ID: 14906
Name: Unknown
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
I see this sweet kitty on Windover Dr at Autumn Ridge in Ankeny. First saw her 3 weeks ago.
West Des Moines
Found: 9/6/2020
ID: 14904
Name:
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
200 block 34th court