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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 5/6/2017
ID: 5502
Name: Sheeba
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Newton
Lost: 5/6/2017
ID: 5501
Name: Jed
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Near S 13th St W He should be with a yellow female lab that has a bark collar on that is black. The black lab is Jed and the yellow lab is Maddie.
Altoona
Lost: 5/6/2017
ID: 5499
Name: Tucker
Type: Dog
Color: Brown & White
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Neutered
Age: Baby
In Altoona
Norwalk
Lost: 5/5/2017
ID: 5526
Name: Remy
Type: Dog
Color: Black and white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Near Norwalk
Leland
Lost: 5/5/2017
ID: 5489
Name: Romeo
Type: Dog
Color: Brown white black
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Leland iowa just ran out of my girlfriends apartment
Hawkeye
Lost: 5/4/2017
ID: 5505
Name: Kyla
Type: Dog
Color: Black & White - a few brown spots
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Young
Kyla is an outside dog and familiar with the yard. She was barking in the night. Kyla can be shy with strangers.
Des Moines - East
Lost: 5/4/2017
ID: 5496
Name: Sushi
Type: Cat
Color: Grey tabby
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Sushi is soft spoken. His meow is small. He is friendly and loves to get attention until he's done, then he likes to be close.
Des Moines - Central
Lost: 5/4/2017
ID: 5487
Name: Cheeto
Type: Dog
Color: Black and Brown-Tan
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Merle Hay area
Des Moines - East
Lost: 5/4/2017
ID: 5486
Name: Bumkin
Type: Dog
Color: tan
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Young
east side des moines, near capitol. blind in one eye. will respond to name
Des Moines - East
Lost: 5/3/2017
ID: 5485
Name: Oscar
Type: Cat
Color: Gray/White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at home on East Side of DSM, unsure if he got out or not.
Ankeny
Lost: 5/3/2017
ID:
Name: brinlee
Type: Dog
Color: Liver
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Young
She was last seen on the NE 29th block off of Delaware in Ankeny! She is a great dog and too smart for her own good unlocking our fence!
Des Moines - South
Lost: 5/3/2017
ID: 5479
Name: Unknown
Type: Dog
Color: Primarily black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Near Lincoln High School down Creston ave
Elk Horn
Lost: 5/2/2017
ID: 5540
Name: Spud
Type: Dog
Color: Black and Tan
Breed: Black And Tan Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
Has an electronic dog collar that is faded. Scar behind front elbow, tattoo in ear.
Iowa City
Lost: 5/1/2017
ID: 5465
Name: Boss ladi
Type: Dog
Color: Black white a lil grey
Breed: Poodle Standard
Gender: Female
Fixed: Not Neutered
Age: Baby
On Muscatine Ave across from Walgreens
Des Moines - North
Lost: 4/30/2017
ID: 5454
Name: Jersey
Type: Dog
Color: Black with White markings
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Beaver Avenue, near Hickman Road. She is new to us and slipped her collar. Hasn't even been to vet for microchipping yet. Help!
West Des Moines
Lost: 4/29/2017
ID: 5562
Name: Mao
Type: Cat
Color: Tiger Striped (Long(ish) fur
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is friendly but, he is vocal. Last seen in the Valley Junction Area 6th and Maple his microchip will come back to Cedar Falls. This is my daughter's cat please contact me (Reward)
Des Moines - North
Lost: 4/29/2017
ID: 5460
Name: Nosey
Type: Cat
Color: Multi
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen around the 2nd and aurora area... she is very petite and her brother is missing her
Des Moines - South
Lost: 4/29/2017
ID: 5449
Name: Apollo
Type: Dog
Color: Base: White/Silver Eyes: Blue
Breed: Alaskan Husky
Gender: Male
Fixed: Neutered
Age: Young
Pretty Husky, blue eyes. Will have reward.
Bondurant
Lost: 4/28/2017
ID: 5450
Name: Moses
Type: Cat
Color: Blue
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Got out around 11:00 pm from door unintentionally left open. Last seen in Bondurant
Des Moines - North
Lost: 4/28/2017
ID: 5448
Name: JonJon
Type: Cat
Color: Tiger-stripped
Breed: Bobtail
Gender: Female
Fixed: Not Applicable
Age: Young
Small gal, bob-tail kitty, very friendly, knows her name, she's almost 2yrs. old. She has served as a therapy cat for my disabled husband. I think she might have gotten outside on the evening of 4/27 or morning of 4/28 she has never been outdoors before. She is very special and is needed back home.
Des Moines - West
Lost: 4/27/2017
ID: 5625
Name: July
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
It was in its leash outside then when we went to check on him he ran away he has black spots and blue eyes
Ankeny
Lost: 4/27/2017
ID:
Name: Jack
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Primrose Dr. in SE Ankeny
Des Moines - North
Lost: 4/27/2017
ID: 5437
Name: Tonks
Type: Dog
Color: White with Black spots
Breed: Pointer
Gender: Female
Fixed: Unknown
Age: Adult
Near 2nd & Euclid, no collar as she slipped her harness. Very sweet, very fast.
Dubuque
Lost: 4/25/2017
ID: 5474
Name: Tabs
Type: Cat
Color: Mostly white and orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Golden Eagle Dr. He is very friendly 3 year old foundling. His owner has cancer and sorely misses him. call 5634953454
Dubuque
Lost: 4/25/2017
ID: 5473
Name: Tabs
Type: Cat
Color: Mostly white and orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Golden Eagle Dr, Dubuque call 5634953454