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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
Lidderdale
Lost: 10/16/2020
ID: 15228
Name: Ranger
Type: Dog
Color:
Breed: German Shepherd/Purebred
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Running with our other dog Buddy who I will post soon
Norwalk
Lost: 10/15/2020
ID: 15447
Name: Lily
Type: Cat
Color: Multi
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Senior
Des Moines - East
Lost: 10/15/2020
ID: 15419
Name: Stormy
Type: Cat
Color: Black & white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last last seen in Norwoodville 4335 Northeast 32nd Street
Des Moines - East
Lost: 10/15/2020
ID: 15388
Name: Stormy
Type: Cat
Color: Black & white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in norwoodville on N.E 32nd st
Des Moines - Central
Lost: 10/15/2020
ID: 15353
Name: Stormy
Type: Cat
Color:
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in Norwoodville on N.E 32nd st if found or seen please call or text 5159887893
Des Moines - North
Lost: 10/15/2020
ID: 15308
Name: Stormy
Type: Cat
Color: Black & White
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in norwoodville on N.E 32nd st
Des Moines - North
Lost: 10/15/2020
ID: 15303
Name: Stormy
Type: Cat
Color: Black & white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in norwoodville on N.E 32nd st.
Des Moines - East
Lost: 10/15/2020
ID: 15278
Name: Stormy
Type: Cat
Color: Black & white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on N.E 32nd st. If found or spotted please call 515 988 7893
Des Moines - North
Lost: 10/15/2020
ID: 15264
Name: Nova
Type: Dog
Color: Black with light tan markings
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in the morning with another dog they broke out and haven’t returned home
Urbandale
Lost: 10/15/2020
ID: 15255
Name: Teddy
Type: Cat
Color: Off white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 124th and Douglas Ave in Urbandale. He is super sweet and friendly. Has all of his claws and a fluffy tail!
Urbandale
Lost: 10/15/2020
ID: 15242
Name: Teddy
Type: Cat
Color: Off white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Johnston
Lost: 10/15/2020
ID: 15225
Name: Asteria
Type: Cat
Color: Black and brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
The house was on fire and we do not know where she went.
Des Moines - East
Lost: 10/15/2020
ID: 15224
Name: Georgie
Type: Cat
Color: Black with white nose, belly and paws
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Responds to both George and Georgie. Doesn't like loud noises or kids much. We miss his dearly.
Altoona
Lost: 10/14/2020
ID: 15233
Name: Binx
Type: Cat
Color: Gray striped
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
He snuck out Wed. evening and I didn't realize until the next morning. I really really miss him.
Des Moines - East
Lost: 10/14/2020
ID: 15214
Name: Kane
Type: Dog
Color: Tan
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Fairmount park area
Des Moines - East
Lost: 10/14/2020
ID: 15213
Name: Rocco
Type: Dog
Color: Brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen in fairmount park area
Windsor Heights
Lost: 10/14/2020
ID: 15208
Name: Tyson
Type: Dog
Color: Brown white and black
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
63rd st in Windsor heights loves people but scared of other animals
Des Moines - West
Lost: 10/14/2020
ID: 15207
Name: Tyson
Type: Dog
Color: White head white chest dark body
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly with people would probably come up if called. Lost around 63rd and university area.
Ankeny
Lost: 10/13/2020
ID: 15322
Name: Moon
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Moon is a small, two years old male cat. He's not neutered and has always been very friendly. He had ear problems as a kitten and has short, crinkled ears. He pushed out of a loose window pane and is NOT an outdoor cat so he may be scared and skittish.
Cedar Falls
Lost: 10/13/2020
ID: 15299
Name: Mia
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly, has a black spot to the left of her nose. EAR TIPPED (her left). Black back white belly.
Des Moines - East
Lost: 10/13/2020
ID: 15296
Name: Zeus
Type: Dog
Color: Black
Breed: Chow Chow
Gender: Male
Fixed: Unknown
Age: Young
Outside our house
Des Moines - South
Lost: 10/13/2020
ID: 15273
Name: Nibbets
Type: Cat
Color: Orange and white
Breed: Chow Chow
Gender: Male
Fixed: Neutered
Age: Adult
Norwalk
Lost: 10/13/2020
ID: 15257
Name: Skylar
Type: Dog
Color: Brown/Black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
She is extremely shy. We rescued her from an animal shelter, and she does not warm up to people easily. She is not aggressive and will not bite; just very skittish.
Dubuque
Lost: 10/13/2020
ID: 15220
Name: Bella
Type: Cat
Color: White black and orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Dubuque
Lost: 10/13/2020
ID: 15218
Name: Bella
Type: Cat
Color: Orange black and white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She has some hair loss issues