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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 9/19/2018
ID: 9631
Name: Beads
Type: Bird
Color: Green yellow orange
Breed: Conure
Gender: Unknown
Fixed: Unknown
Age: Young
3:05
Des Moines - East
Lost: 9/19/2018
ID: 9627
Name: Ziggy
Type: Bird
Color: Yellow and White
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Young
last seen around 11:30am
Davenport
Lost: 9/18/2018
ID: 11270
Name: Shadow
Type: Dog
Color: White
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Baby
September 28 , 2018. He friendly to us. He stay and sit. We miss him so much.
Des Moines - North
Lost: 9/18/2018
ID: 9626
Name: MIYA
Type: Dog
Color: Black whit and brown with blue eyes
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
She is very friendly. She has Brown circles around her eyes that are very light and Brown behind her ears call 515 803 8980
Des Moines - South
Lost: 9/18/2018
ID: 9623
Name: Stayley
Type: Dog
Color: Yellow
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Adult
On SE 30 ct in Easter lake
Des Moines - Central
Lost: 9/17/2018
ID: 9618
Name: Colby
Type: Cat
Color: Orange
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 9/17/2018
ID: 9616
Name: Zula
Type: Dog
Color: Orange and black
Breed: Rottweiler
Gender: Unknown
Fixed: Not Neutered
Age: Young
1310 23rd St
Des Moines - South
Lost: 9/17/2018
ID: 9613
Name: Chaos
Type: Dog
Color: Black and white
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
On 1199 Mason Des Moines Ia 50315
Dubuque
Lost: 9/17/2018
ID: 9612
Name: Addie
Type: Dog
Color: Red
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Young
Very sweet dog and wanting her back home.
Des Moines - South
Lost: 9/16/2018
ID: 9646
Name: Fluffy
Type: Bird
Color: Yellow
Breed: Parakeet
Gender: Female
Fixed: Unknown
Age: Young
Altoona
Lost: 9/16/2018
ID: 9599
Name: Bruce and winter
Type: Dog
Color: Blue and red
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in Altoona by fareway
Des Moines - South
Lost: 9/15/2018
ID: 9655
Name: Coco
Type: Dog
Color: White/light brown
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Baby
Coco is a new dog that we just got at the beginning of the year for my nieces birthdays she is very loved by them and they can’t live with out her. She was last seen on 9/15 please help us look for her..
West Des Moines
Lost: 9/15/2018
ID: 9610
Name: Bicycle (Bike)
Type: Cat
Color: Black and White
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly and chatty
Des Moines - South
Lost: 9/15/2018
ID: 9598
Name: Lady
Type: Dog
Color: Tan/White
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Young
Sw 9th and virginia ave
Des Moines - North
Lost: 9/14/2018
ID: 9657
Name: Gizmo
Type: Cat
Color: Gray/brown tiger
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Crooked, half-tail. Canine teeth have been pulled.
Des Moines - East
Lost: 9/14/2018
ID: 9588
Name: Oscar
Type: Cat
Color: White with grey spots
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Oscar last seen early morning got loose. Friendly cat. 2 years old no collar or microchip. Please call if spotted or found. Molli 515-783-6732
Des Moines - North
Lost: 9/14/2018
ID: 8606
Name: Gizmo
Type: Cat
Color: Gray/brown
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Short, crooked tail. Both front canine teeth have been extracted.
Des Moines - Central
Lost: 9/13/2018
ID: 9594
Name: Addie
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly, has a notched right ear, arches and twitches her tail when happy
Des Moines - West
Lost: 9/13/2018
ID: 9583
Name: N/a
Type: Dog
Color: Black and white
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Around Valley junction area
West Des Moines
Lost: 9/12/2018
ID: 9592
Name: Turbo
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Very friendly. Loves to pur and snuggle.
Urbandale
Lost: 9/12/2018
ID: 9586
Name: Milo
Type: Cat
Color: Tan/Blonde and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, usually just stays in our yard when he gets out but never came home. Please call or text 515-227-2713
Altoona
Lost: 9/12/2018
ID: 9585
Name: Chelsea
Type: Dog
Color: Gold/yellow
Breed: Basenji
Gender: Female
Fixed: Not Neutered
Age: Adult
Chelsea is very shy and scared but WILL NOT BITE!
Des Moines - East
Lost: 9/12/2018
ID: 9577
Name: Tank
Type: Dog
Color: Reverse brindle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
On Guthrie, he looks intimidating but he is just a big baby.
Des Moines - East
Lost: 9/12/2018
ID: 9576
Name: Tank
Type: Dog
Color: Reverse brindle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 9/12/2018
ID: 9573
Name: Rocco
Type: Dog
Color: Like a buck skin
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in my house I went to my neighbor house for a cell phone charger was there maybe 10 minutes came back and he was gone this dog wouldn't hurt a fly very kid friendly and My Best Friend my daughter's are very upset as well so if you see him or know something please call me or email me possibly a reward