Skip to content
Reset Filters
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: 1
  • Limit per Page: 25
  • Offset: 0
  • 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 0, 25
Page 1 of 27
Showing 1 to 25 of 659 results
Place ID Name Address Latitude Longitude Distance Category Search Term Types Links Phone Hours Photos
ChIJCYdlAG4rv1QRLobmftuvHic 1/8th Street Food Trucks, Patio & Taphouse 639 SW 8th Street &, SW Glacier Ave, Redmond, OR 97756, USA 44.2708060 -121.1767190 301 m cocktails, family friendly, food trucks, nightlife bar,point_of_interest,food,establishment Maps | Website (541) 527-1387
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ50h8Hdoqv1QRcz-tvXRNCf0 2Hearts Flower Shop 307 NW 7th St Suite B, Redmond, OR 97756, USA 44.2785190 -121.1756190 670 m gift shops florist,bakery,store,point_of_interest,food,establishment Maps | Website (541) 280-1298
View Hours
  • Monday: 10:00 AM – 4:00 PM
  • Tuesday: 10:00 AM – 4:00 PM
  • 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: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJkXIY8Uorv1QRGG_JvMHB9Ro 3 Peaks Coffee 722 NW 6th St, Redmond, OR 97756, USA 44.2822640 -121.1740690 1,072 m coffee shops point_of_interest,establishment Maps
View Hours
  • Monday: 6:00 AM – 2:00 PM
  • Tuesday: 6:00 AM – 2:00 PM
  • Wednesday: 6:00 AM – 2:00 PM
  • Thursday: 6:00 AM – 2:00 PM
  • Friday: 6:00 AM – 2:00 PM
  • Saturday: 6:00 AM – 2:00 PM
  • Sunday: 8:00 AM – 1:00 PM
View Photos (3)
Place photoPlace photoPlace photo
ChIJPb3noe4qv1QRIXAxCYdixhw 4 Wheel Mobil Home Court 1247 NW 6th St, Redmond, OR 97756, USA 44.2880420 -121.1742860 1,715 m rv parks rv_park,lodging,point_of_interest,establishment Maps (541) 548-5894
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJw0TM0twqv1QRYu3Kve2oe4M 5 Below Steakhouse and Breakfast Nook (edited) 325 NW 5th St, Redmond, OR 97756, USA (edited) 44.2788570 -121.1735210 694 m breakfast, desserts,restaurants,breakfast,lunch, desserts, lunch, restaurants (edited) restaurant,point_of_interest,food,establishment (edited) Maps | Website (edited) (541) 923-2213
View Hours
  • Monday: 7:00 AM – 9:00 PM
  • Tuesday: 7:00 AM – 9:00 PM
  • Wednesday: 7:00 AM – 9:00 PM
  • Thursday: 7:00 AM – 9:00 PM
  • Friday: 7:00 AM – 9:00 PM
  • Saturday: 7:00 AM – 9:00 PM
  • Sunday: 7:00 AM – 9:00 PM
No photos available
ChIJaxh4FKQrv1QRjG-sXSSIRtQ 7 Peaks Candle Co. 106 SE Evergreen Ave suite i, Redmond, OR 97756, USA 44.2720410 -121.1680790 470 m gift shops home_goods_store,point_of_interest,store,establishment Maps | Website (541) 912-3034
View Hours
  • Monday: Closed
  • Tuesday: Closed
  • Wednesday: Closed
  • Thursday: 9:00 AM – 5:00 PM
  • Friday: 9:00 AM – 5:00 PM
  • Saturday: Closed
  • Sunday: 9:00 AM – 5:00 PM
