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
Harpers Ferry
Lost: 11/4/2018
ID: 9927
Name: Polly
Type: Dog
Color: Reddish brown
Breed: GoldenDoodle
Gender: Female
Fixed: Not Applicable
Age: Baby
We are just visiting and staying at a cabin in the woods. Buck Lane, 52146. The neighbor is Deer Tracks
Urbandale
Lost: 11/3/2018
ID: 9964
Name: Keta
Type: Cat
Color: Black with white and calico spots
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She’s very friendly and sweet!
Des Moines - East
Lost: 11/3/2018
ID: 9925
Name: Unknown
Type: Cat
Color: Multi
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Third time our family has seen him in the neighborhood E.25t and Boyd
Des Moines - South
Lost: 11/3/2018
ID: 9923
Name: Gato
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
40th Street around Park Ave
Ankeny
Lost: 11/2/2018
ID: 10004
Name: Yondu
Type: Cat
Color: Black with a little bit of white on the belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen SE Grant St in Ankeny Iowa. $100.00 reward for a SAFE and UNHARMED return (does not include if have to pick up from a shelter) We are really missing him.
Ankeny
Lost: 11/2/2018
ID: 9936
Name: Yondu
Type: Cat
Color: Black with only white on the belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
SE Grant St, Ankeny, Iowa
Des Moines - South
Lost: 11/2/2018
ID: 9929
Name: Katniss
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Sw 14th st
Thayer
Lost: 11/2/2018
ID: 9918
Name: Ace
Type: Dog
Color: Grey
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
Ace was last home on our farm South of Thayer, Iowa on Friday November 2. Please help us bring our baby home!
Des Moines - South
Lost: 11/2/2018
ID: 9914
Name: fez
Type: Dog
Color: Black and white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Sw 12th and Park
West Des Moines
Lost: 11/1/2018
ID: 9938
Name: Cocoa
Type: Cat
Color: Black orange tan
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Senior
She is not kind to strangers, untrusting of people she does not know. Do not attempt to pick her up or she may attack your face. If spotted please contact me.
West Des Moines
Lost: 11/1/2018
ID: 9937
Name: Cocoa
Type: Cat
Color: Black orange tan mix
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Senior
Escaped out the door Thursday night and she has not been seen since
Newell
Lost: 11/1/2018
ID: 9915
Name: scraps
Type: Dog
Color: white with brown patches
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen on our family farm on hwy 7 near newell iowa
Madrid
Lost: 11/1/2018
ID: 9909
Name: Biscuits
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Got out while moving from s Kennedy Ave
Des Moines - South
Lost: 10/31/2018
ID: 9917
Name: Diamond
Type: Cat
Color: Black, gold, a little white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She will respond to her name she doesn't like water or the cold she's an indoor cat... She is my service animal
Runnells
Lost: 10/31/2018
ID: 9901
Name: LULU
Type: Dog
Color: Dark Brown
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Adult
155 se Garrett Dr Very shy probably will run or hide from people.
Des Moines - North
Lost: 10/31/2018
ID: 9894
Name: Solomen
Type: Dog
Color: Red
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Jumped our fence. Around Morton and north union
Des Moines - North
Lost: 10/30/2018
ID: 9892
Name: Unknown
Type: Dog
Color: One is brindle and one is black with brown spots
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Very friendly
Randall
Lost: 10/30/2018
ID: 9884
Name: Moose
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen in Randall, IA running around with her sister a 2 year old yellow lab
Randall
Lost: 10/30/2018
ID: 9883
Name: Buckshot
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Randall, IA. Running around with my other dog. A 4 month old black lab
Des Moines - Central
Lost: 10/29/2018
ID: 10254
Name: Maui
Type: Cat
Color: Tabby mixed with bengal
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
In the highland oak park area if you see her please contact us right away anytime day or night
Des Moines - Central
Lost: 10/29/2018
ID: 10243
Name: Maui
Type: Cat
Color: Orange,tan, brown
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She is around the highland/oak park area
Des Moines - Central
Lost: 10/29/2018
ID: 10222
Name: Maui
Type: Cat
Color: Orange mixed with tabby
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
Last seen on E11th hoffman and between E8th Seneca if seen please contact us right away! There is a reward 515-318-1974
Des Moines - Central
Lost: 10/29/2018
ID: 10212
Name: Maui
Type: Cat
Color: Bengal mixed with tabby
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on E11th Hoffman and E8th in Seneca please if you find her or have her please let me know contact me right away
Des Moines - Central
Lost: 10/29/2018
ID: 10201
Name: Maui
Type: Cat
Color: Light orange and tan
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on E11th behind Madison elementary school there is a reward if anyone can find her! Please help us bring our baby home
Des Moines - Central
Lost: 10/29/2018
ID: 10189
Name: Maui
Type: Cat
Color: Bengal mixed with tabby
Breed: Bengal
Gender: Female
Fixed: Unknown
Age: Baby
She was last seen on between east 11th and east 10th behind Madison elementary.. if you see her please contact me right away she been missing for over a month now. 515-318-1974