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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
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 .
Iowa City
Lost: 5/25/2015
ID: 673
Name: Coco
Type: Dog
Color: Reddish Brown
Breed: Brussels Griffon
Gender: Female
Fixed: Neutered
Age: Senior
Modern Manor off of Scott Boulevard. East Side Iowa City.
Des Moines - South
Lost: 5/25/2015
ID: 620
Name: Sophie
Type: Dog
Color: Brown
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen Between pioneer Rd and lacona on se 7th St please return 75$ reward call 515-664-3191 Emily
Des Moines - West
Lost: 5/25/2015
ID: 616
Name: Dipper
Type: Cat
Color: gray, white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Location is Beaverdale (Marella Trail near Franklin.) Last seen Monday, 5-25. Never has been outdoors before. Likely afraid. Owner's cell is best to call: Bob Brammer, 515-480-5296. (Or 515-360-2397.)
Madrid
Lost: 5/25/2015
ID:
Name: Cooper
Type: Dog
Color: Brown white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Swede point area