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
Westfield
Lost: 10/27/2019
ID: 12699
Name: Winston
Type: Dog
Color: Red
Breed: Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
At house took off
Pleasant Hill
Lost: 10/26/2019
ID: 12693
Name: Uzi/ grit
Type: Dog
Color: White/ brindle spots
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
He’s friendly, don’t be afraid
Windsor Heights
Lost: 10/26/2019
ID: 12687
Name: Rex
Type: Dog
Color: Tan and white
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Young
Lost around 9 am, responds to food, barks a lot, likes gnawing fingers
Windsor Heights
Lost: 10/26/2019
ID: 12686
Name: https://share.icloud.com/photos/0rdoN3DptBKyaXVB25Lsh-krA#Otter_Creek_Golf_Course
Type: Dog
Color: Tan and white
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Young
Last seen today at 9 am, barks a lot and comes to food. Like to naw on fingers.
Des Moines - South
Lost: 10/26/2019
ID: 12684
Name: Westley
Type: Cat
Color: Black with white chest
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
South union and Hartford. Black cat with white tuxedo markings
Des Moines - North
Lost: 10/25/2019
ID: 12746
Name: Sky
Type: Cat
Color: Multiple
Breed: Unknown
Gender: Unknown
Fixed: Not Neutered
Age: Adult
E 9th and Sheridan Ave
Dubuque
Lost: 10/25/2019
ID: 12706
Name: Theo
Type: Cat
Color: White with brown spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He has two different colored eyes, acts kind of skiddish, has sensitive ears and eyes that require medication.
Des Moines - Central
Lost: 10/25/2019
ID: 12700
Name: Pudge
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
PUDGE came home this morning & is no longer lost.
St. Marys
Lost: 10/25/2019
ID: 12695
Name: Thea
Type: Cat
Color: Gray tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Came in for supper then snuck out the door. We haven't seen her since. Last seen on 65th ave st marys
College Springs
Lost: 10/25/2019
ID: 12691
Name: Jack
Type: Dog
Color: Roan
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
Between College Springs and Blanchard
Urbandale
Lost: 10/25/2019
ID: 12682
Name: Tiger
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Valerius elementary neighborhood
Thompson
Lost: 10/24/2019
ID: 12698
Name: Nugget
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
He doesn't know the town of Thompson my friend is watching him for me because my new residence does not allow cats if you see him please call me anytime
Pleasant Hill
Lost: 10/24/2019
ID: 12688
Name: Sammie
Type: Dog
Color: Blondish
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
Copper creek neighborhood, Pleasant Hill
Johnston
Lost: 10/23/2019
ID: 12683
Name: Zoe
Type: Cat
Color: Brindel
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Baby
Nw93 and Longview crt Johnston ia
Des Moines - Central
Lost: 10/22/2019
ID: 12661
Name: Luna
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Very cute small and shy she goes by Luna and boonsas she has green eyes
Story City
Lost: 10/21/2019
ID: 12734
Name: Mercy
Type: Dog
Color: black with brown legs
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Senior
Ran after a deer in timber by Skunk River Greenbelt on Pleasant Valley Drive. Could have gone to a truck stop nearby on I-35 CALL KURT @515-203-6411 REWARD for safe return.
Des Moines - South
Lost: 10/21/2019
ID: 12690
Name: Loca
Type: Cat
Color: Gray, white & tan Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
Loca was missing for 2 years, got her back on Monday & she broke out the screen & disappeared again.
Des Moines - Central
Lost: 10/21/2019
ID: 12680
Name: Sassafrass
Type: Dog
Color: Bluetick and beagle
Breed: Bluetick Coonhound
Gender: Female
Fixed: Not Neutered
Age: Baby
Got loose or took over off of 2nd and Arlington or closer to Oakland and franklin. Very friendly she's my home wirld not even 4 months yet
Des Moines - South
Lost: 10/21/2019
ID: 12655
Name: Gracie and Lucifer
Type: Dog
Color: All black with white patch on chest and white tipped toes, Lucifer has a white streak on face
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly and may be with our other dog Gracie
Des Moines - South
Lost: 10/21/2019
ID: 12654
Name: Gracie and Lucifer
Type: Dog
Color: All black with white patch on chest and white tipped toes, Lucifer has a white streak on face
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Friendly may be with our other dog Lucifer both black and very friendly Lucifer has a dopey look very distinctive in the face
Des Moines - North
Lost: 10/20/2019
ID: 12672
Name: Oliver
Type: Cat
Color: Black with a white belly
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen near lower beaver
Des Moines - North
Lost: 10/20/2019
ID: 12671
Name: Oliver
Type: Cat
Color: Black with white belly
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen at house near lower beaver
Urbandale
Lost: 10/20/2019
ID: 12664
Name: Moxie
Type: Cat
Color: White tummy, grey, calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
near 147 th and 158th str north of Meredith drive. young kitten.
Story City
Lost: 10/20/2019
ID: 12649
Name: Mercy
Type: Dog
Color: black with brown legs
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Senior
Mercy is friendly to people but can be dog aggressive. She was last seen chasing a deer near Pleasant Valley Drive,Story City area
Winterset
Lost: 10/20/2019
ID: 12648
Name: Mischa Ann
Type: Dog
Color: Black and Tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
Last seen north of winterset off the cumming hiway and 185th st. We are desperate to have her home, her brother came home without her.