Skip to content
Reset Filters
Debug Info (admin only)

Search Criteria:

  • Keyword: None
  • Categories: None
  • Search Terms: None
  • Types: None
  • Show Unpublished: Yes
  • Sort: opening_hours
  • 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.opening_hours ASC LIMIT 0, 25
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
ChIJfyHbEFArv1QRG13kh-yFhxM Bowlby Park 1767 SW Parkway Dr, Redmond, OR 97756, USA 44.2703320 -121.1883020 1,173 m parks establishment,park,point_of_interest Page | Maps | Website (541) 923-7710
View Photos (1)
Place photo
ChIJWW_oVLfdvlQRui_hg2lwa6E Jericho Lane Farmhouse 3999-3301 SW Jericho Ln, Culver, OR 97734, USA 44.5020890 -121.1969430 25,581 m tourist attraction establishment,point_of_interest,tourist_attraction Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJfZnhGwDVuFQRzoUj_Sgn8sw Sisters Coffee Shop 2522 Jesse Butler Cir, Redmond, OR 97756, USA 44.2530530 -121.1606580 2,419 m coffee shops cafe,establishment,food,point_of_interest,store Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJWxf_mwgzuVQRL8IUb7lq_UU Barnes Butte Reservoir Barnes Butte Reservoir, Oregon 97754, USA 44.3298420 -120.8248990 28,495 m mountain biking establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
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
ChIJG5tRukUrv1QRwbY0v29hceE Creations From the Heart/Longarming,Gifts appointment only, 2148 NW 11th St, Redmond, OR 97756, USA 44.2961200 -121.1799430 2,657 m gift shops establishment,point_of_interest Page | Maps (541) 788-1295
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJGdwamhTbvlQRVFEQso-g-3w Haystack Reservoir Campground Prineville, OR 97754, USA 44.4891930 -121.1507060 24,152 m campgrounds campground,establishment,lodging,park,point_of_interest Page | Maps | Website (208) 270-0094
View Photos (4)
Place photoPlace photoPlace photoPlace photo
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
ChIJxQLW4qcmuVQR21i6am9TyU8 Chimney Rock Campground Chimney Rock Campground, Crooked River Hwy, Prineville, OR 97754, USA 44.1375110 -120.8162650 32,225 m campgrounds campground,establishment,lodging,park,point_of_interest Page | Maps | Website (541) 416-6700
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJxRgmxNwqv1QRAvW1K4af86I City Center Motel 350 NW 6th St, Redmond, OR 97756, USA 44.2788810 -121.1739190 696 m hotels establishment,lodging,point_of_interest Page | Maps (541) 548-3447
View Photos (4)
Place photoPlace photoPlace photoPlace photo
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
ChIJh_C1tYXWvlQRE8jo4FVQJf8 Smith Rock Bivouac Area (The Bivy) (edited) Terrebonne, OR 97760, USA (edited) 44.3608420 -121.1410040 10,153 m recreation,outdoors,rv-parks-camping (edited) camping,rock climbing,state park (edited) campground,lodging,park,point_of_interest,establishment (edited) Page | Maps | Website (edited) (541) 548-7501
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJy0D6fH4rv1QRGnOfHmBix98 Smith Rock BMX 1935 NE Maple Ave, Redmond, OR 97756, USA 44.2912600 -121.1455990 3,062 m mountain biking establishment,point_of_interest Page | Maps | Website (541) 316-0005
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJacNUik48v1QRogv1QRP2AXs Black Butte Black Butte, Oregon 97730, USA 44.3995610 -121.6344960 39,256 m outdoors hiking, point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJOdxKoGzbvlQRFakpdx8wuMU Haystack Reservoir Haystack Reservoir, Oregon 97734, USA 44.4943170 -121.1481090 24,737 m outdoors hiking, point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ2Z5ETSGvuFQRBJrDIKwKQi4 Mount Bachelor Mount Bachelor, Oregon 97703, USA 43.9791670 -121.6886110 52,463 m outdoors hiking, point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
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
ChIJo3Pt7_IVv1QRGvAy6B6lC78 Suttle Lake Suttle Lake, Oregon 97759, USA 44.4250720 -121.7329210 47,572 m outdoors hiking, point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJNX5fYxSzuFQRM0FghCexq_o Three Creek Lake Three Creek Lake, Oregon 97703, USA 44.0990330 -121.6272880 40,980 m outdoors hiking, point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJP81I0g6xuFQRDzFmHl2j-yU Tumalo Falls Tumalo Falls, Oregon 97703, USA 44.0339560 -121.5668790 41,074 m outdoors point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJYW3hHADXvlQRXuymABvPYeY The Zoo Climbing 9VJP+JQ, Terrebonne, OR 97760, USA 44.3815400 -121.1130800 13,042 m rock climbing establishment,point_of_interest Page | Maps
View Photos (3)
Place photoPlace photoPlace photo
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
ChIJs9KxmVNov1QRuP5g446ZuzU Clear Lake Clear Lake, Oregon 97759, USA 44.3686930 -121.9943910 66,139 m outdoors point-of-interest establishment,natural_feature Page | Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJWUtgagQPx1QRh17ukFOxTC8 Crescent Lake Crescent Lake, Oregon 97733, USA 43.4747940 -121.9854810 110,008 m outdoors point-of-interest establishment,natural_feature Page | Maps
View Photos (3)
Place photoPlace photoPlace photo