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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - East
Lost: 6/1/2015
ID: 670
Name: Luna
Type: Dog
Color: tan and white
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
On Arthur Ave Des Moines
Altoona
Lost: 6/1/2015
ID: 665
Name: Lucy
Type: Cat
Color: Tortoise
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Adult
Please call if you have seen her!!!
Des Moines - East
Lost: 6/1/2015
ID: 662
Name:
Type: Dog
Color: Tan , white
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Adult
Union Park area She is part of our family please help us find her!!! Cash reward if foun
Ames
Lost: 5/31/2015
ID: 678
Name: lady
Type: Dog
Color:
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Adult
kingsbury east side 117
Ames
Lost: 5/31/2015
ID: 677
Name: lady
Type: Dog
Color: black and white
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Adult
east side of ames Kingsberryroad and lincoln way close well she liked the skunk river south wal=mart target area south towards south16 towards 30 hope not that far
Des Moines - South
Lost: 5/31/2015
ID: 661
Name: Jax
Type: Dog
Color: Orange
Breed: Vizsla
Gender: Male
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 5/31/2015
ID: 657
Name: Rooney
Type: Dog
Color: Tan
Breed: Cairn Terrier
Gender: Male
Fixed: Neutered
Age: Adult
9:30am
Des Moines - East
Lost: 5/30/2015
ID: 663
Name: hunter
Type: Dog
Color:
Breed: Cairn Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Knoxville Drive on the East Side close to Pleasant Hill very friend dog he's part of our family!!!!
Des Moines - North
Lost: 5/30/2015
ID: 652
Name: Dexter
Type: Dog
Color: brown with white feet and chest
Breed: Retriever, Labrador
Gender: Male
Fixed: Neutered
Age: Young
Dexter escaped the backyard in the morning which he's done several times but he never runs away. He always comes home. We have a feeling someone picked him up for us so if you have him please give us a call or text or email or anything. Dexter is extremely friendly and happy.
Des Moines - North
Lost: 5/30/2015
ID: 651
Name: Dexter
Type: Dog
Color: brown with white feet and chest
Breed: Retriever, Labrador
Gender: Male
Fixed: Neutered
Age: Young
Dexter escaped the backyard in the morning which he's done several times but he never runs away. He always comes home. We have a feeling someone picked him up for us so if you have him please give us a call or text or email or anything. Dexter is extremely friendly and happy.
Des Moines - Central
Lost: 5/26/2015
ID: 622
Name: cujo
Type: Cat
Color: black tiger striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
19th and woodland , he's got sores behind his ears, loving cat, probably scared , registered to 672 19th st. Apt. #4 515-528-9627 He is black and has tiger like markings .