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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Mingo
Lost: 4/12/2021
ID: 16570
Name: Willie
Type: Cat
Color: Grey and brown tabby
Breed:
Gender: Male
Fixed: Neutered
Age: Young
Guthrie Center
Lost: 4/12/2021
ID: 16462
Name: Sasha (Golden retriever) Buddy (black lab/retriever)
Type: Dog
Color: Older golden and black
Breed: Retriever, Labrador
Gender: Male
Fixed: Not Neutered
Age: Senior
Located Guthrie Center They live 2 miles northeast of Guthrie.
Berwick
Lost: 4/12/2021
ID: 16443
Name: Baloo
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen tonight. He got out went running through the mobile home park in berwick. He is very scared
Berwick
Lost: 4/12/2021
ID: 16442
Name: Baloo
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen tonight. He got out ran through mobile home park in berwick. Goes by baloo or kitty but is very scared
Altoona
Lost: 4/11/2021
ID: 16463
Name: Star
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Got out of house accidentally, would have been in Adventureland Estates area of Altoona.
Des Moines - South
Lost: 4/11/2021
ID: 16437
Name: Diago
Type: Cat
Color: Mostly black with some white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Nevada
Lost: 4/11/2021
ID: 16434
Name: Mayla
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She is almost 1 year old. Also front declawed, spayed and micro chipped. Last seen around 3rd St and N Ave in Nevada.
West Des Moines
Lost: 4/11/2021
ID: 16432
Name: Smokey
Type: Cat
Color: Color point-cream and brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
He was outside on our acreage, he always stays close to the house. We suspect someone took him.
Dubuque
Lost: 4/11/2021
ID: 16430
Name: Milo
Type: Dog
Color: Black with a white patch on chest
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen running behind cresent on the train tracks, very friendly to people. Wearing a black harness.
Dubuque
Lost: 4/11/2021
ID: 16425
Name: Tazz
Type: Dog
Color: White and black
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Young
He was last seen around 6:30pm on Jackson Street
Granger
Lost: 4/10/2021
ID: 16421
Name: Ranger
Type: Dog
Color: Brown, speckled white and black
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Approx 55 lbs, he is normally very calm and relaxed. He does get excited but isn’t rough. Does not have any issues with dogs or other animals
Ankeny
Lost: 4/10/2021
ID: 16415
Name: Kahlua
Type: Cat
Color: White with black and brown
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
She was adopted from the humane society after being found on the streets. Since then she has never been outside. She is very skittish.
Des Moines - Central
Lost: 4/9/2021
ID: 16498
Name: Taz
Type: Cat
Color: White and orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Cedar Falls
Lost: 4/9/2021
ID: 16467
Name: Bo
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen: 3500 Block W 1st Street, Cedar Falls, IA. Bo is extremely friendly and loves pets. He is ear tipped on the RIGHT. If you see him or have him, please call/text 319-231-9433
Dubuque
Lost: 4/9/2021
ID: 16431
Name: Envy
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Last seen in alpine trailer park. Very skittish bur persuaded with food and towels calm her down. Is my ESA cat in training so can sense emotions
Pleasant Hill
Lost: 4/9/2021
ID: 16419
Name: Snickers
Type: Cat
Color: Gray and white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
Magnolia dr
Urbandale
Lost: 4/9/2021
ID: 16417
Name: Arthur
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Arthur escaped outside last night around 10:00 pm. He didn’t come home. I’ve been looking around for him since then with no luck. I live on 4800 block of 78th street in Urbandale.
Des Moines - South
Lost: 4/9/2021
ID: 16416
Name: Taz
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 4/9/2021
ID: 16413
Name: Midnight
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 4/9/2021
ID: 16412
Name: Midnight
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Waterloo
Lost: 4/8/2021
ID: 16410
Name: Bruno
Type: Dog
Color: White with some tan
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Senior
About 4 pm april 8th, 2021
Des Moines - North
Lost: 4/8/2021
ID: 16409
Name: Buddha
Type: Dog
Color: Brown
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Senior
Last seen near Thompson Ave and East 15th.
Clive
Lost: 4/8/2021
ID: 16407
Name: Kane
Type: Dog
Color: Tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
He was at my ex apartment when I went with an officer but since my ex wasn’t there I could not get him so I went back at 6 and Kane had got out the window last seen at 8186 harbach boulevard Clive Iowa
Des Moines - Central
Lost: 4/7/2021
ID: 16510
Name: Binx
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Waukee
Lost: 4/7/2021
ID: 16509
Name: Mittens
Type: Cat
Color: Gray and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Accidentally left door open:( Saw on camera over night.