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>='1539388800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 10/31/4916
ID: 9263
Name: Capo
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
very friendly and his family misses him please call 5153054916
Des Moines - North
Lost: 10/19/2018
ID: 9821
Name: Apollo, Simon
Type: Dog
Color: One white, one black
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
Just escaped fence at 819 Hoffman Ave. Highland park area, accross from MADISON SCHOOL. Very friendly loving dogs. Call kyle at 515-557-0904 or dixie at (5150 402-2535
Des Moines - South
Lost: 10/18/2018
ID: 9823
Name: Sammie (SammieSam)
Type: Cat
Color: Orange and White
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
6pm He has just been neutered,his stitches are probably still there! He just had his nails trimmed as well. He likes people.
Des Moines - South
Lost: 10/18/2018
ID: 9822
Name: Sammie (SammieSam)
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He has just been neutered,his stitches are probably still there! He just had his nails trimmed as well. He likes people.
Pleasant Hill
Lost: 10/18/2018
ID: 9815
Name: Taz
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Approximately went missing around 4 pm. Broke through the electric fence, very friendly and will even jump in your car.
Mitchellville
Lost: 10/17/2018
ID: 9812
Name: Scarlett
Type: Dog
Color: Black/tan
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Baby
Mitchellville area
Des Moines - Central
Lost: 10/16/2018
ID: 9811
Name: Emilio Rodriquez
Type: Cat
Color: White with dark gray Siamese markings
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
By six Avenue and Franklin in Des Moines
Des Moines - East
Lost: 10/15/2018
ID: 9816
Name: Oliver
Type: Cat
Color: orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Live over by the fairgrounds . He is a very mellow cat and very loving .
Des Moines - Central
Lost: 10/15/2018
ID: 9802
Name: Missy B
Type: Cat
Color: Black with white paws and underside
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
last seen in the drake neighborhood, Missy B is older and may be confused. She has been a housecat for 14 years and is not used to being outdoors.
Ankeny
Lost: 10/15/2018
ID: 9799
Name: Zoey
Type: Dog
Color: Gray
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in our yard, shortly after noon