Skip to content
SEARCH
Reset Filters
Download (CSV)
Debug Info (admin only)

Search Criteria:

  • Keyword: None
  • Categories: None
  • Search Terms: None
  • Types: None
  • Show Unpublished: Yes
  • Sort: photo_urls
  • Order: ASC

Pagination:

  • Current Page: 1
  • Limit per Page: 25
  • Offset: 0
  • Total Pages: 24

Results:

  • Total Available Records: 583
  • Total After Limits: 583
  • Results Loaded: 25

Query:

SELECT p.place_id, COALESCE(NULLIF(e.name, ''), p.name) AS name, IF(e.name IS NOT NULL AND e.name != '', 1, 0) AS has_edit_name, COALESCE(NULLIF(e.address, ''), p.formatted_address) AS formatted_address, IF(e.address IS NOT NULL AND e.address != '', 1, 0) AS has_edit_address, p.lat, p.lng, p.weighted_rating, p.composite_score, p.distance, COALESCE(NULLIF(e.redmond_category, ''), p.redmond_category) AS redmond_category, IF(e.redmond_category IS NOT NULL AND e.redmond_category != '', 1, 0) AS has_edit_redmond_category, COALESCE(NULLIF(e.redmond_search_term, ''), p.redmond_search_term) AS redmond_search_term, IF(e.redmond_search_term IS NOT NULL AND e.redmond_search_term != '', 1, 0) AS has_edit_redmond_search_term, COALESCE(NULLIF(e.types, ''), p.types) AS types, IF(e.types IS NOT NULL AND e.types != '', 1, 0) AS has_edit_types, COALESCE(NULLIF(e.website, ''), p.website) AS website, IF(e.website IS NOT NULL AND e.website != '', 1, 0) AS has_edit_website, COALESCE(NULLIF(e.phone, ''), p.formatted_phone_number) AS formatted_phone_number, IF(e.phone IS NOT NULL AND e.phone != '', 1, 0) AS has_edit_phone, CASE WHEN e.place_id IS NOT NULL THEN 1 ELSE 0 END AS has_edits, e.is_published 
                 FROM wp_redmond_explorer_places p
                 LEFT JOIN wp_redmond_explorer_edits e ON p.place_id = e.place_id
                  WHERE 1=1 ORDER BY p.photo_urls ASC LIMIT 0, 25
Next
Page 1 of 24
Showing 1 to 25 of 583 results
Place ID Name Address Latitude Longitude Distance Category Search Term Types Links Phone Hours Photos ↑
ChIJg-XAvMIqv1QRteJgcoy2g7Y Lee Petmecky Massage 636 NW 6th St c, Redmond, OR 97756, USA 44.2815050 -121.1739190 988 m massage establishment,health,point_of_interest Page | Maps (541) 815-4011 No photos available
ChIJg46ufybVuFQRHqdDNMuhm7Y DAM Creative-Redbubble 2250 SW 21st St, Redmond, OR 97756, USA 44.2557690 -121.1912850 2,329 m boutiques, gift shops art_gallery,clothing_store,establishment,point_of_interest,store Page | Maps | Website
View Hours
  • Monday: Open 24 hours
  • Tuesday: Open 24 hours
  • Wednesday: Open 24 hours
  • Thursday: Open 24 hours
  • Friday: Open 24 hours
  • Saturday: Open 24 hours
  • Sunday: Open 24 hours
 No photos available
ChIJx6U13IYrv1QR0c6oDv0MVwc Antiques & Stuff Redmond Oregon 308 SE Franklin Ave, Redmond, OR 97756, USA 44.2743720 -121.1660550 656 m antiques establishment,point_of_interest Page | Maps (541) 527-4723 No photos available
ChIJGVZ-o2orv1QRGveWJw8yITw Northstar Massage Therapy 716 SW 11th St, Redmond, OR 97756, USA 44.2703030 -121.1793770 505 m massage establishment,point_of_interest Page | Maps | Website (541) 815-0883
View Hours
  • Monday: 10:00 AM – 6:00 PM
  • Tuesday: 10:00 AM – 6:00 PM
  • Wednesday: 10:00 AM – 6:00 PM
  • Thursday: 10:00 AM – 6:00 PM
  • Friday: 10:00 AM – 4:00 PM
  • Saturday: Closed
  • Sunday: Closed
 No photos available
