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

Search Criteria:

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

Pagination:

  • Current Page: 18
  • Limit per Page: 25
  • Offset: 425
  • Total Pages: 27

Results:

  • Total Available Records: 659
  • Total After Limits: 659
  • 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 COALESCE(e.name, p.name) ASC LIMIT 425, 25
Previous Next
Page 18 of 27
Showing 426 to 450 of 659 results
Place ID Name Address Latitude Longitude Distance Category Search Term Types Links Phone Hours Photos
ChIJUWGjFY0qv1QRnZppSKZrHjg Panda Express 455 NW Oak tree Ln, Redmond, OR 97756, USA 44.2943280 -121.1718920 2,419 m dining meal_delivery,meal_takeaway,restaurant,point_of_interest,food,establishment Maps | Website (541) 923-1968
View Hours
  • Monday: 9:30 AM – 10:00 PM
  • Tuesday: 9:30 AM – 10:00 PM
  • Wednesday: 9:30 AM – 10:00 PM
  • Thursday: 9:30 AM – 10:00 PM
  • Friday: 9:30 AM – 11:00 PM
  • Saturday: 9:30 AM – 10:00 PM
  • Sunday: 9:30 AM – 10:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJlaawUQArv1QRkKMYlaUhOHI Pangaea Guild Hall – Coffee and Cocktails 652 SW 6th St, Redmond, OR 97756, USA 44.2707520 -121.1739710 208 m bars, cocktails, coffee shops, family friendly, nightlife cafe,bar,food,point_of_interest,store,establishment Maps | Website (541) 526-7641
View Hours
  • Monday: Closed
  • Tuesday: 7:00 AM – 10:00 PM
  • Wednesday: 7:00 AM – 10:00 PM
  • Thursday: 7:00 AM – 10:00 PM
  • Friday: 7:00 AM – 11:00 PM
  • Saturday: 9:00 AM – 11:00 PM
  • Sunday: 9:00 AM – 10:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJW1npeO0qv1QRcPpmGIWJAVQ Pappy’s Pizzeria 1655 NW 6th St, Redmond, OR 97756, USA 44.2913350 -121.1744830 2,081 m breakfast, family friendly, lunch, restaurants meal_delivery,restaurant,food,point_of_interest,establishment Maps | Website (541) 548-1118
View Hours
  • Monday: 11:00 AM – 11:00 PM
  • Tuesday: 11:00 AM – 11:00 PM
  • Wednesday: 11:00 AM – 11:00 PM
  • Thursday: 11:00 AM – 11:00 PM
  • Friday: 11:00 AM – 11:00 PM
  • Saturday: 11:00 AM – 11:00 PM
  • Sunday: 11:00 AM – 11:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ9_Ctmrsrv1QRLVS7YZi-VNk Parker Eventing 8515 W Antler Ave, Redmond, OR 97756, USA 44.2785900 -121.2740100 7,996 m horseback rides travel_agency,point_of_interest,establishment Maps | Website (541) 771-2031
View Hours
  • Monday: Closed
  • Tuesday: 8:00 AM – 6:00 PM
  • Wednesday: 8:00 AM – 6:00 PM
  • Thursday: 8:00 AM – 6:00 PM
  • Friday: 8:00 AM – 6:00 PM
  • Saturday: 8:00 AM – 6:00 PM
  • Sunday: Closed
 No photos available
ChIJ8fz7agDRvlQRW-nEAPJBwuk Parking for The Zoo 9WX2+WQ, Terrebonne, OR 97760, USA 44.3997850 -121.0980350 15,374 m rock climbing point_of_interest,establishment Maps
View Photos (1)
Place photo
ChIJ6YJIBI0rv1QRZzHEIwbumwA Parking Lot for Playground 401 SW 15th St, Redmond, OR 97756, USA 44.2730740 -121.1844370 839 m parks, playgrounds park,point_of_interest,establishment Maps
View Photos (2)
Place photoPlace photo
ChIJ2duG4fEqv1QRuOdOz8cwD8I Paul Hathaway Memorial Park (edited) 1021 NW Rockcrest Ct, Redmond, OR 97756, USA (edited) 44.2906730 -121.1800210 2,065 m outdoors (edited) parks, point-of-interest (edited) park,point_of_interest,establishment (edited) Maps | Website (edited)
View Hours
  • Monday: 6:30 AM – 9:00 PM
  • Tuesday: 6:30 AM – 9:00 PM
  • Wednesday: 6:30 AM – 9:00 PM
  • Thursday: 7:00 AM – 9:30 PM
  • Friday: 6:30 AM – 9:00 PM
  • Saturday: 6:30 AM – 9:00 PM
  • Sunday: 6:30 AM – 9:00 PM
 No photos available
