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>='1600041600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 8/27/2018
ID: 9468
Name: Chevy
Type: Dog
Color: Red/Tan
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
Chevy went missing about 9pm - She lives in the 4mile/pleasant Hill area. Please help us bring our baby home!!
Des Moines - East
Lost: 8/27/2018
ID: 9467
Name: DJ
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Last seen on east side between east 30th and east 32nd. Please call 515-321-0931 address is 3112 state avenue
Urbandale
Lost: 8/26/2018
ID: 9476
Name: Marshall
Type: Cat
Color: White and grey
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I found him but can't delete this post!
Des Moines - Central
Lost: 8/26/2018
ID: 9462
Name: Oliver
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Corner of 35th and Woodland Ave by Price Chopper.
Des Moines - Central
Lost: 8/26/2018
ID: 9461
Name: Maxie
Type: Dog
Color: Tan and White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Starch Pet Hospital. Escaped our kennels by digging her way out on Sunday 8.26.18 at about 8am near Drake University. She is about 15lbs, tan and white. Please call our clinic 515-283-1576 if you have any information.
Urbandale
Found: 8/26/2018
ID: 9456
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Urbandale
Found: 8/26/2018
ID: 9455
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Johnston
Lost: 8/26/2018
ID: 9454
Name:
Type: Bird
Color:
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Bondurant
Lost: 8/25/2018
ID: 9477
Name: Meaux
Type: Cat
Color: Orange and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed, sweet (but shy), used to going outside at night.
Des Moines - South
Lost: 8/25/2018
ID: 9466
Name: Tessie
Type: Cat
Color: Black and tan
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Sw9th in between McKinley and Frazier Ave. She has blue eyes. I miss her so much! Please help me bring her home! There is a $200 reward for her safe return.
Des Moines - North
Lost: 8/25/2018
ID: 9465
Name: Max
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 2309 Saylor Road My son and his girlfriend let the dog out and never said anything to me.. Max may not even be wearing his red collar.
Des Moines - South
Found: 8/25/2018
ID: 9449
Name:
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 8/23/2018
ID: 9459
Name: Lion Kitty
Type: Cat
Color: Yellow
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen on sw 24th and Thornton ave
Ankeny
Found: 8/23/2018
ID: 9445
Name: Simba
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
We lost our 8 yr old large orange tabby, Simba, last night. - Corner of SE 9th and SE Wanda ( near Southeast Elementary in Ankeny). We think he got out around 10 pm and lost in the storm. He does have a collar and name tag but is usually only indoors and pretty scared of strangers so he may not let you get close enough to see it. Please call if you think you have seen him. Thank you!! Jeff and Lisa Warren 515-963-7991
Des Moines - South
Found: 8/23/2018
ID: 9444
Name:
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Found roaming in back yard off SE 5th and E Marion. Animal control contacted and picked up. Please contact ARL if this is your baby. Friendly to humans. Not so much to my doggy.
Des Moines - South
Found: 8/22/2018
ID: 12181
Name: Unknown
Type: Dog
Color: Brown
Breed: Unknown
Gender: Unknown
Fixed: Not Neutered
Age: Adult
In the middle of the Intersection by exit 9 on 235. Looks like she might have had puppies recently. VERY sweet and kind. You can tell she has a home - help me find it!
Norwalk
Lost: 8/22/2018
ID: 9451
Name: Meisha
Type: Cat
Color: Grey
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on Maplecrest Dr in Lakewood. She has a dark grey spot on each side of her hind legs
Des Moines - Central
Lost: 8/22/2018
ID: 9448
Name: Logan
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
School Street b/t 31st and 35th
Muscatine
Found: 8/22/2018
ID: 9439
Name: Zero
Type: Dog
Color: Brown and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
In our yard near Musser park
Ankeny
Lost: 8/21/2018
ID: 9440
Name: Max
Type: Dog
Color: Mostly Black, Some Brown
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Adult
Shy, will curl up and try to put his foot in front of his face when scared,
Marshalltown
Lost: 8/20/2018
ID: 11176
Name: Jengo
Type: Dog
Color: Tan and whitr
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on w grant st between 2nd and 3rd st. Marshalltown iowa May have been taken and driven out of town
Ottumwa
Lost: 8/20/2018
ID: 10796
Name: Malorie
Type: Dog
Color: White with black patches
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Shelter rescue she is still a little skiddish and don’t like to be locked up. Contact Brittany 641-799-0136
Johnston
Lost: 8/19/2018
ID: 9490
Name: Nellie
Type: Cat
Color: Calico, white face olive shaped eyes
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Johnston
Lost: 8/19/2018
ID: 9475
Name: Nellie
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Young
Bondurant
Found: 8/19/2018
ID: 9429
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young