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 - Central
Lost: 12/3/2017
ID: 7561
Name: Buttercup
Type: Cat
Color: Black and brown and tan
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
She was last seen this morning at 1428 7th seventh apt 2 she very friendly she would come up to you if you call her name
Grimes
Lost: 12/2/2017
ID: 7555
Name: Gus
Type: Dog
Color: White with brown liver spots
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Sneaking and running out our door toward Cutty's Campground. He is fast and may think it's a game if you try to chase him, but very food-motivated! He's very friendly and loves everyone!
Des Moines - North
Lost: 12/2/2017
ID: 7551
Name: Nikka
Type: Dog
Color: Tan and black
Breed: Belgian Shepherd Malinois
Gender: Female
Fixed: Not Neutered
Age: Young
5590 NE 3rd Street. She loves squeaky toys.
Ankeny
Lost: 12/2/2017
ID: 7550
Name: Nikka
Type: Dog
Color: Brown and black
Breed: Belgian Shepherd Malinois
Gender: Female
Fixed: Not Neutered
Age: Young
5590 NE 3rd Street. She loves squeaky toys
Des Moines - East
Lost: 12/1/2017
ID: 7834
Name:
Type: Cat
Color: Stripped
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
1544 Royer st Des Moines Iowa 50316
Des Moines - East
Lost: 12/1/2017
ID: 7829
Name:
Type: Cat
Color: Stripped
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
1544 Royer st Des Moines Iowa 50316
Des Moines - East
Lost: 12/1/2017
ID: 7713
Name: Bella
Type: Cat
Color: White with orange and black with white tipped tail
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around hickory hill ln in valley high manor. She may have been with babies. Please call 5155547473!
Ankeny
Lost: 12/1/2017
ID: 7625
Name: Cinders
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
On N.W. Wesrwood St. Ankeny, ia
Des Moines - East
Lost: 12/1/2017
ID: 7560
Name: Newnew
Type: Cat
Color: Yellow orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Last seen Saturday morning. He’s an indoor outdoor cat, very friendly will let you pet and hold him. Responds to the name newnew.
Clive
Lost: 12/1/2017
ID: 7546
Name: Waylon
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
HE WAS FOUND. THANK YOU!!
Clive
Lost: 12/1/2017
ID: 7545
Name: Waylon
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
NW 97th Street and Lincoln in Clive. He is on seizures medications daily.
Grimes
Lost: 11/30/2017
ID: 7540
Name: Georgie
Type: Cat
Color: Grey and white striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
7:20 am. He is an indoor cat and skiddish. He snuck out when our 6 yr old left the door open this morning. We didn't know until this afternoon.
Bellevue
Lost: 11/29/2017
ID: 7581
Name: Reba
Type: Dog
Color: Red and White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen Nort of the Bellevue Golf Course. Extremely Timid
Bellevue
Lost: 11/29/2017
ID: 7580
Name: Reba
Type: Dog
Color: Red and White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen Nort of the Bellevue Golf Course. Extremely Timid
Bellevue
Lost: 11/29/2017
ID: 7579
Name: Reba
Type: Dog
Color: Red and White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen Nort of the Bellevue Golf Course. Extremely Timid
Bellevue
Lost: 11/29/2017
ID: 7578
Name: Reba
Type: Dog
Color: Red and White
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen north of the golf course in Bellevue Iowa
Bellevue
Lost: 11/29/2017
ID: 7577
Name: Reba
Type: Dog
Color: Red and White
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen north of the golf course in Bellevue Iowa
Bellevue
Lost: 11/29/2017
ID: 7549
Name: Reba
Type: Dog
Color: Red & White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen 1/4 mile north of the Bellevue Golf Club entrance 11/30/17 at 1am head north Mini Aussie - Extremely Timid
Bellevue
Lost: 11/29/2017
ID: 7548
Name: Reba
Type: Dog
Color: Red & White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen 1/4 mile north of the Bellevue Golf Club entrance 11/30/17 at 1am head north Mini Aussie - Extremely Timid
Urbandale
Lost: 11/29/2017
ID: 7536
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 11/29/2017
ID: 7529
Name: Cooper
Type: Dog
Color: Black/tan
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near 21st and maple
Waterloo
Lost: 11/28/2017
ID: 7539
Name: Rae
Type: Cat
Color: Yellow
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 11 pm on the 28th. She is extremely nice and loves the sound of food in a dish being shook, laser pointers, and the sound of a toy with a bell in it. She should have a collar indent around her neck. She is 6mo and is not declawed.
Urbandale
Lost: 11/28/2017
ID: 7532
Name: Scully
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Our much-loved cat is about 2 years old, all black except for a few white hairs on his chest/belly,is declawed in front, has a kink at the end of his tail, and very friendly and curious. We are missing him terribly!
Norwalk
Lost: 11/27/2017
ID: 7517
Name: Saki
Type: Cat
Color: Grey and white. Very soft and short hair
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Cherry Parkway
Cedar Rapids
Lost: 11/27/2017
ID: 7516
Name: Dera
Type: Dog
Color: Light brown
Breed: Pinscher-Miniature
Gender: Female
Fixed: Not Applicable
Age: Adult
She has terrible separation anxiety when she's not around me.