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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - Central
Lost: 8/11/2016
ID: 3641
Name: Manchitas
Type: Rabbit
Color: It's white with brown and black dots
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
The last time I saw it was at my yard I went inside to go get a drink and went back outside and he wasn't there , So I started to look for him and never found him the time was 3:00 pm . The color is white his ears are down , he has brown and black dots his nose is half brown ! He is a young rabbit if anyone sees him please contact 770-861-5653 please , he is like my best friend I really miss him :( I brought him from Atlanta Georgia so please again if y'all seen it or knows who has it please contact 770-861-5653 keep the rabbit till we go for it or y'all come to give it to us please if you have it please give it back he's my best friend I had him for 1 year and I really miss him a lot , so does my family The address to my house : 4017 Cornell st Des Moines IA 50313
Des Moines - East
Lost: 8/11/2016
ID: 3635
Name: Benji
Type: Dog
Color: Brown
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Adult
Last see yesterday,round 2:00p.m eastside des moines
Des Moines - East
Lost: 8/11/2016
ID: 3632
Name:
Type: Dog
Color:
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Young
found at an east side intersection around buchanan please contact me i have called the animal rescue league and know you are concerned and they instructed you to look here
Adel
Lost: 8/10/2016
ID: 3631
Name: Dax
Type: Dog
Color: White
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Ashworth and T Ave. area, Adel IA
West Des Moines
Lost: 8/9/2016
ID:
Name: Pippin
Type: Cat
Color: Grey, brown, white
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 8/9/2016
ID: 3619
Name: Pippin
Type: Cat
Color: Grey, brown, white
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Baby
Marion
Lost: 8/8/2016
ID: 3628
Name: Josie
Type: Dog
Color: Tan and black
Breed: Mastiff English
Gender: Female
Fixed: Neutered
Age: Young
Last seen between 29th Ave and 44th St in Marion
Marion
Lost: 8/8/2016
ID: 3627
Name: Josie
Type: Dog
Color: Tan and black
Breed: Mastiff English
Gender: Female
Fixed: Neutered
Age: Young
Last seen between 29th Ave and 44th St in Marion