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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
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: 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
Des Moines - Central
Lost: 10/29/2018
ID: 10157
Name: Maui
Type: Cat
Color: Bengal mixed with tabby
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on 10th over by Madison elementary school hanging around with a black cat with a white face
Des Moines - Central
Lost: 10/29/2018
ID: 10151
Name: Maui
Type: Cat
Color: Bengal mix
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
Someone told us she is hanging around 10th st off Madison behind Madison school over by Aldis if you are in that area please keep an eye out we just want her home
Des Moines - Central
Lost: 10/29/2018
ID: 10116
Name: Maui
Type: Cat
Color: Bengal mixed with tabby
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
Last seen on 10/29/18 13th Madison Some are saying they have seen her on Cambridge and Cornell off madison
Des Moines - Central
Lost: 10/29/2018
ID: 10086
Name: Maui
Type: Cat
Color: Light colored tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
Last seen on 13th Madison but some are saying she over by cambridge and cornell off Madison
Des Moines - Central
Lost: 10/29/2018
ID: 10059
Name: Maui
Type: Cat
Color: Light colored tabby with stripes and patches
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
She was lost on 13th Madison but some are saying that they have seen her by Cambridge and Cornell off Madison but I haven’t seen her
Des Moines - Central
Lost: 10/29/2018
ID: 10027
Name: Maui
Type: Cat
Color: Light colored tabby mix with bengal
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
Last seen on 13th Madison on 10/29/18 she is a light colored tabby mixed with bengal she may appear to be skiddish but will not harm you. Please help us find her we miss her so much
Des Moines - Central
Lost: 10/29/2018
ID: 9968
Name: Maui
Type: Cat
Color: Bengal/tabby
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Last seen on 13th Madison she is a tame cat but she runs from people she does not know if you find her please contact us and we will come and get her
Humboldt
Lost: 10/29/2018
ID: 9963
Name: Jojo french vinilla
Type: Cat
Color: Brown with wite under chin
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - Central
Lost: 10/29/2018
ID: 9939
Name: Maui
Type: Cat
Color: Bengal
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on 13th and Madison she is a senior cat who has cancer THERE IS A REWARD
Des Moines - Central
Lost: 10/29/2018
ID: 9896
Name: Maui
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Senior
Was last seen by Madison Ave on 13th street.. let her out to go potty and she never came back
Waukee
Lost: 10/29/2018
ID: 9891
Name: Walter “Nuggy”
Type: Cat
Color: Black w/white patch on chest
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Senior
Not an outdoor cat. Declawed. Top part of left ear froze off when he was a kitten. Has bald spots on belly and hind legs. Goes by the nickname Nuggy.
Des Moines - North
Lost: 10/29/2018
ID: 9887
Name: Maui
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
She was seen on the north side of desmoines on Madison street
Ankeny
Lost: 10/28/2018
ID: 9946
Name: Tiger Cat
Type: Cat
Color: Dark Brown/Black striped with white feet.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is front declawed. He only has a few back claws remaining, from a previous accident. He is 3 years old.
Des Moines - South
Lost: 10/28/2018
ID: 9893
Name: Mellow
Type: Dog
Color: Brown/Black (brindle) & White
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
Mellow was wearing a hot pink collar and was last seen October 28th around 1pm on Army Post Road & SE 3rd Streets.
Collins
Lost: 10/28/2018
ID: 9882
Name: Rupert
Type: Dog
Color: Black with white with small amount of brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Collins Iowa near Hwy 65 and 330th St. Rupert can be skittish and shy but is very friendly and loving. He knows his name. If you see or find Rup please call or text me at 515-661-3974.
Des Moines - North
Lost: 10/27/2018
ID: 9934
Name: Blue
Type: Cat
Color: Grey
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
We rescued him this summer at Union Park from a car of homeless people. He has a deformed nose but is overall healthy He would explore our yard but this time never returned. He is my 4 year olds baby so please help us get him back. May be infested with fleas. He received a treatment that day. He is very quiet and loving.