Skip to content
Reset Filters
Debug Info (admin only)

Search Criteria:

  • Keyword: None
  • Categories: None
  • Search Terms: None
  • Types: None
  • Show Unpublished: Yes
  • Sort: place_id
  • Order: DESC

Pagination:

  • Current Page: 2
  • Limit per Page: 25
  • Offset: 25
  • 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.place_id DESC LIMIT 25, 25
Page 2 of 24
Showing 26 to 50 of 583 results
Place ID Name Address Latitude Longitude Distance Category Search Term Types Links Phone Hours Photos
ChIJyR2EdNoqv1QRRsZZ3yPCE4s Beyond the Ranch Antiques 339 SW Evergreen Ave, Redmond, OR 97756, USA 44.2727870 -121.1718870 163 m antiques, gift shops, shopping, thrift stores, vintage clothing_store,establishment,home_goods_store,point_of_interest,shoe_store,store Page | Maps (541) 279-4867
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: 12:00 – 5:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJYfRBprTZvlQRzJOpZP1z9-M Mom’s Kitchen Catering Co. 528 SW 6th St, Redmond, OR 97756, USA 44.2720480 -121.1740020 64 m desserts establishment,food,point_of_interest Page | Maps | Website (541) 213-9696
View Hours
  • Monday: 11:00 AM – 9:00 PM
  • Tuesday: 11:00 AM – 9:00 PM
  • Wednesday: 11:00 AM – 9:00 PM
  • Thursday: 11:00 AM – 9:00 PM
  • Friday: 11:00 AM – 9:00 PM
  • Saturday: 11:00 AM – 9:00 PM
  • Sunday: 11:00 AM – 9:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJYbd4bq4muVQRx-ZgTg9MOv8 Palisades Campground Palisades Campground, Crooked River Hwy, Prineville, OR 97754, USA 44.1315820 -120.8221660 32,127 m campgrounds campground,establishment,lodging,park,point_of_interest Page | 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
ChIJYaI95M4rv1QRyBBptKy5p9A Two Gifty Girls 433 SW 6th St, Redmond, OR 97756, USA 44.2730350 -121.1745290 67 m boutiques, gift shops clothing_store,establishment,food,grocery_or_supermarket,home_goods_store,point_of_interest,store Page | Maps | Website (541) 516-1955
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: 11:00 AM – 4:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJY7x3pWcrv1QRH7zW0Ps6WwM Provisions Market at SCP Redmond 521 SW 6th St, Redmond, OR 97756, USA 44.2722780 -121.1745490 63 m bakeries, breakfast, coffee shops cafe,establishment,food,point_of_interest,restaurant,store Page | Maps | Website (541) 508-7600
View Hours
  • Monday: 7:00 AM – 2:00 PM
  • Tuesday: 7:00 AM – 2:00 PM
  • Wednesday: 7:00 AM – 2:00 PM
  • Thursday: 7:00 AM – 2:00 PM
  • Friday: 7:00 AM – 2:00 PM
  • Saturday: 7:00 AM – 2:00 PM
  • Sunday: 7:00 AM – 2:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJY4EDyf0rv1QRfao4lObgIRw Centennial Park 446 SW 9th St, Redmond, OR 97756, USA 44.2728110 -121.1772400 265 m farmers markets, parks establishment,park,point_of_interest Page | Maps | Website
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 – 6:00 PM
  • Saturday: 10:00 AM – 6:00 PM
  • Sunday: 10:00 AM – 6:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJy1RrCtcqv1QRJcCTGwZQXzI Aziz Crew Barber Shop 2498 S Hwy 97 Suit C, Redmond, OR 97756, USA 44.2525650 -121.1830280 2,345 m pool tables establishment,hair_care,health,point_of_interest Page | Maps | Website (541) 668-3397
View Hours
  • Monday: Closed
  • 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 – 6:00 PM
  • Saturday: 10:00 AM – 2:00 PM
  • Sunday: Closed
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
ChIJY-h15QLTuFQRnmWKhW1y2KM Well Rooted Farms – Redmond Farm Stand 4700 SW 43rd St, Redmond, OR 97756, USA 44.2317990 -121.2190520 5,790 m farms establishment,food,point_of_interest,store Page | Maps | Website (458) 202-9968
View Hours
  • Monday: 7:00 AM – 8:00 PM
  • Tuesday: 7:00 AM – 8:00 PM
  • Wednesday: 7:00 AM – 8:00 PM
  • Thursday: 7:00 AM – 8:00 PM
  • Friday: 7:00 AM – 8:00 PM
  • Saturday: 7:00 AM – 8:00 PM
  • Sunday: 7:00 AM – 8:00 PM
View Photos (1)
Place photo
ChIJxYoUXJUqv1QR2h-mzXNFo5w Gompers Distillery and Speakeasy 611 NE Jackpine Ct #8, Redmond, OR 97756, USA 44.2861270 -121.1627710 1,745 m bars, brewery, cocktails, distillery, farmers markets, nightlife bar,establishment,point_of_interest,tourist_attraction Page | Maps | Website (541) 588-2825
View Hours
  • Monday: Closed
  • Tuesday: Closed
  • Wednesday: 3:00 – 8:00 PM
  • Thursday: 3:00 – 8:00 PM
  • Friday: 3:00 – 8:00 PM
  • Saturday: 3:00 – 8:00 PM
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJxXzWB1HYvlQRzv1H7eOJJbA Coyote’s Den Disc Golf Course (edited) Ranch House Road, Terrebonne, OR 97760, USA (edited) 44.4337340 -121.2520910 18,963 m golf, outdoors, recreation (edited) disc golf (edited) point_of_interest,establishment (edited) Page | Maps (541) 604-9115
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
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
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
ChIJxc72pugrv1QRkz_TL0pGE4U Art & Music 232 SW 5th St, Redmond, OR 97756, USA 44.2749500 -121.1729040 271 m live music art_gallery,establishment,point_of_interest,store Page | Maps | Website (541) 527-4426
View Hours
  • Monday: 11:00 AM – 5:00 PM
  • Tuesday: 11:00 AM – 6:00 PM
  • Wednesday: 11:00 AM – 6:00 PM
  • Thursday: 11:00 AM – 6:00 PM
  • Friday: 11:00 AM – 6:00 PM
  • Saturday: 12:00 – 4:00 PM
  • Sunday: 12:00 – 4:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJxc5OK-gtv1QRqNEV0UDpCWw NEK Farm & Pheasants 7117 SW Wickiup Ave, Redmond, OR 97756, USA 44.2490970 -121.2540620 6,897 m farms establishment,point_of_interest Page | Maps | Website (541) 728-7100
