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>='1632268800')) ORDER BY pm1.meta_value DESC, post_date DESC
Thor
Lost: 9/8/2021
ID: 17678
Name: Pearl
Type: Cat
Color: White
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
Night before. She always comes when called.
Des Moines - East
Lost: 9/8/2021
ID: 17677
Name: Sir
Type: Dog
Color: White with brindal patches
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
He is deaf and going blind. Very kind and loving. Will most likely come for treats. Has his red service dog vest on. He got out in the area of Hutton Ave and Cleveland on Des Moines Eastside around 1pm today.
Des Moines - East
Lost: 9/8/2021
ID: 17667
Name: Unknown
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
He’s very friendly with other dogs. He came up to my boyfriend and I but it took a little bit of time.
Ankeny
Lost: 9/8/2021
ID: 17666
Name: Dahlia
Type: Dog
Color: Black
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Adult
Near NW Sharmin Dr. in Ankeny
Des Moines - East
Lost: 9/8/2021
ID: 17661
Name:
Type: Dog
Color: White
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
Oakland
Lost: 9/7/2021
ID: 17800
Name: Luna
Type: Cat
Color: Gray all over
Breed: Chartreux
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen at 8pm near Virgila Place and Juliette Street in South Oakland in Pittsburgh. He has a clipped left ear and has dandruff on his back. He was a bigger cat, but could be thin now.
Pleasant Hill
Lost: 9/7/2021
ID: 17703
Name: Midna
Type: Cat
Color: Black, white
Breed: Chartreux
Gender: Female
Fixed: Unknown
Age: Young
Pleasant hill, intersection of NE 12 ave and NE 64th street, hiding on property NE of T street
Des Moines - South
Lost: 9/7/2021
ID: 17680
Name: Mr. Meows
Type: Cat
Color: Black and gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Last seen at the Glenwood Trailer Park. He has really green eyes and really long gang teeth. Hes a sweetie
Urbandale
Lost: 9/7/2021
ID: 17672
Name: Cadet
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was in our house all morning on the seventh he was play fighting with one of our other cats
West Des Moines
Lost: 9/7/2021
ID: 17669
Name: Luna
Type: Cat
Color: Grey with a tinge of brown
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Maple Grove Villas in West Des Moines. Very sweet cat, responds to high pitched whistles
Des Moines - Central
Lost: 9/7/2021
ID: 17658
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
I have cat in a kennel safe with food and water.
Des Moines - West
Lost: 9/7/2021
ID: 17652
Name:
Type: Dog
Color: Black
Breed: Bull Terrier
Gender: Male
Fixed: Unknown
Age: Baby
He got out of my back yard and I live by the beaverdale park area so if you see him please let me know or contact me at 5158098882
Turin
Lost: 9/5/2021
ID: 17665
Name: Rupert
Type: Dog
Color: Brown ticked
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen outside of turin on 175 west to onawa.
West Des Moines
Lost: 9/4/2021
ID: 17654
Name: Lily
Type: Cat
Color: Brown, black, gray
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Lily is a small, awkward tabby cat with a very loud meow. She likes canned wet food and will come at the sound of the can opening. She has been an inside/outside cat for her whole life, but we recently moved to the area and does not know her way around.
Grimes
Lost: 9/4/2021
ID: 17645
Name: Lincoln
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Was last seen near NW 100th St. in Grimes. Could possibly head towards Indianola since he was being watched up there while we were out of town. He is very friendly
Mount Pleasant
Lost: 9/4/2021
ID: 17639
Name: Trixie
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 9/3/2021
ID: 17657
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
812 Creston DSM 50315 Sadie is very friendly and she is professional escape artist. Please , come home
Des Moines - South
Lost: 9/3/2021
ID: 17656
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Sadie is very friendly. She is a professional escape artist also....please come home 5153336096
Des Moines - South
Lost: 9/3/2021
ID: 17649
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Sadie is very friendly Please call Beth 5153336096
Des Moines - North
Lost: 9/3/2021
ID: 17640
Name: Onyx
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
33rd & College
Waterloo
Lost: 9/3/2021
ID: 17636
Name: Lucy
Type: Dog
Color: Black/white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Baby
Echo lounge downtown Waterloo
Des Moines - Central
Lost: 9/3/2021
ID: 17630
Name: Romeo
Type: Cat
Color: Orange stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen at the 37/38 block of kingman blvd in Des Moines. He has two symmetrical freckles on his nose. Very friendly and vocal.
Coralville
Lost: 9/3/2021
ID: 17629
Name: Dukey
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Very timid and scared. Most likely hiding under things.
Des Moines - North
Lost: 9/3/2021
ID: 17628
Name: Flora
Type: Dog
Color: Brown
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Baby
She was last seen on 40th St., she was wearing a blue harness.
West Des Moines
Lost: 9/3/2021
ID: 17625
Name: Unknown
Type: Dog
Color: Black and Tan
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Young
Found on the road at 2800 Fuller Road in West Des Moines No Microchip, no ID Collar. Dog is being taken to the ARL