Address: 47 North Broadway, P.O. Box 421, Pelican Rapids, MN 56572 • Toll Free: (800) 530-2986 • Fax: (218) 863-5938 • Email: seifert@loretel.net
FEATURED LISTINGS

placeholder
Vergas

placeholder
Pelican Rapids

placeholder
Other

Hot Sheet

SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataA` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataB` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, '' as C_LIST_48 FROM `dataC` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataE` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataF` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, '' as C_LIST_48 FROM `dataI` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataM` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' ORDER BY length(C_LIST_22),C_LIST_22 LIMIT 0 , 10 SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataA` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataB` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, '' as C_LIST_48 FROM `dataC` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataE` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataF` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, '' as 'C_LIST_66', '' as 'C_LIST_67', C_LIST_39, C_LIST_43, '' as C_LIST_48 FROM `dataI` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00' UNION SELECT C_LIST_1 as 'C_LIST_1',C_LIST_8 as 'C_LIST_8', C_LIST_22 as 'C_LIST_22', C_LIST_105, C_LIST_66 as 'C_LIST_66', C_LIST_67 as 'C_LIST_67', C_LIST_39, C_LIST_43, C_LIST_48 FROM `dataM` WHERE C_LIST_87 >= '2013-05-22T17:29:00-05:00'
3 listings were found, showing 0-3
Photo List # List Price CityBedsBaths Sqr Foot Lot Size
93-418 $114,900 Frazee (56544) 3 3.00 3100.00
31-413 $179,900 Hawley (56549) 3 3.00 2228.00
22-56428 $435,000 Frazee (56544) 3 2.00 1393.00
3 listings were found, showing 0-3