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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 8/23/2016
ID: 3722
Name: Prince
Type: Cat
Color: Black&white
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at home on woodland and 27th street by Sherman hill. 50312
West Des Moines
Lost: 8/23/2016
ID: 3703
Name: Penny
Type: Bird
Color: Grey with Mauve tail
Breed: African Grey
Gender: Female
Fixed: Unknown
Age: Young
Penny flew from our house at 511 38th Street in West Des Moines and headed west around 6:00 p.m. Tuesday evening. The wind was blowing north west. She can talk and may come to someone who has a crinkly bag of ships, crackers, cereal, etc.... She says, Peek-a-boo,, I love you, mommy, can you hear me, etc....
La Porte City
Lost: 8/22/2016
ID: 4763
Name: sox
Type: Cat
Color: black and white
Breed: African Grey
Gender: Male
Fixed: Unknown
Age: Adult
lost around E. Tama Rd. La Porte City no claws
Persia
Lost: 8/22/2016
ID: 3711
Name: Marley Maybelle
Type: Cat
Color: tortoiseshell calico back legs orange shaved with lion cut
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
corner of 1st Ave & Framp/Vienna
Altoona
Lost: 8/22/2016
ID: 3705
Name: Josie
Type: Cat
Color: Black and tan striped with an orange patch on back
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Baby
Josie was last seen in the evening on Monday 8/22/16. She did not come inside for the night and was not back the next day. She is about 5 months old has not yet been spayed. She is black and tan striped (short hair) with a patch of orange hair on her back close to her tail. She is very sweet but likes to run when trying to be caught. She purrs ALOT and rarely meows. She still has claws on all four.
Des Moines - East
Lost: 8/22/2016
ID: 3698
Name: Olaf
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen around east 19th and Logan in Des moines Iowa, we are adding a $200.00 reward please help us find our baby
Stuart
Lost: 8/21/2016
ID: 3931
Name: Leo
Type: Cat
Color: Grey and tan with Black stripes on legs - black behind paws
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Young
Kum n' Go in Stuart. Please read pic description for details about him. REWARD!!!
Stuart
Lost: 8/21/2016
ID: 3926
Name: Leo
Type: Cat
Color: Grey with Black stripes on legs - black behind paws
Breed: Pixie-Bob
Gender: Male
Fixed: Neutered
Age: Young
Lost at the Kum and Go in Stuart Iowa - very sweet and friendly - I miss him very much. He has a micro - chip # 911001001386116 - please call 951-249-6799 if found. Thanks Geri
Des Moines - Central
Lost: 8/21/2016
ID: 3693
Name: Runt Runt
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
Fort Dodge
Lost: 8/20/2016
ID: 3873
Name: Koga
Type: Cat
Color: No collar
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is a very friendly. He is big built, big paws also declawed on his from paws. Neutered. His meow is a little funny in my opinion. Very chill cat. He is only 2 so he's a young adult.
Des Moines - South
Lost: 8/20/2016
ID: 3708
Name: theo
Type: Dog
Color: blck and white
Breed: Havanese
Gender: Male
Fixed: Not Neutered
Age: Adult
in the area of sw 13th street very friendly 3601 sw 13th street will give a award
Missouri Valley
Lost: 8/20/2016
ID: 3690
Name: Loki
Type: Dog
Color: Mostly Grey
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Missouri Valley
Lost: 8/20/2016
ID: 3689
Name: Loki
Type: Dog
Color: Mostly Grey
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Windsor Heights
Lost: 8/20/2016
ID: 3681
Name: Rayden James
Type: Cat
Color: grey
Breed: Irish Wolfhound
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in my front yard eating grass...
LeClaire
Lost: 8/19/2016
ID: 3697
Name: Mittens
Type: Cat
Color: White/Chocolate
Breed: Irish Wolfhound
Gender: Male
Fixed: Neutered
Age: Young
Last seen at home on South 8th St in LeClaire IA. Mittens has a patch of bald, irritated skin on his neck from scratching at it.
Des Moines - East
Lost: 8/19/2016
ID: 3685
Name: Ace
Type: Cat
Color: Black and brown. White belly/chin
Breed: Irish Wolfhound
Gender: Male
Fixed: Neutered
Age: Young
Last seen 5pm Friday 5pm before storm. Outside cat but comes inside twice a day to eat. He likes cars and could of hid in garage during storm. Has collar and tag.
Des Moines - East
Lost: 8/19/2016
ID: 3684
Name: Ace
Type: Cat
Color: Black and brown. White belly/chin
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 5pm Friday 5pm before storm. Outside cat but comes inside twice a day to eat. He likes cars and could of hid in garage during storm. Has collar and tag.
Bondurant
Lost: 8/18/2016
ID: 3710
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
0ne of her eyes turns towards her nose
Colfax
Lost: 8/17/2016
ID: 3682
Name: Molly
Type: Dog
Color: Black and grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
Had a bright orange collar and a training collar on at the time she was lost
Des Moines - East
Lost: 8/17/2016
ID: 3669
Name: Sadie
Type: Dog
Color: Black and White
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
People should know she does not like other female dogs.
Le Mars
Lost: 8/15/2016
ID: 3672
Name: Spat
Type: Cat
Color: Black and orange
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Baby
Still has claws
Des Moines - East
Lost: 8/15/2016
ID: 3657
Name: Nelli
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Senior
10:30pm has a surgery scar on her right hip and a small scar between shouldrrs
Des Moines - Central
Lost: 8/12/2016
ID: 3655
Name: Snoop
Type: Dog
Color: Blue with a white stripe coming down between his eyes white chest and white tips on all his paws
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 8/12/2016
ID: 3640
Name: Kujo
Type: Dog
Color: tan with black face
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Near Ovid street E 8th
Des Moines - North
Lost: 8/12/2016
ID: 3639
Name: Kujo
Type: Dog
Color: Tan
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young