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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Colfax
Lost: 8/17/2016
ID: 3682
Name: Molly
Type: Dog
Color: Black and grey
Breed:
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
Des Moines - South
Lost: 8/7/2016
ID: 3611
Name: Socks
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
SE 6th near downtown. He is 8 wks old.
Des Moines - East
Lost: 8/7/2016
ID: 3603
Name: Cinnamon
Type: Dog
Color: Peach
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Young
Let her and our other dog out to potty for a few mins in the morning and came back to let her in and she was gone. Loves to dance, loves kids super friendly.
Ankeny
Lost: 8/6/2016
ID: 3625
Name: carolina
Type: Cat
Color: white, light black, orange
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Adult
On my street se chaparal dr
Pleasant Hill
Lost: 8/6/2016
ID: 3617
Name: Skootz
Type: Cat
Color: Grey with small brown patches
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Quiet kitty, but you'll know she's there. Likes feet.
Belmond
Lost: 8/6/2016
ID: 3599
Name: Bella
Type: Dog
Color: Blonde/tan/caramel
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
3rd Ave on the hill. Very timid. Not from the area.
Belmond
Lost: 8/6/2016
ID: 3598
Name: Bella
Type: Dog
Color: Blonde/tan/caramel
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
3rd Ave on the hill. Very timid. Not from the area.
Des Moines - South
Lost: 8/5/2016
ID: 3591
Name: Sherman
Type: Dog
Color: Salt and pepper
Breed: Schnauzer Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
Sherman is very friendly, needs a hair cut, and slipped his collar tonight :( please call or text 515-201-7139 if found!
Cedar Rapids
Lost: 8/5/2016
ID: 3589
Name: JoJo
Type: Cat
Color: Gray
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
She was last seen running away from our apartment complex this morning our neighbor saw her. We assume she got outside last night during the rain storm
Des Moines - North
Lost: 8/5/2016
ID: 3582
Name: Biscuit
Type: Dog
Color: Reddish-brown
Breed: Mix
Gender: Unknown
Fixed: Neutered
Age: Adult
4105 Oxford Street, Des Moines. Very friendly.
Boone
Lost: 8/4/2016
ID: 3580
Name: Luna
Type: Dog
Color: Black/White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Baby
1217 Union Street