ChIJ1VfCqzePuFQRm_qLJANFiLU Paulina Lake Hot Spring Little Crater Campground, La Pine, OR 97739, USA 43.7320950 -121.2523330 60,430 m outdoors point-of-interest tourist_attraction,point_of_interest,establishment Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJo_3WpfTuvlQRNlQV7HJh2eU Pelton Park 3300 NW Pelton Dam Rd, Madras, OR 97741, USA 44.6857110 -121.2370490 46,206 m outdoors hiking, point-of-interest park,point_of_interest,establishment Maps | Website (503) 464-8515
View Hours
  • Monday: 7:00 AM – 7:00 PM
  • Tuesday: 7:00 AM – 7:00 PM
  • Wednesday: 7:00 AM – 7:00 PM
  • Thursday: 7:00 AM – 7:00 PM
  • Friday: 7:00 AM – 7:00 PM
  • Saturday: Closed
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJH-2Di44rv1QRcyiyaqpe1xg Penske Truck Rental 3920 US-97, Redmond, OR 97756, USA 44.3114250 -121.1711430 4,321 m car rentals store,point_of_interest,establishment Maps | Website (541) 699-3244
View Hours
  • Monday: 9:00 AM – 5:00 PM
  • Tuesday: 9:00 AM – 5:00 PM
  • Wednesday: 9:00 AM – 5:00 PM
  • Thursday: 9:00 AM – 5:00 PM
  • Friday: 9:00 AM – 5:00 PM
  • Saturday: 9:00 AM – 6:00 PM
  • Sunday: Closed
View Photos (1)
Place photo
ChIJkRycFiUrv1QRgcJ71N6AVa8 Perfect Nails & Spa 905 SW Rimrock Way, Redmond, OR 97756, USA 44.2679520 -121.1933370 1,631 m spas beauty_salon,point_of_interest,establishment Maps (541) 923-8885
View Hours
  • Monday: 9:00 AM – 6:00 PM
  • Tuesday: 9:00 AM – 6:00 PM
  • Wednesday: 9:00 AM – 6:00 PM
  • Thursday: 9:00 AM – 6:00 PM
  • Friday: 9:00 AM – 6:00 PM
  • Saturday: 9:00 AM – 6:00 PM
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJQ53B0SfivlQRCroFzC_DOeA Perry South Campground Montgomery Rd, Culver, OR 97734, USA 44.5848450 -121.4475810 40,958 m campgrounds campground,park,lodging,point_of_interest,establishment Maps | Website (877) 444-6777
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJP0JN4abXvlQRB87qXcM_mOs Peter Skene Ogden State Scenic Viewpoint (edited) US-97, Terrebonne, OR 97760, USA (edited) 44.3912060 -121.1933420 13,276 m outdoors (edited) point of interest,state parks,seasonal (edited) park,point_of_interest,establishment (edited) Maps | Website (edited) (800) 551-6949
View Hours
  • Monday: 8:00 AM – 5:00 PM
  • Tuesday: 8:00 AM – 5:00 PM
  • Wednesday: 8:00 AM – 5:00 PM
  • Thursday: 8:00 AM – 5:00 PM
  • Friday: 8:00 AM – 5:00 PM
  • Saturday: 8:00 AM – 8:00 PM
  • Sunday: 8:00 AM – 8:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJsX15N_LSuFQRyKuyO3eC6NY Petersen Rock Garden & Museum 7930 SW 77th St, Redmond, OR 97756, USA 44.2033160 -121.2622450 10,435 m point of interest, tourist attraction museum,tourist_attraction,point_of_interest,establishment Maps | Website (541) 904-0557
