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
Davenport
Lost: 11/25/2017
ID: 7489
Name: Jack
Type: Dog
Color: Silver/ tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Last seen forest and elm st in east Davenport.
Ankeny
Lost: 11/25/2017
ID: 7483
Name: Copper
Type: Dog
Color: Black and white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - West
Lost: 11/24/2017
ID: 7490
Name: Felix
Type: Cat
Color: Black and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Westover/Urbandale Avenue/Hickman Road Super friendly Overweight! Needs to eat More white than black
Des Moines - North
Lost: 11/24/2017
ID: 7480
Name: Hubey
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
11/24/17 @ night
Urbandale
Lost: 11/24/2017
ID: 7477
Name: Nova
Type: Dog
Color: White
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Neutered
Age: Young
Last Seen in Urbdandale on 62nd street. She's so sweet, very scared of people, I recommend getting down low and try to get her to come to you, say "here sweet baby novy" She's gotta be cold, Please Call me if you see anything you think might be her. 5158658214
Urbandale
Lost: 11/24/2017
ID: 7474
Name: Nova
Type: Dog
Color: White
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Young
Last seen on 66th street in Urbandale. (Off Meredith and Aurora) She is such a lover but can be very timid and gets scared very easily. To approach her, get down real low. No sudden movements and definitely don’t chase her... she will run off. Thanks in advance for looking. We miss her so much.
Ankeny
Lost: 11/24/2017
ID: 7473
Name:
Type: Cat
Color: Black & White
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 11/24/2017
ID: 7472
Name: Kitty
Type: Cat
Color: Black & White
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
He got out of the screen door when it blew open. I’m the White Birch area.
Des Moines - Central
Lost: 11/24/2017
ID: 7466
Name: Macy
Type: Cat
Color: White with grey
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She got out of my house in the woodland/ drake neighborhood. She very shy and skiddish but if you call her she might come up to you. Very sweet as well. Declawed Front paws. She is white body with 4 big grey patches on her back/ on either side of her spine grey tail and grey little mask on her face
Des Moines - South
Lost: 11/23/2017
ID: 7463
Name: Shadow
Type: Dog
Color: White
Breed: Havanese
Gender: Male
Fixed: Neutered
Age: Young
Wesring a blue and white sweater with green lettering that says #1 Spoiled
Pella
Lost: 11/22/2017
ID: 7681
Name: Unknown
Type: Cat
Color: Brown, caramel and black
Breed: Havanese
Gender: Unknown
Fixed: Unknown
Age: Adult
Cat has been hanging around Pella Ia on hwy t17, clearly a pet and not a feral cat. Meowing at the door for days.
Griswold
Lost: 11/22/2017
ID: 7503
Name: Mis
Type: Dog
Color: Black tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
She was with our other dog. He is here she is not. If someone has her we just want her back. She is s family member
Altoona
Lost: 11/22/2017
ID: 7478
Name: Sassy
Type: Cat
Color: Black, grey and kinda white
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Escaped through back door. She has abnormal paws, extra of toes. Long whiskers.
Des Moines - North
Lost: 11/22/2017
ID: 7453
Name: Marly
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Female
Fixed: Unknown
Age: Young
Got out of the yard at the North Union Douglas Area
Des Moines - East
Lost: 11/22/2017
ID: 7451
Name: Lola
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Senior
Last seen 39th and Madison in Beaverdale. 13 years old and is very sick.
West Des Moines
Lost: 11/21/2017
ID: 7533
Name: Mel
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
May be more responsive to Melanie Gibson if called.
Grimes
Lost: 11/21/2017
ID: 7461
Name: Jazmine
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
Jazmine has a white patch on her chest and an underground fence color on.
Grimes
Lost: 11/21/2017
ID: 7460
Name: Jazmine
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
Jazmine has a white patch on her chest and an underground fence color on.
Des Moines - West
Lost: 11/21/2017
ID: 7447
Name: Pippin
Type: Dog
Color: Black and White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Senior
Last seen the evening of 11/21/17. He was just diagnosed with an intestine problem and needs his meds.
Clive
Lost: 11/21/2017
ID: 7445
Name: Mel
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Last seen at the PetSMart in Clive off University.
Waukee
Lost: 11/21/2017
ID: 7443
Name: Mimi
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
last seen in SE Glendale Drive, Waukee
Des Moines - East
Lost: 11/21/2017
ID: 7438
Name: Trig
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
On E 46th by the Des Moines complex ball fields
Des Moines - Central
Lost: 11/20/2017
ID: 7449
Name: JINX
Type: Cat
Color: Calico- long hair
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
beaverdale area
Dubuque
Lost: 11/20/2017
ID: 7441
Name: Dodat
Type: Dog
Color: white grey
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 11/20/2017
ID: 7433
Name: Dewey
Type: Dog
Color: White/Black
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Adult