View Hours
  • Monday: 8:00 AM – 8:00 PM
  • Tuesday: 8:00 AM – 8:00 PM
  • Wednesday: 8:00 AM – 8:00 PM
  • Thursday: 8:00 AM – 8:00 PM
  • Friday: 8:00 AM – 8:00 PM
  • Saturday: 8:00 AM – 8:00 PM
  • Sunday: 8:00 AM – 8:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJxbIW-HIrv1QRKOA4ppkNBSg Wild catch foodtruck 332 SW 5th St, Redmond, OR 97756, USA 44.2740610 -121.1729140 179 m brewery, food trucks, lunch, restaurants establishment,food,point_of_interest,restaurant Page | Maps (541) 480-1677
View Hours
  • Monday: 11:00 AM – 10:00 PM
  • Tuesday: 11:00 AM – 10:00 PM
  • Wednesday: 11:00 AM – 10:00 PM
  • Thursday: 11:00 AM – 10:00 PM
  • Friday: 11:00 AM – 10:00 PM
  • Saturday: 11:00 AM – 10:00 PM
  • Sunday: 11:00 AM – 10:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJXbFHJCUrv1QRLDjb_Nxn8wY Nolan Town Center 782 SW Rimrock Way, Redmond, OR 97756, USA 44.2685070 -121.1929330 1,581 m markets, shopping establishment,point_of_interest,shopping_mall Page | Maps
View Hours
  • Monday: 4:00 AM – 7:30 PM
  • Tuesday: 4:00 AM – 7:30 PM
  • Wednesday: 4:00 AM – 7:30 PM
  • Thursday: 4:00 AM – 7:30 PM
  • Friday: 4:00 AM – 7:30 PM
  • Saturday: 4:30 AM – 7:00 PM
  • Sunday: 4:30 AM – 7:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJX81aCKorv1QRi-Sdc9Txutc Homestead Pump Track 767 NW Canal Blvd, Redmond, OR 97756, USA 44.2834450 -121.1686740 1,274 m outdoors mountain biking, parks, point-of-interest establishment,point_of_interest Page | Maps | Website (541) 504-2000
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: 7:00 AM – 7:00 PM
  • Sunday: 7:00 AM – 7:00 PM
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
ChIJX4VPJiYrv1QR9fzg60yjcvA Schoolhouse Produce 1430 SW Highland Ave, Redmond, OR 97756, USA 44.2693440 -121.1837840 866 m farmers markets, grocery stores, markets, meat markets establishment,food,grocery_or_supermarket,point_of_interest,store Page | Maps | Website (541) 504-7112
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: 10:00 AM – 4:00 PM
  • Sunday: 12:00 – 4:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJX3lxD9cqv1QRGsRRgN15nUU JOANN Fabric and Crafts 732 SW 6th St, Redmond, OR 97756, USA 44.2702520 -121.1736000 265 m shopping establishment,home_goods_store,point_of_interest,store Page | Maps | Website (541) 548-8042
View Hours
  • Monday: 9:00 AM – 9:00 PM
  • Tuesday: 9:00 AM – 9:00 PM
  • Wednesday: 9:00 AM – 9:00 PM
  • Thursday: 9:00 AM – 9:00 PM
  • Friday: 9:00 AM – 9:00 PM
  • Saturday: 9:00 AM – 9:00 PM
  • Sunday: 10:00 AM – 6:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJX-XSYXcqv1QR4ew3fjPAnyk Cinder Butte Meat Co. 197 NW Oneil Way, Redmond, OR 97756, USA 44.3138660 -121.1697480 4,598 m markets, meat markets establishment,food,point_of_interest,store Page | Maps | Website (541) 548-6328
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: 9:00 AM – 3:00 PM
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJwzUf4i4rv1QR2gC0jG6ZtCo Mo’s Egg House 950 SW Veterans Way, Redmond, OR 97756, USA 44.2674830 -121.1788790 694 m breakfast establishment,food,point_of_interest,restaurant Page | Maps | Website (541) 527-4314
View Hours
  • Monday: 6:30 AM – 2:00 PM
  • Tuesday: 6:30 AM – 2:00 PM
  • Wednesday: 6:30 AM – 2:00 PM
  • Thursday: 6:30 AM – 2:00 PM
  • Friday: 6:30 AM – 2:00 PM
  • Saturday: 7:00 AM – 2:00 PM
  • Sunday: 7:00 AM – 2:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJwYUqt4Arv1QRCWGsJRL38Uw Helmholtz Farm Stand 2087 SW Helmholtz Way, Redmond, OR 97756, USA 44.2564260 -121.2209910 4,158 m farmers markets, markets establishment,food,point_of_interest,store Page | Maps | Website
View Hours
  • Monday: Closed
  • Tuesday: Closed
  • Wednesday: Closed
  • Thursday: Closed
  • 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