View Photos (2)
Place photoPlace photo
ChIJ5RDgdCgrv1QR3zCJI-Ilb_o 7-Eleven 1209 SW Highland Ave, Redmond, OR 97756, USA 44.2698430 -121.1811940 656 m grocery stores, juice bars convenience_store,liquor_store,cafe,restaurant,food,point_of_interest,store,establishment Maps | Website (541) 548-1381
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
ChIJ-1q8LQArv1QRVMod9zsK488 A New Tropical 122 SW 5th St, Redmond, OR 97756, USA 44.2760920 -121.1729770 393 m food trucks restaurant,food,point_of_interest,establishment Maps | Website (541) 647-9068
View Hours
  • Monday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM
  • Tuesday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM
  • Wednesday: Closed
  • Thursday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM
  • Friday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM
  • Saturday: 4:00 – 8:00 PM
  • Sunday: 11:00 AM – 8:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJQSLYC5zVuFQRX-2YIBfSeaw A-Time-4-U Massage and Spa Therapy 2963 SW Volcano Cir, Redmond, OR 97756, USA 44.2484680 -121.2031920 3,556 m massage, spas, wellness center spa,health,point_of_interest,establishment Maps | Website (541) 504-7108
View Hours
  • Monday: Closed
  • Tuesday: 10:00 AM – 7:00 PM
  • Wednesday: 10:00 AM – 7:00 PM
  • Thursday: 10:00 AM – 7:00 PM
  • Friday: 10:00 AM – 7:00 PM
  • Saturday: 10:00 AM – 7:00 PM
  • Sunday: Closed
View Photos (3)
Place photoPlace photoPlace photo
ChIJg5s4i9LUuFQRc3g8jrCTQoo Abby’s Legendary Pizza 1938 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA 44.2581450 -121.1795990 1,672 m bars, dining, lunch, pubs, restaurants meal_takeaway,meal_delivery,restaurant,food,point_of_interest,establishment Maps | Website (541) 548-5266
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 – 10:00 PM
  • Saturday: 11:00 AM – 10:00 PM
  • Sunday: 11:00 AM – 9:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ31jIkZItv1QR9nMR5Q-6yTI Aerie Cafe 1522 Cline Falls Rd, Redmond, OR 97756, USA 44.2597390 -121.2627970 7,220 m breakfast, dining restaurant,food,point_of_interest,establishment Maps | Website (541) 504-3870
View Hours
  • Monday: 7:00 – 10:30 AM
  • Tuesday: 7:00 – 10:30 AM
  • Wednesday: 7:00 – 10:30 AM
  • Thursday: 7:00 – 10:30 AM
  • Friday: 7:00 – 10:30 AM
  • Saturday: 7:00 – 10:30 AM
  • Sunday: 7:00 – 10:30 AM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJsYpb_ssrv1QRsqIW79vbHSk Aiwa Asian Restaurant 150 NW 5th St, Redmond, OR 97756, USA 44.2772060 -121.1730960 514 m lunch, restaurants meal_takeaway,restaurant,food,point_of_interest,establishment Maps | Website (541) 527-1380
View Hours
  • Monday: 11:00 AM – 9:00 PM
  • Tuesday: Closed
  • Wednesday: 11:00 AM – 9:00 PM
  • Thursday: 11:00 AM – 9:00 PM
  • Friday: 11:00 AM – 9:30 PM
  • Saturday: 11:00 AM – 9:30 PM
  • Sunday: 11:00 AM – 9:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJi6ZBhybVuFQRNVz5F5EN1VE Alamo Rent A Car 2522 Jesse Butler Cir, Redmond, OR 97756, USA 44.2530300 -121.1606490 2,421 m car rentals car_rental,point_of_interest,establishment Maps | Website (844) 370-7398
