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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Newton
Lost: 6/13/2015
ID: 778
Name: Mouse
Type: Cat
Color: black and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Young
Lost near Berg school.
Cedar Falls
Lost: 6/13/2015
ID: 747
Name: Belle
Type: Dog
Color: Tricolor
Breed: Basset Hound
Gender: Female
Fixed: Unknown
Age: Baby
Staying at 1900 vera way.. Still has least hooked on collar.
Des Moines - East
Lost: 6/12/2015
ID: 768
Name: dotsie
Type: Dog
Color: Brown and a few white spots
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
Dotsie is home now:)
Des Moines - East
Lost: 6/12/2015
ID: 767
Name: dotsie
Type: Dog
Color: Brown and a few white spots
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
Dotsie got out of the yard early Friday morning please contact me 5152505299 she was last seen around 8pm by a lady on e33rd ct please help me find her
Des Moines - East
Lost: 6/12/2015
ID: 743
Name: dotsie
Type: Dog
Color: brown and white
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
She was last seen in tge back yard around e26th in between university and maple
Des Moines - East
Lost: 6/12/2015
ID: 742
Name: dotsie
Type: Dog
Color: brown and white
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
She was last seen in tge back yard around e26th in between university and maple
Norwalk
Lost: 6/12/2015
ID: 740
Name: Lily
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Female
Fixed: Neutered
Age: Adult
South of Rolling Hills golf course. Lily is very timid and may not willing come to a stranger.
West Des Moines
Lost: 6/11/2015
ID: 804
Name: Miss Kitty (AKA Ally)
Type: Cat
Color: Grey and White
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
On 9th street and Locust, Miss Kitty is missing her top left K-9 tooth.
Des Moines - Central
Lost: 6/11/2015
ID: 734
Name: Baltu
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
New York aVe 103
Osceola
Lost: 6/10/2015
ID: 732
Name: Max
Type: Dog
Color: tan
Breed: Pug
Gender: Male
Fixed: Not Neutered
Age: Adult
Max is a rescue dog and was just moved into his new foster home that day.
Des Moines - Central
Lost: 6/8/2015
ID: 724
Name: George
Type: Cat
Color: Grey striped tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
18th and woodland street. Sherman hill. Sweet as ever
Des Moines - North
Lost: 6/8/2015
ID: 722
Name: Nikita
Type: Dog
Color: whit grey and black husky
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Last seen on Amherst by Aurora between 2nd and 14th in des moines. she is a runner but the sweetest dog.
Ankeny
Lost: 6/8/2015
ID: 720
Name: Blaze
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
His microchip has slid out of place. so, look around. He is a black lab mix. He is very friendly and will follow anyone.
Des Moines - Central
Lost: 6/8/2015
ID:
Name: fella
Type: Dog
Color: brown and white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
2nd ave Indiana ave
Des Moines - Central
Lost: 6/7/2015
ID: 718
Name: Sam
Type: Cat
Color: Gold with a bit of white mixed in. Also called buff or peach colored
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
No front claws-never been outside-friendly IS MICROCHIPPED
Des Moines - Central
Lost: 6/7/2015
ID: 717
Name: Sam
Type: Cat
Color: Gold with a bit of white mixed in
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He is declawed-doesn't bite. My best friend! Lost in Beaverdale area at Beaverdale Estates, 4610 Douglas Ave. Please call me-515-707-9151 or Bldg. MGR at 515-278-1715 IS MICROCHIPPED!!!!
Des Moines - East
Lost: 6/7/2015
ID: 712
Name:
Type: Dog
Color: brindall
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Baby
730 pm put her on her leash in her own back yr on des Moines st in des Moines ia
Des Moines - South
Lost: 6/6/2015
ID: 714
Name: Floppy
Type: Dog
Color: Salt and pepper ( gray )
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Adult
SW Titus Ave , Des Moines. Blue collar has "home again" tag ( micro chip ) with numbers and current DSM rabies, loves everybody
Ankeny
Lost: 6/6/2015
ID: 709
Name: Jax
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He is very scared of people unless hungry. He has a very large belly.
Ankeny
Lost: 6/4/2015
ID: 697
Name: Shadow
Type: Cat
Color: Black with Gold eyes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Black Cat with a stiff rear leg. had a coller with phone Number on it.
Cedar Rapids
Lost: 6/4/2015
ID: 688
Name: Goldie
Type: Dog
Color: Golden blonde
Breed: Cocker Spaniel
Gender: Female
Fixed: Neutered
Age: Adult
She was lost somewhere between Cedar Rapids Iowa and champagne Illinois. She has a curly long tail unlike most cocker spaniel her tail isn't clipped. And she is shaved.
Waterloo
Lost: 6/3/2015
ID: 705
Name: Lola
Type: Cat
Color: Mix
Breed: Cocker Spaniel
Gender: Female
Fixed: Unknown
Age: Young
My cat missing
Ankeny
Lost: 6/2/2015
ID:
Name: Stella
Type: Cat
Color: Orange and white
Breed: Cocker Spaniel
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 6/1/2015
ID: 1115
Name: Luna
Type: Dog
Color: light brown or tan with white
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
on Arthur ave
Des Moines - East
Lost: 6/1/2015
ID: 671
Name: Luna
Type: Dog
Color: tan and white
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Adult
On Arthur Ave Des Moines