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' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1571270400')) ORDER BY pm1.meta_value DESC, post_date DESC
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 - West
Found: 6/2/2015
ID: 672
Name: Unknown
Type: Dog
Color: Auburn
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Found roaming front lawn at Roosevelt high school. Seems to have poor hearing and vision
Ankeny
Spotted: 6/2/2015
ID: 667
Name:
Type: Dog
Color: Black/White
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Last seen in the 600 Block NW Scott St at approximately 0800 hours on 06/02. Residents in the neighborhood state the dog has been running loose in the area for 4-5 days. Dog was seen wearing a black collar, unknown if male or female. Very skittish and keeps its distance. Please contact Ankeny PD at 515.289.5240 with any information so we can get this family member back home!
Ankeny
Spotted: 6/2/2015
ID: 666
Name:
Type: Dog
Color: Black/White
Breed: Boston Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Last seen in the 600 Block NW Scott St at approximately 0800 hours on 06/02. Residents in the neighborhood state the dog has been running loose in the area for 4-5 days. Dog was seen wearing a black collar, unknown if male or female. Very skittish and keeps its distance. Please contact Ankeny PD at 515.289.5240 with any information so we can get this family member back home!
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
Davenport
Spotted: 6/1/2015
ID: 790
Name: ?
Type: Cat
Color:
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Seems lost or abandoned. Keeps coming over, hungry.
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
Des Moines - North
Found: 6/1/2015
ID: 669
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
Des Moines - North
Found: 6/1/2015
ID: 668
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
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!!!
Ankeny
Found: 6/1/2015
ID: 664
Name: Sarabi
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Not declawed. Terrified of being outside. Answers to Sarabi and Robby.
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.