View Hours
  • Monday: 8:00 AM – 12:30 AM
  • Tuesday: 8:00 AM – 12:30 AM
  • Wednesday: 8:00 AM – 12:30 AM
  • Thursday: 8:00 AM – 12:30 AM
  • Friday: 8:00 AM – 12:30 AM
  • Saturday: 8:00 AM – 12:30 AM
  • Sunday: 8:00 AM – 12:30 AM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ-WEQJKfVuFQR7aUmMSzyg0U Alaska Airlines – Redmond 2522 Jesse Butler Cir, Redmond, OR 97756, USA 44.2530250 -121.1608350 2,415 m airports airport,point_of_interest,establishment Maps | Website (800) 225-2752
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJSxInVMsnv1QRQeWs3XKUMNY Alder Springs Trailhead CROOKED RIVER, OR 97760, USA 44.4332760 -121.3577690 23,083 m hiking, trailheads park,point_of_interest,establishment Maps | Website
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ5ebHESgrv1QR2xV7RW0YdQM All About You/Redmond Engraving 725 NW Kingwood Ave, Redmond, OR 97756, USA 44.2875910 -121.1758360 1,672 m gift shops store,point_of_interest,establishment Maps | Website (541) 923-1525
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: Closed
  • Saturday: Closed
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJw1Nd3C8rv1QRCY456FtXkhw American Legion Park 850 SW Rimrock Way, Redmond, OR 97756, USA 44.2685900 -121.1911530 1,443 m parks, playgrounds, rock climbing park,tourist_attraction,point_of_interest,establishment Maps | Website
View Hours
  • Monday: Closed
  • 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: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJHeJHmNcqv1QREMV8kKzY2yE American Legion Post 44 704 SW 8th St, Redmond, OR 97756, USA 44.2704380 -121.1760810 297 m live music, nightlife bar,restaurant,point_of_interest,food,store,establishment Maps | Website (541) 548-5688
View Hours
  • Monday: 2:00 – 8:00 PM
  • Tuesday: 2:00 – 8:00 PM
  • Wednesday: 2:00 – 8:00 PM
  • Thursday: 2:00 – 8:00 PM
  • Friday: 2:00 – 8:00 PM
  • Saturday: 2:00 – 8:00 PM
  • Sunday: Closed
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJ3WPj8pkrv1QRLTmYGaC5XTo Amy Coville Massage, LMT 614 SW 12th St, Redmond, OR 97756, USA 44.2712730 -121.1804850 544 m massage point_of_interest,establishment Maps | Website (541) 306-8007
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJjQX4oygrv1QRPwXQ5ZoVmAw Anderson Julie 654 NW 4th St, Redmond, OR 97756, USA 44.2818720 -121.1718560 1,042 m massage point_of_interest,establishment Maps (541) 280-2535 No photos available
ChIJSReNtm4rv1QRUvPn3v-Ifr0 Annex Sports Bar 413 SW Glacier Ave, Redmond, OR 97756, USA 44.2709410 -121.1724960 218 m bars, cocktails, dining, food trucks, live music, nightlife, pool tables bar,restaurant,food,point_of_interest,establishment Maps | Website (541) 699-1282
View Hours
  • Monday: 4:00 – 10:00 PM
  • Tuesday: 4:00 – 10:00 PM
  • Wednesday: Closed
  • Thursday: 4:00 – 10:00 PM
  • Friday: 4:00 PM – 12:00 AM
  • Saturday: 12:00 PM – 12:00 AM
  • Sunday: 12:00 – 10: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 point_of_interest,establishment Maps (541) 527-4723 No photos available
ChIJp17jgrzUuFQRmzMHKITf0ZU Applebee’s Grill + Bar 3807 SW 21st St, Redmond, OR 97756, USA 44.2412720 -121.1921840 3,777 m bars, breakfast, cocktails, lunch, nightlife, pubs, restaurants restaurant,bar,food,point_of_interest,establishment Maps | Website (541) 923-4777
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 – 11:00 PM
  • Saturday: 11:00 AM – 11:00 PM
  • Sunday: 11:00 AM – 9:00 PM
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJIQ-ybqbhwFQRpoam_WdpYBE Aranda’s Massage Therapy & Myofascial Bodywork 716 SW 11th St, Redmond, OR 97756, USA 44.2703250 -121.1793760 504 m massage spa,point_of_interest,establishment Maps | Website (541) 788-5732
View Photos (4)
Place photoPlace photoPlace photoPlace photo
ChIJD0UXA9Irv1QRUK7SsGtis_U Arome (edited) 432 SW 6th St, Redmond, OR 97756, USA (edited) 44.2730890 -121.1740260 53 m shopping (edited) boutiques, grocery stores (edited) boutiques_grocery_or_supermarket,furniture_store,home_goods_store,store,food,point_of_interest,establishment (edited) Maps | Website (edited) (541) 527-4727
View Hours
  • Monday: 10:00 AM – 5:00 PM
  • Tuesday: 10:00 AM – 5: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 – 5:00 PM
No photos available