ChIJxXHU_fUpv1QR6XZd-7yQqLg Thordarson Farms Redmond,Oregon Redmond, OR 97756, USA 44.3189160 -121.2698500 9,208 m farms establishment,point_of_interest Page | Maps No photos available
ChIJgyDGagAtv1QRFhCtenVYnqA Cottonwood RV Park 1590 Mountain Quail Dr, Redmond, OR 97756, USA 44.2593690 -121.2624000 7,198 m rv parks campground,establishment,lodging,park,point_of_interest Page | Maps No photos available
ChIJh0op4tkqv1QR5Z29ZGr-Yl4 Cricket On the Hearth 521 SW 6th St #101, Redmond, OR 97756, USA 44.2720370 -121.1746250 86 m gift shops establishment,point_of_interest,store Page | Maps (541) 504-7770
View Hours
  • Monday: 10:00 AM – 5:00 PM
  • Tuesday: 10:00 AM – 5:00 PM
  • Wednesday: 10:00 AM – 5:00 PM
  • Thursday: 10:00 AM – 5:00 PM
  • Friday: 10:00 AM – 5:00 PM
  • Saturday: 10:00 AM – 5:00 PM
  • Sunday: Closed
 No photos available
ChIJYTsBKn8rv1QRuyCqCBMOX9U Coffee Depo Redmond, OR 97756, USA 44.2726660 -121.1739210 5 m coffee shops cafe,establishment,food,point_of_interest,store Page | Maps No photos available
ChIJsaeU5yRYx1QRsk9oajNEs-8 Cascade Lakes Cascade Lakes, Oregon 97413, USA 43.9000000 -121.8000000 64,940 m outdoors point-of-interest establishment,natural_feature Page | Maps No photos available
ChIJHwnt-5Mrv1QRxkdXRegI6HQ Heal Grow Thrive Medicine 635 NW 5th St, Redmond, OR 97756, USA 44.2816740 -121.1735560 1,007 m massage beauty_salon,establishment,health,point_of_interest,spa Page | Maps | Website (541) 639-8911
View Hours
  • Monday: 10:00 AM – 6:00 PM
  • Tuesday: 10:00 AM – 6:00 PM
  • Wednesday: 10:00 AM – 6:00 PM
  • Thursday: 10:00 AM – 6:00 PM
  • Friday: 9:00 AM – 5:00 PM
  • Saturday: Closed
  • Sunday: Closed
 No photos available
ChIJzwnYIZbUuFQRGhhc1VIitt8 Buckaroo Breakfast Management, 3800 SE Airport Way, Redmond, OR 97756, USA 44.2381170 -121.1853420 3,943 m live music establishment,point_of_interest Page | Maps No photos available
ChIJIcsYuMsrv1QR4N1YCgkb4Aw Mickey’s Adventures 422 SW 6th St, Redmond, OR 97756, USA 44.2731790 -121.1739860 62 m bookstores book_store,establishment,point_of_interest,store Page | Maps (206) 228-3155
View Hours
  • Monday: 9:30 AM – 5:00 PM
  • Tuesday: 9:30 AM – 5:00 PM
  • Wednesday: 9:30 AM – 5:00 PM
  • Thursday: 9:30 AM – 5:00 PM
  • Friday: 9:30 AM – 5:00 PM
  • Saturday: Closed
  • Sunday: Closed
 No photos available
ChIJ216Xg87UuFQRPim-k47dpok Latrontera Mini Market Redmond, OR 97756, USA 44.2542310 -121.1820710 2,145 m juice bars establishment,food,grocery_or_supermarket,point_of_interest,store Page | Maps No photos available
ChIJ4agFB04rv1QR7F1pEK5Ffoo Tite Knot Craft Coffee – Central Bakery 950 SW Veterans Way, Redmond, OR 97756, USA 44.2674300 -121.1790250 706 m coffee shops cafe,establishment,food,point_of_interest,store Page | Maps | Website (541) 527-1353
View Hours
  • Monday: 6:00 AM – 1:00 PM
  • Tuesday: 6:00 AM – 1:00 PM
  • Wednesday: 6:00 AM – 1:00 PM
  • Thursday: 6:00 AM – 1:00 PM
  • Friday: 6:00 AM – 1:00 PM
  • Saturday: 7:00 AM – 1:00 PM
  • Sunday: 7:00 AM – 1:00 PM
 No photos available
