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>='1600992000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - North
Found: 9/5/2020
ID: 14905
Name: Cici
Type: Cat
Color: Black with white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Our black and white cat appears to be missing. She is about 6lbs so she is small. She rarely goes outside, but we noticed we’ve not seen her at all today. We aren’t sure when she disappeared or got out. She rarely goes out and if she does stays on patio. Please contact me if you see her.
Des Moines - East
Found: 9/5/2020
ID: 14902
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale
Found: 9/4/2020
ID: 14892
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
600 block Roseland Drive
Urbandale
Found: 9/4/2020
ID: 14890
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Found: 9/4/2020
ID: 14889
Name:
Type: Cat
Color: Grey and orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 9/3/2020
ID: 14881
Name: Zander
Type: Cat
Color: Grey and White
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
800 block Mevcato Court & 81st
Des Moines - South
Found: 9/3/2020
ID: 14880
Name:
Type: Cat
Color: Tortoiseshell
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Front declawed, found at Easter Lake