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>='1614643200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ottumwa
Lost: 11/11/2020
ID: 15460
Name: Midnite
Type: Dog
Color: Black
Breed:
Gender: Male
Fixed: Unknown
Age: Senior
He is an older dog . very nice and much loved . he has no teeth left . short hair at the moment but does grow long
Ottumwa
Lost: 11/11/2020
ID: 15459
Name: Midnite
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Senior
He is an older dog . very nice and much loved . he has no teeth left . short hair at the moment but does grow long
Ottumwa
Lost: 11/11/2020
ID: 15458
Name: Midnight
Type: Dog
Color: black
Breed: Pomeranian Standard
Gender: Male
Fixed: Unknown
Age: Adult
Missing family last seen on Davis street in ottumwa iowa Midnight is 13 years old well loved an super friendly help pass the word thanks for looking
Ackworth
Lost: 11/11/2020
ID: 15457
Name: Dixie
Type: Dog
Color:
Breed: Basset Hound
Gender: Female
Fixed: Not Applicable
Age: Young
Winterset
Lost: 11/11/2020
ID: 15455
Name: Raja
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around the High School
Winterset
Lost: 11/11/2020
ID: 15454
Name: Raja
Type: Cat
Color: Black with brown tint
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around High school in Winterset
Waterloo
Lost: 11/11/2020
ID: 15451
Name: Benji
Type: Dog
Color: Grey with black and white spots
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Young
Hope Martin park Waterloo Iowa
Dubuque
Lost: 11/11/2020
ID: 15448
Name: Gizmo
Type: Cat
Color: Grey black white
Breed: Dilute Calico
Gender: Unknown
Fixed: Not Applicable
Age: Baby
Has never been outside
Britt
Lost: 11/10/2020
ID: 15563
Name: Zippy
Type: Dog
Color: Grayish blackish whitieish
Breed: Terrier
Gender: Male
Fixed: Not Applicable
Age: Adult
Des Moines - East
Lost: 11/9/2020
ID: 15444
Name: Bandit
Type: Dog
Color: Black, white, and tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by the US bank and Perkins on Euclid
Des Moines - East
Lost: 11/9/2020
ID: 15441
Name: Bullwinkle
Type: Cat
Color: Brown and black tabby
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Please help find our kitty. He slipped out on my daughters birthday last night and we all miss him dearly. This momma is a mess and so is his twin brother who wont stop crying for him.
Des Moines - East
Lost: 11/9/2020
ID: 15440
Name: Bullwinkle
Type: Cat
Color: Brown and black tabby
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Please help find our kitty. He slipped out on my daughters birthday last night and we all miss him dearly. This momma is a mess and so is his twin brother who wont stop crying for him.
Des Moines - South
Lost: 11/9/2020
ID: 15438
Name: Bean
Type: Cat
Color: Orange, white on chest, paws, and tails
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He probably won't answer to his name.
Des Moines - Central
Lost: 11/9/2020
ID: 15437
Name: Huey
Type: Dog
Color: Light brown
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Senior
10AM last seen. Very friendly, doesn’t bite. Will run if chased because he thinks you’re playing with him.
Des Moines - South
Lost: 11/8/2020
ID: 15481
Name: Reese
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Got out sunday evening she is pregnant and has never been gone this long.
Des Moines - East
Lost: 11/8/2020
ID: 15465
Name: Buns
Type: Cat
Color: Black
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Young
$100.00 reward
Woodburn
Lost: 11/8/2020
ID: 15446
Name: Lily
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Adult
The neighbor saw a car stop in front of our house in the dark opened their door messed around and she hasn’t been seen since.
Des Moines - East
Lost: 11/8/2020
ID: 15442
Name: Buns
Type: Cat
Color: Black
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 11/8/2020
ID: 15432
Name: Ranger
Type: Dog
Color: Blonde
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Beaverdale Park.
Indianola
Lost: 11/7/2020
ID: 15445
Name: Mesa
Type: Dog
Color: Silver
Breed: Weimaraner
Gender: Female
Fixed: Neutered
Age: Adult
Intersection of Hwy 69 and Sherman St.
Des Moines - East
Lost: 11/7/2020
ID: 15433
Name: Frosti
Type: Cat
Color: Grey and white
Breed: Scottish Fold
Gender: Female
Fixed: Neutered
Age: Adult
It is suggested that you do NOT try to pick her up. While she is very sweet and loving, she detests being picked up and you may regret it. Just leave her alone and call us to let us know where she is. She is very skittish and will probably run away if approached. Please call 330-1638.
Des Moines - West
Lost: 11/7/2020
ID: 15430
Name: Abby
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Black and white domestic shorthair with mask and mantle pattern. Pink nose and paw pads. Medium sized. Shy-ish indoor cat.
Des Moines - North
Lost: 11/7/2020
ID: 15428
Name: Pixel
Type: Cat
Color: White and grey tiger
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Missing a back leg
Des Moines - South
Lost: 11/7/2020
ID: 15427
Name: Nini (neenee)
Type: Cat
Color: Tabby - black stripes, grey, slightly brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He has never been outdoors, he knows his name and needs special urinary food. He probably won’t come up to anyone but me, his owner
Des Moines - West
Lost: 11/7/2020
ID: 15424
Name: Lucy
Type: Dog
Color: No
Breed: Jack Russell Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Water Works Park north