ChIJiU_zE1jVuFQRcZUjv7OPL88 Three Sisters Conference Center 3800 SE Airport Way, Redmond, OR 97756, USA 44.2375890 -121.1853060 3,999 m event venues establishment,point_of_interest Page | Maps | Website (541) 585-1569 No photos available
ChIJDz5Oe1PSuFQR3uLNHilffL8 Deschutes Hop Farm 8451 S Hwy 97, Redmond, OR 97756, USA 44.1984020 -121.2324860 9,480 m farms establishment,point_of_interest Page | Maps (541) 525-5898
View Hours
  • Monday: 9:00 AM – 7:00 PM
  • Tuesday: 9:00 AM – 7:00 PM
  • Wednesday: 9:00 AM – 7:00 PM
  • Thursday: Open 24 hours
  • Friday: Open 24 hours
  • Saturday: Open 24 hours
  • Sunday: 9:00 AM – 7:00 PM
 No photos available
ChIJh3fAPiYrv1QRgGDwfzWKMWE Westside One Stop 1501 SW Highland Ave, Redmond, OR 97756, USA 44.2698350 -121.1852880 957 m desserts, juice bars convenience_store,establishment,food,gas_station,point_of_interest,store Page | Maps (541) 923-8881
View Hours
  • Monday: 6:00 AM – 10:00 PM
  • Tuesday: 6:00 AM – 10:00 PM
  • Wednesday: 6:00 AM – 10:00 PM
  • Thursday: 6:00 AM – 10:00 PM
  • Friday: 6:00 AM – 11:00 PM
  • Saturday: 6:00 AM – 11:00 PM
  • Sunday: 6:00 AM – 10:00 PM
 No photos available
ChIJJel20Skrv1QRrn0MaqlJ9aA Towne Center 101 SW Indian Ave, Redmond, OR 97756, USA 44.2679930 -121.1780970 613 m shopping establishment,point_of_interest,shopping_mall Page | Maps No photos available
ChIJMfJSB_0rv1QR2XGtF_6DoLs Goody’s Ice Cream Food Cart @ General Duffy’s Waterhole, 404 SW Forest Ave, Redmond, OR 97756, USA 44.2714210 -121.1723200 185 m desserts establishment,food,point_of_interest,store Page | Maps | Website (541) 385-7085
View Hours
  • Monday: 3:30 – 8:00 PM
  • Tuesday: 3:30 – 8:00 PM
  • Wednesday: 3:30 – 8:00 PM
  • Thursday: 3:30 – 8:00 PM
  • Friday: 3:30 – 8:00 PM
  • Saturday: 12:30 – 8:00 PM
  • Sunday: 12:30 – 8:00 PM
 No photos available
ChIJjQX4oygrv1QRPwXQ5ZoVmAw Anderson Julie 654 NW 4th St, Redmond, OR 97756, USA 44.2818720 -121.1718560 1,042 m massage establishment,point_of_interest Page | Maps (541) 280-2535 No photos available
ChIJPUYKk0Irv1QRtWELCVJwXJk Front Porch Bakery 1818 NW Ivy Ave, Redmond, OR 97756, USA 44.2852110 -121.1881860 1,803 m bakeries bakery,establishment,food,point_of_interest,store Page | Maps No photos available
ChIJr065mvrXvlQRnfwIkPJ3Pe0 Odin Falls Alpacas 9101 NW 31st St, Terrebonne, OR 97760, USA 44.3588330 -121.2052690 9,906 m farms establishment,point_of_interest Page | Maps | Website
View Hours
  • Monday: 9:00 AM – 4:00 PM
  • Tuesday: 9:00 AM – 4:00 PM
  • Wednesday: 9:00 AM – 4:00 PM
  • Thursday: 9:00 AM – 4:00 PM
  • Friday: 9:00 AM – 4:00 PM
  • Saturday: 9:00 AM – 4:00 PM
  • Sunday: 9:00 AM – 4:00 PM
 No photos available
ChIJR71vGUfVuFQRxfoI_oXTxkk Cassity’s Bar 2498 S Hwy 97, Redmond, OR 97756, USA 44.2525650 -121.1830280 2,345 m nightlife, pubs bar,establishment,point_of_interest Page | Maps | Website No photos available
ChIJ_QttG9sqv1QRlMOKu0qCRnQ Human Touch Massage Center 341 SW Black Butte Blvd, Redmond, OR 97756, USA 44.2756950 -121.1718830 378 m massage establishment,health,point_of_interest Page | Maps (541) 923-9708 No photos available
ChIJVVWxKksrv1QRks360QBDPPg Prescott Honey 2668 SW Salmon Ave, Redmond, OR 97756, USA 44.2544860 -121.1988540 2,830 m farms establishment,point_of_interest Page | Maps | Website (541) 977-8848 No photos available