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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 9/1/2021
ID: 17641
Name: Winter
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Please help find my baby Winter???? He was last seen on 19th St. and E Walnut
Johnston
Lost: 9/1/2021
ID: 17620
Name: Ari
Type: Cat
Color: White/Black face
Breed: Himalayan
Gender: Male
Fixed: Neutered
Age: Senior
9647 NW 70th Ave. Was startled while outside in our driveway on 9/1/21 with us. Went through fence into neighbors yard which is former farm land and very overgrown. No front claws and is 15 years old. He has no collar but is chipped.
Altoona
Lost: 9/1/2021
ID: 17616
Name: Max
Type: Cat
Color: Black & white
Breed: Himalayan
Gender: Male
Fixed: Neutered
Age: Young
Waterloo
Lost: 9/1/2021
ID: 17611
Name: Unknown
Type: Dog
Color: Red/tan/white
Breed: Himalayan
Gender: Female
Fixed: Unknown
Age: Adult
Found near 1000 block of Conger St in Waterloo, IA
Ames
Lost: 8/31/2021
ID: 17600
Name: Bigwig
Type: Cat
Color: Orange
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, scared of dogs
Des Moines - North
Lost: 8/31/2021
ID: 17594
Name: Harley
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Nw 9th & Nw 43rd can easily be caught by a ball
Des Moines - North
Lost: 8/31/2021
ID: 17593
Name: Bo
Type: Dog
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on 4th street and Clark, Bo is diabetic and doesn’t see very well.
Des Moines - North
Lost: 8/30/2021
ID: 17770
Name: MALCOLM
Type: Dog
Color: Brown, red nose
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Senior
My grandpa last seen him at 3 pm he is not known to run away…
Altoona
Lost: 8/30/2021
ID: 17642
Name: Snowflake
Type: Dog
Color: White
Breed: Pomeranian Toy
Gender: Female
Fixed: Not Neutered
Age: Baby
Missing from yard on 13th st and 8th Ave se Altoona iowa. Very friendly and hyper. Will come to anyone
Des Moines - North
Lost: 8/30/2021
ID: 17638
Name: Malcolm
Type: Dog
Color: Light, medium brown
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen in a fenced in area someone left the fence open, this dog is not known to run away but he is depressed.. I keep getting told that my “friend” has my dog but that is unknown too he said he has not seen the dog since Monday.
Des Moines - Central
Lost: 8/30/2021
ID: 17596
Name: Babygirl
Type: Cat
Color: Black brown tan grey
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Williams/42nd St by copper Creek
Des Moines - East
Lost: 8/30/2021
ID: 17595
Name: Baby Girl
Type: Cat
Color: Black gray tan brown
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Adult
50317 Eastside Des Moines by copper Creek lake 42nd st
Des Moines - East
Lost: 8/30/2021
ID: 17584
Name: Yuki
Type: Dog
Color: All white
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
On lower beaver road by Woodlawn preschool and legacy apartments
Des Moines - East
Lost: 8/30/2021
ID: 17583
Name: Bentley
Type: Dog
Color: Black/white
Breed: American Bulldog
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Last seen with yellow Akita lab mix
West Des Moines
Lost: 8/29/2021
ID: 17674
Name: Tyton
Type: Cat
Color: orange with brown spots looks like mini lepard
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Baby
8005 and 8704 ashword rd west des moines
West Des Moines
Lost: 8/29/2021
ID: 17673
Name: Tyton
Type: Cat
Color: orange with brown spots looks like mini lepard
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
8704 asworth rd west des moines
Granger
Lost: 8/29/2021
ID: 17604
Name: Jasper
Type: Cat
Color: See picture
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Homestead Drive Very friendly.
Urbandale
Lost: 8/29/2021
ID: 17599
Name: Orlando
Type: Cat
Color: brownish gray and white with black stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
In Urbandale Eula Dr and Dennis Dr. Not far from Walker Johnson Park area. He is very docile and sweet. No collar He is a senior dog with special diet needs. He is very loved and missed!!!
Urbandale
Lost: 8/29/2021
ID: 17588
Name: Orlando
Type: Cat
Color: brown and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Brown and white male tabby. He is very docile. He is declawed. He weighs about 8-9lbs and is a senior cat.
Des Moines - East
Lost: 8/29/2021
ID: 17582
Name: Bandit
Type: Dog
Color: Yello/white
Breed: Akita
Gender: Male
Fixed: Neutered
Age: Adult
Fairgrounds neighborhood. Went missing with black and white pitbull puppy
New Albin
Lost: 8/29/2021
ID: 17581
Name: Lucky
Type: Dog
Color: White and black
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Senior
New Albin area..by historical church in country
Des Moines - Central
Lost: 8/29/2021
ID: 17579
Name: Buttons
Type: Dog
Color: Black brown and white
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Adult
She is very nice. She got out last night around grandview university
Nashua
Lost: 8/28/2021
ID: 17586
Name: Willow
Type: Dog
Color: Red/Brown
Breed: GoldenDoodle
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen @ 830am. Setter took off & she followed. Setter came back home at 1am
Earlham
Lost: 8/26/2021
ID: 17563
Name: Toby
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly
Earlham
Lost: 8/26/2021
ID: 17562
Name: Frank
Type: Dog
Color: White
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
He has a half blue eye. Very friendly