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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1573257600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 11/14/2019
ID: 12826
Name: Bo
Type: Dog
Color: brown and white
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Adult
Browns Woods area, West Des Moines
Marion
Found: 11/14/2019
ID: 12825
Name: Unknown
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
West Des Moines
Found: 11/14/2019
ID: 12823
Name:
Type: Cat
Color: Black and Brown Tortie
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found in parking lot in 4700 block of Westown Pkwy
Des Moines - Central
Found: 11/14/2019
Animal ID: 180775
Des Moines - Central
Found: 11/13/2019
Animal ID: 180750
Des Moines - Central
Found: 11/13/2019
Animal ID: 180757
Des Moines - Central
Found: 11/13/2019
Animal ID: 180788
Des Moines - North
Lost: 11/13/2019
ID: 12821
Name: Tazz
Type: Cat
Color: Grey with black stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
East 12th street Des Moines
Des Moines - North
Found: 11/13/2019
Animal ID: 180755
under vet care
Des Moines - Central
Found: 11/13/2019
Animal ID: 180777
Johnston
Found: 11/13/2019
Animal ID: 180762
Bondurant
Found: 11/13/2019
Animal ID: 180760
Dubuque
Found: 11/13/2019
ID: 12817
Name: Unknown
Type: Cat
Color: White with dark gray on back
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
. Friendly cat . Meows when near people . Mostly white with dark gray on back
Des Moines - Central
Found: 11/13/2019
Animal ID: 180740
Des Moines - Central
Found: 11/13/2019
Animal ID: 180739
Des Moines - Central
Found: 11/13/2019
Animal ID: 180715
Des Moines - Central
Found: 11/13/2019
Animal ID: 180713
Des Moines - North
Found: 11/13/2019
Animal ID: 180737
Dubuque
Lost: 11/12/2019
ID: 12820
Name: Elsa
Type: Dog
Color: Brown and white
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in shullsburg wi she also has a bad ear and need regular medication
Des Moines - Central
Found: 11/12/2019
Animal ID: 180778
Des Moines - West
Found: 11/12/2019
ID: 12814
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Reposting with a photo. I have seen this cat a few times in the evening. I have left some cat food out at night for the cat. It does run when he/she notices me. It appears to be large and maybe green eyes. Not sure if it is a neighborhood cat or not. If you think this might be yours, I am located on Holcomb Ave between Merle Hay and 57th Street. Sorry this photo is not very clear, I will try and get a better one if I can. You can text me if you like.
Des Moines - West
Found: 11/12/2019
ID:
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
I have seen this cat a few times in the evening. I have left some cat food out at night for the cat. It does run when he/she notices me. It appears to be large and maybe green eyes. Not sure if it is a neighborhood cat or not. If you think this might be yours, I am located on Holcomb Ave between Merle Hay and 57th Street. Sorry this photo is not very clear, I will try and get a better one if I can.
Des Moines - West
Found: 11/12/2019
ID: 12812
Name:
Type: Dog
Color: Black
Breed: Labradoodle
Gender: Male
Fixed: Unknown
Age: Adult
Found in Des Moines on 34th St and Service Drive in the Greenwood neighborhood.
Indianola
Lost: 11/11/2019
ID: 12813
Name:
Type: Dog
Color: Black with a little white on his chest.
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
South of Indianola.
Carlisle
Lost: 11/11/2019
ID: 12811
Name: Bandit(L) Elvira(R)
Type: Dog
Color: Black, white, gray
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
Last known location was Carlisle. They will most likely be together.