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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Lost: 12/10/2020
ID: 16011
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Baby
Pleasant Hill Post Office employee parking lot Lilly is now 18 weeks old and weighs about 17 lbs
Pleasant Hill
Lost: 12/10/2020
ID: 15857
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
Lilly was removed from my car at the Pleasant Hill Post Office’s employee parking lot. She is now 15 weeks old and would weigh about 14 lbs
Pleasant Hill
Lost: 12/10/2020
ID: 15797
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Baby
Pleasant Hill Post Office Lilly is now 14 weeks old and estimated to weigh 14 lbs
Pleasant Hill
Lost: 12/10/2020
ID: 15787
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
Lilly was removed from my car at the Pleasant Hill Post Office
Pleasant Hill
Lost: 12/10/2020
ID: 15714
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Lilly was removed from my car on December 10 mid morning She has 2 blue eyes and is in need of a Vet visit
Pleasant Hill
Lost: 12/10/2020
ID: 15684
Name: Lilly
Type: Dog
Color: Red Merle’
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Baby
$500 reward for the safe return Contact the pleasant Hill police department with information. Lilly was abducted from my car at the Pleasant Hill Post Office. We where going to the vet. Lilly has medical needs .
Des Moines - North
Lost: 12/10/2020
ID: 15660
Name: Cinderella
Type: Cat
Color: Black, white on belly
Breed: Bombay
Gender: Female
Fixed: Neutered
Age: Senior
She is and indoor/outdoor cat and is comfortable being outside. She has a routine neighborhood route she goes each day and always returns home. Extremely friendly. Loves tuna juice.
Des Moines - South
Lost: 12/10/2020
ID: 15659
Name: Ernie
Type: Cat
Color: Grey tabby shorthair with white paws and chest
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Near 1600 block of west Leland Ave, near the airport.
Urbandale
Lost: 12/10/2020
ID: 15655
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Pleasant Hill
Lost: 12/10/2020
ID: 15653
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen at 9 am in my car parked at the Pleasant Hill Post Office. She is currently in need of a puppy shot and Vet visit
Pleasant Hill
Lost: 12/10/2020
ID: 15651
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
Lilly was ABDUCTED from my car at the Pleasant Hill Post Office’s Employee Parking Lot on 12/10 between 9am & 2 pm. Lilly is an 11 week old, Red Merle, mini Australian Shepherd with blue eyes, Lilly weighs about 8 lbs . If you see her or know we’re she is please contact the Pleasant Hill Police Case#_________. Or text me at (515) 393-9010. Any Help in locating Lilly would greatly appreciated. Lilly is in need a puppy shot and medicine. Thank You
West Des Moines
Lost: 12/10/2020
ID: 15649
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Lost: 12/10/2020
ID: 15648
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Newton
Lost: 12/9/2020
ID: 16082
Name: Joel
Type: Cat
Color: Shades of Gray
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Cat looking like Joel was seen 2/26/21 on E 19th St N in Newton.
Urbandale
Lost: 12/9/2020
ID: 15824
Name: Frank
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Waukee
Lost: 12/9/2020
ID: 15658
Name: Frank
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - East
Lost: 12/9/2020
ID: 15652
Name: Pecas
Type: Cat
Color: Grey and brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Arby’s on SE 15th St. He is a house cat and does not usually like to be around other cats. He I might also be scared of loud noises.
Des Moines - South
Lost: 12/9/2020
ID: 15645
Name:
Type: Dog
Color: Off white tan gray
Breed: Poodle
Gender: Unknown
Fixed: Unknown
Age: Adult
Across from blank park zoo
Marshalltown
Lost: 12/8/2020
ID: 15636
Name: Ska
Type: Cat
Color: Grey on top, white on bottom
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
508 Friendly Dr.
Des Moines - North
Lost: 12/7/2020
ID: 15678
Name: Piglet
Type: Cat
Color: Gray striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
House fire Highland Park area
Urbandale
Lost: 12/7/2020
ID: 15631
Name: Ruka
Type: Cat
Color: Black and brown
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Moville
Lost: 12/7/2020
ID: 15628
Name: Obsidian
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Last seen at the Eastside acres trailer parks on frontage Rd in moville iowa. He responds to Obsidian, Sid or Sidian. He has bright red Emmetsburg iowa vet tag on his collar.
Des Moines - South
Lost: 12/6/2020
ID: 15646
Name: Rooster
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near SE 34th Street, she is skittish around new people but very sweet and gentle.
Montezuma
Lost: 12/6/2020
ID: 15634
Name: Hazel
Type: Dog
Color: Brown
Breed: Weimaraner
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen Sunday (12/6) afternoon at Lake ponderosa. Her collar is black with pink embroidered phone number.
Indianola
Lost: 12/6/2020
ID: 15622
Name:
Type: Dog
Color: Black & White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Adult
Found on Highway 69 just outside of Banner State Park