View Hours
  • Monday: Closed
  • Tuesday: Closed
  • Wednesday: 10:00 AM – 4:00 PM
  • Thursday: 10:00 AM – 4:00 PM
  • Friday: 10:00 AM – 4:00 PM
  • Saturday: 10:00 AM – 4:00 PM
  • Sunday: 10:00 AM – 4:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ2xozTDE3v1QR0vZ6lR5wh8o Peterson Ridge Mountain Bike Trails (edited) Three Creek Rd, Sisters, OR 97759 (edited) 44.2807320 -121.5499990 29,954 m outdoors (edited) mountain biking (edited) mountain_biking (edited) Maps | Website (edited)
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
ChIJhw_qYcIqv1QRWH7G1p2L4aE Physical Justice House of Healing 654 NW 4th St, Redmond, OR 97756, USA 44.2818720 -121.1718560 1,042 m massage health,point_of_interest,establishment Maps (541) 280-2535
View Hours
  • Monday: 11:00 AM – 5:00 PM
  • Tuesday: Closed
  • Wednesday: 11:00 AM – 5:00 PM
  • Thursday: 11:00 AM – 3:00 PM
  • Friday: 11:00 AM – 3:00 PM
  • Saturday: Closed
  • Sunday: Closed
View Photos (1)
Place photo
ChIJdZHNgZHWvlQRJFo4t2tn3vE Picnic Lunch Wall Picnic Lunch Wall, Oregon 97760, USA 44.3684170 -121.1397600 10,993 m rock climbing natural_feature,establishment Maps No photos available
ChIJIy3nywTGuFQRnE_rjHPpr8U Pilot Butte Pilot Butte, Bend, OR 97701, USA 44.0606730 -121.2833640 25,132 m outdoors (edited) point of interest (edited) natural_feature,establishment Maps
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ3b8T0ZYrv1QRx88GFPBG6HA Pink Sprinkled Bakery 858 NW Redwood Ave, Redmond, OR 97756, USA 44.3002400 -121.1773270 3,083 m bakeries, desserts bakery,food,point_of_interest,store,establishment Maps | Website (541) 350-7954
View Hours
  • Monday: 8:00 AM – 5:00 PM
  • Tuesday: 8:00 AM – 5:00 PM
  • Wednesday: 8:00 AM – 5:00 PM
  • Thursday: 8:00 AM – 5:00 PM
  • Friday: 8:00 AM – 5:00 PM
  • Saturday: 8:00 AM – 5:00 PM
  • Sunday: 8:00 AM – 5:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ57m4d3wrv1QR2OOtqOYrRWk Playground 850 SW Rimrock Way, Redmond, OR 97756, USA 44.2674800 -121.1908150 1,461 m playgrounds point_of_interest,establishment Maps No photos available
ChIJ9csSlychuVQRhXmYz4C4QRc Poison Butte Campground OR-27, Prineville, OR 97754, USA 44.1204050 -120.7982720 34,399 m campgrounds campground,lodging,park,point_of_interest,establishment Maps | Website (541) 416-6700
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
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJJU90atcqv1QRMyBxik6mN6c PoShens Healing Center 1129 SW 12th St, Redmond, OR 97756, USA 44.2661220 -121.1809960 916 m massage point_of_interest,health,establishment Maps (541) 504-5939 No photos available
ChIJJ1BVuNkqv1QRWc322019HaA Possibilities Thrift Store Redmond 3294 S Hwy 97, Redmond, OR 97756, USA 44.2458090 -121.1885220 3,200 m antiques, thrift stores, vintage point_of_interest,store,establishment Maps | Website (541) 548-5288
View Hours
  • Monday: 9:00 AM – 3:00 PM
  • Tuesday: 9:00 AM – 5:00 PM
  • Wednesday: 9:00 AM – 5:00 PM
  • Thursday: 9:00 AM – 5:00 PM
  • Friday: 9:00 AM – 5:00 PM
  • Saturday: 9:00 AM – 5:00 PM
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJMwqh-f4juVQRppulN5J4yqQ Post Pile Campground OR-27, Prineville, OR 97754, USA 44.1289380 -120.8005150 33,783 m campgrounds campground,lodging,park,point_of_interest,establishment Maps | Website (541) 416-6700
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
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJRY2rOegqv1QRFZ-3n3VLS1E Precious Curves 618 NW Hemlock Ave, Redmond, OR 97756, USA 44.2830840 -121.1747970 1,166 m boutiques, thrift stores clothing_store,store,point_of_interest,establishment Maps (541) 639-2855
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