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>='1594166400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 5/8/2016
ID: 2865
Name: Cuddles
Type: Dog
Color: White, black, and gray
Breed:
Gender: Female
Fixed: Not Neutered
Age: Baby
She is a very friendly and we miss her dearly. Contact me at 515 943 3832 if you have any info. Thanks
Ames
Lost: 5/7/2016
ID: 2916
Name: Lily
Type: Cat
Color: Brown/black tiger
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She does have claws on all four paws still. She is microchipped. Reward offered for safe return! I want my baby back!
Des Moines - East
Lost: 5/7/2016
ID: 2912
Name: maxi
Type: Dog
Color: brindle
Breed: Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - South
Lost: 5/7/2016
ID: 2872
Name: Diamond
Type: Dog
Color: Black/white
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/7/2016
ID: 2866
Name: Diamond
Type: Dog
Color: Black/white
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Near Fulton Dr area
Des Moines - East
Lost: 5/7/2016
ID: 2860
Name: Khaos
Type: Dog
Color: reverse bridle
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Around Guthrie Ave
Ankeny
Lost: 5/6/2016
ID: 2874
Name: Noir
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Escaped from Magazine and Delaware Townhouse complexes. Petite black and white cat not declawed. Likes music and plastic sacks.
Des Moines - West
Lost: 5/6/2016
ID: 2855
Name: Boji
Type: Dog
Color: Black
Breed: Lakeland Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Collar broke loose very friendldy 80lllbs black lab white mullet
Sioux City
Lost: 5/5/2016
ID: 12403
Name: Galaxy
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Adult
Outside on the sidewalk of Morningside
Des Moines - South
Lost: 5/5/2016
ID: 2913
Name:
Type: Cat
Color: calico
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Adult
500 block of wahl and jordan dr
Des Moines - North
Lost: 5/5/2016
ID: 2849
Name: Dakota
Type: Dog
Color: Black W/white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
About 10 am Thursday morning on 10th and Seneca very friendly she has white on her neck, and on her head to her nose.
Des Moines - North
Lost: 5/5/2016
ID: 2848
Name: Dakota
Type: Dog
Color: Black W/white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
About 10 am Thursday morning on 10th and Seneca very friendly she has white on her neck, and on her head to her nose.
Des Moines - Central
Lost: 5/4/2016
ID: 2895
Name: Diego
Type: Dog
Color: Black and tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
My husband's cousin was holding on to our dog cause we were in the middle of moving... He had his buddy watch him for a little bit and the guy took of with him. Heard he was camping in hickery hills, so we went out there and asked around. No one had seen him
Des Moines - South
Lost: 5/4/2016
ID: 2880
Name: Margot
Type: Dog
Color:
Breed: Wheaten Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
Nichols
Lost: 5/4/2016
ID: 2877
Name: Fay, “Bug”
Type: Dog
Color: liver and roan
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Not Neutered
Age: Young
may be with older male gsp
Nichols
Lost: 5/4/2016
ID: 2876
Name: Coot
Type: Dog
Color: liver and roan
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Senior
may have a young female gsp with him, both friendly
West Des Moines
Lost: 5/3/2016
ID: 2843
Name: Tyke
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Bridgewood subdivision near Jordan creek, around 5pm may 3rd, hes friendly but skittish
Waukee
Lost: 5/3/2016
ID: 2842
Name: Camus
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Waukee, near NE Olivewood.
Maquoketa
Lost: 5/3/2016
ID: 2836
Name: Buddie
Type: Dog
Color: Black and tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Seen this morning let them or and they dug a hole and got out of the back yard they usually come back if no one picks them up Nashville between Baldwin and maquoketa they are very friendly
Maquoketa
Lost: 5/3/2016
ID: 2835
Name: Hauns
Type: Dog
Color: Black and grey
Breed: Schnauzer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen this morning let them out and they dug a hole and got out of the back yard they usually come home if they aren't picked up by someone they are pretty friendly won't bit
Des Moines - Central
Lost: 5/1/2016
ID: 3482
Name: Koda
Type: Dog
Color: Tan golden
Breed: Chow Chow
Gender: Unknown
Fixed: Neutered
Age: Adult
Chow mix she was stolen from 1539 Bell ave des moines ia very friendly may be in Ankeny unknown please help find her we miss her dearly
Pleasant Hill
Lost: 5/1/2016
ID: 2902
Name: CC
Type: Cat
Color: Black/White
Breed: Tuxedo
Gender: Female
Fixed: Not Applicable
Age: Adult
Has all claws, would possibly be hard to contain - likes to be outdoors. We think she just got lost because we had just moved and it was her second night in the home.
Des Moines - East
Lost: 5/1/2016
ID: 2827
Name: envy
Type: Dog
Color: brownish gold
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
On 24th and des moines street
Boone
Lost: 4/30/2016
ID: 2905
Name: Memphis
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Boone, Iowa in the areas of Cedar and 22nd street. Left ear clipped slightly shorter than the right.
Boone
Lost: 4/30/2016
ID: 2833
Name: Memphis
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the area of Cedar and 22nd Street in Boone, IA. Her left ear is clipped slightly shorter than the right one.