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
Des Moines - East
Lost: 6/1/2015
ID: 670
Name: Luna
Type: Dog
Color: tan and white
Breed:
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
Madrid
Lost: 5/25/2015
ID: 603
Name: Cooper
Type: Dog
Color: Brown white
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Swede point area
Bondurant
Lost: 5/24/2015
ID: 684
Name: Oliver
Type: Cat
Color: white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He is an indoor / outdoor country cat. He is used to people and chickens, but not fond of dogs.
Des Moines - East
Lost: 5/23/2015
ID: 650
Name: Sniper
Type: Dog
Color: Tan & Black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
He was stolen from the ARL he is originally from the east side of des moines. He is blind in his left eye. Please call 515-257-3482 with any information please!
Davenport
Lost: 5/23/2015
ID: 607
Name: Oscar
Type: Dog
Color: Black /w a little brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Davenport, Ia near Kirkwood Blvd & College Ave Yorkie mix & friendly 1 1/2 yrs old
Ankeny
Lost: 5/22/2015
ID: 610
Name: Van Gogh
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Got away from a harness on Springfield drive in ankeny. May be in window wells or under porches.
Ankeny
Lost: 5/22/2015
ID: 605
Name: Van Gogh
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Lost on Springfield drive. Escaped from a harness. We miss him so much.
Des Moines - East
Lost: 5/21/2015
ID: 584
Name: Winston
Type: Dog
Color: white, black spotd
Breed: Sheep Dog
Gender: Male
Fixed: Neutered
Age: Young
On east Seneca at hope Lutheran Church in does Moines iowa
Norwalk
Lost: 5/20/2015
ID: 589
Name: Axl
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 5/19/2015
ID: 575
Name: Rogue
Type: Cat
Color: black brown white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She missing a tiny piece of her left ear. Very friendly. Comes to you when you snap your fingers.
Milo
Lost: 5/18/2015
ID: 1632
Name: Dierks Taggart
Type: Dog
Color: White with carmel spots
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
Has a chip, registered under Gabriel and Chelsea Taggart