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' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1594166400')) ORDER BY pm1.meta_value DESC, post_date DESC
Dubuque
Lost: 1/2/2020
ID: 13186
Name: Waffle
Type: Cat
Color: Black grey and orange
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 1/2/2020
ID: 13180
Name: June
Type: Dog
Color: Black/Brown
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 1/2/2020
ID: 13178
Name:
Type: Dog
Color: Chocolate Brown & grey
Breed: Cairn Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Two very sweet boys carin maybe Scottish terriers. One thin brown and chubby black and grey on Park near 14th
Altoona
Lost: 1/1/2020
ID: 13210
Name: Aurora
Type: Cat
Color: Tortoiseshell
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen NE 56th st Altoona country living mobile home park.
Des Moines - East
Lost: 1/1/2020
ID: 13168
Name:
Type: Dog
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Applicable
Age: Adult
Red harness fluffy white dog
Des Moines - Central
Lost: 1/1/2020
ID: 13163
Name:
Type: Dog
Color: Black white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Davenport
Lost: 1/1/2020
ID: 13161
Name: Angel
Type: Dog
Color: off white
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Senior
in my back yard....went to potty...blind...
Davenport
Lost: 1/1/2020
ID: 13160
Name: Angel
Type: Dog
Color: off white
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Senior
In my back yard...went to potty..He is very old ...blind...please contact me ...he is my baby
Thurman
Lost: 12/31/2019
ID: 13395
Name: Copper
Type: Dog
Color: White with brown and black
Breed: Basset Hound
Gender: Male
Fixed: Not Neutered
Age: Senior
His name is Copper and last seen in Thurman, Iowa. He is a basset/beagle mix and he's 12. He is super friendly and loves car rides and other animals except SOMETIMES cats. He lost his collar, has arthritis and some hearing loss. We believe someone took him but may have dropped him off once they figured out his age.
Des Moines - South
Lost: 12/31/2019
ID: 13177
Name: June
Type: Dog
Color: Light brown body with dark black nose, forehead, black on ears and some dark through her fur.
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Neutered
Age: Adult
She just had puppies so she still has milk still coming in and her nipples are enlarged and sore.
Carlisle
Lost: 12/31/2019
ID: 13166
Name: Zoey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
Johnston
Lost: 12/31/2019
ID: 13164
Name: Gizzy (Gizmo)
Type: Cat
Color: Black, orange, white
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at Providence pointe apartments Johnston around 5-6pm
West Des Moines
Lost: 12/31/2019
ID: 13157
Name: Sheba
Type: Dog
Color: Red
Breed: Shiba Inu
Gender: Unknown
Fixed: Neutered
Age: Senior
Waukee
Lost: 12/30/2019
ID: 13151
Name: Luke
Type: Cat
Color: Light Gray with White Chest and Toes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is very timid, please do not chase! He will run. Please text or call me if you see him! He was last seen in the mobile home court (Midwest Country Estates) on Collins Drive and Dartmoor.
Des Moines - North
Lost: 12/30/2019
ID: 13150
Name: Winston
Type: Bird
Color: Gray/white
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Young
Near Grandview College in Des Moines
Des Moines - Central
Lost: 12/30/2019
ID: 13149
Name: Unknown
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Adult
Found E 22nd Street bear Guthrie
Ankeny
Lost: 12/29/2019
ID: 13145
Name: Elsie
Type: Cat
Color: White/Brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Ankeny
Lost: 12/28/2019
ID: 13148
Name: Sheo
Type: Cat
Color: White
Breed: Turkish Angora
Gender: Male
Fixed: Unknown
Age: Adult
Delaware Crossing in ankeny
Bonaparte
Lost: 12/28/2019
ID: 13143
Name: Mac
Type: Dog
Color: Black, white, brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
307 West Street Bonaparte IA. In my back yard. Also was wearing a red bandana. Is shy to strangers but loves friendly dogs. He is a year old Australian Shepherd and Heller mix. And is my 4yr old daughter's best friend and mine. He loves table scraps and chasing cats that run and squirrels.
Ankeny
Lost: 12/27/2019
ID: 13146
Name: Mushroom
Type: Cat
Color: Grey with white/orange
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale
Lost: 12/27/2019
ID: 13140
Name: Shadow
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
He ran outside the patio door when someone opened it. He still has his claws. He has a very high pitched meow.
Urbandale
Lost: 12/27/2019
ID: 13139
Name: Count Rugan
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Count has 6 toes on his paws p
Dubuque
Lost: 12/27/2019
ID: 13137
Name: Bella
Type: Dog
Color: tan
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
Rhomberg Ave
Des Moines - North
Lost: 12/27/2019
ID: 13130
Name: Dak
Type: Cat
Color: Brown black stripes
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
Before 7am
Des Moines - North
Lost: 12/27/2019
ID: 13129
Name: Dak
Type: Cat
Color: Brown black stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Before 7am