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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
De Soto
Lost: 6/15/2015
ID: 764
Name: diesel
Type: Dog
Color: grey/tan
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
BACK HOME
Des Moines - Central
Lost: 6/14/2015
ID: 762
Name: Tootie
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Female
Fixed: Not Applicable
Age: Adult
4004 University and 39th street vicinity. Blue Indian Ring Neck Parakeet with a ruby red bill, also silver ankle bracelet.
Urbandale
Lost: 6/14/2015
ID: 760
Name: Suzy
Type: Cat
Color: Grey white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard of 4515 84th St in Urbandale. She is a tuxedo tabby mix with grey and white. Also has a green flea and tick collar. Went missing around 10:30 pm on 6/14/2015.
Des Moines - Central
Lost: 6/13/2015
ID: 939
Name: Tootie
Type: Bird
Color: Blue Indian Ring neck Parakeet, female
Breed: Parakeet
Gender: Female
Fixed: Unknown
Age: Adult
4004 University, 39th and University, central Des Moines close to Cottage Grove, Kingman streets.
Des Moines - Central
Lost: 6/13/2015
ID: 815
Name: Tootie
Type: Bird
Color: Blue Indian Ring neck Parakeet, female
Breed: Parakeet
Gender: Female
Fixed: Unknown
Age: Adult
Last seen 4004 University, Des Moines, Ia and in the vicinity of 39th and University. Our bird also has a loud call. Please call Lynnette 515-279-0777 Tootie is our darling baby, please bring her home. She may be anywhere on the west side of Des Moines or even farther away.
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.