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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Dubuque
Lost: 4/25/2017
ID: 5472
Name: Tabs
Type: Cat
Color: Mostly white and orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
3 year old cat lost in Eagle Point district. Not a very heavy cat. Call 5634953454
Des Moines - Central
Lost: 4/25/2017
ID: 5434
Name: Baby
Type: Cat
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He got out and I haven't seen him since possibly stolen :(
Carlisle
Lost: 4/23/2017
ID: 5461
Name: Achillies
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Rual Carlisle, male orange tabby. Country cat likes to go outside but normally back in at night to sleep with my youngest child. He's very missed.
Polk City
Lost: 4/23/2017
ID: 5425
Name: Louise
Type: Cat
Color: White, black, orange
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
She pulls her collar off and she is very friendly.
Des Moines - Central
Lost: 4/23/2017
ID: 5405
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Baby
40th and Shawnee