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
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.
Windsor Heights
Lost: 11/27/2017
ID: 7506
Name:
Type: Cat
Color: Tuxedo...black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Winterset
Lost: 11/26/2017
ID: 7519
Name: Jay Jay
Type: Cat
Color: Black
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Young
Lost on Sunday, November 26th on the corner of 195th Street and Ironwood Trail of Winterset, IA. One all black cat with yellow eyes, and one dark Siamese with bright blue eyes wearing a white flea collar. Both half grown, super friendly and recently had front paws declawed and both neutered. Could possibly still be together but it is unknown. If found please call: (515) 371-9230 or (515) 321-8032
Norwalk
Lost: 11/26/2017
ID: 7509
Name: Lyla
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
In Lakewood area. She has a crooked tail and is missing a toe on one front paw
Des Moines - South
Lost: 11/26/2017
ID: 7495
Name: Zeus
Type: Cat
Color: Black/white tabby color
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Notices our window was open and the screen as broke. He must have jumped out. Close to South Union and Park.
Urbandale
Lost: 11/26/2017
ID: 7492
Name: Maisie
Type: Cat
Color: Black, gray with blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Holcomb Circle near Westover and Hickman
Urbandale
Lost: 11/26/2017
ID: 7491
Name: Maisie
Type: Cat
Color: Black, gray with blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on Holcomb Circle off Westover and Hickman
Ankeny
Lost: 11/25/2017
ID: 7559
Name:
Type: Cat
Color: Orange with White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Our cat was last seen on Saturday Nov. 25th. We live in the Saylorville Lake Area. He has no collar or microchip. He is very friendly and may have wandered into a shed or garage. If you have seen him please call 515-975-9365.
Ankeny
Lost: 11/25/2017
ID: 7502
Name:
Type: Cat
Color: Orange with White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I am lost and would like to get home. I have no collar. I am friendly and may wander into a garage or shed. My family misses me. Please help me get home. Call 515-975-9365
Des Moines - North
Lost: 11/25/2017
ID: 7494
Name: Ducky
Type: Dog
Color: Black with small amount of white
Breed: Cockapoo
Gender: Male
Fixed: Neutered
Age: Young
Highland park neighborhood between 9th and 10th on Douglas. Let Ducky out in a fenced in yard less than 5min went back to get him and he was gone. Both gates still closed. Please help find him!! He is a comfort dog for a disabled man!!!