Data

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: 8
Limit per Page: 25
Offset: 175
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 COALESCE(e.name, p.name) ASC LIMIT 175, 25

Previous Next

Page 8 of 24

Showing 176 to 200 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJJQwPfoIrv1QR8oRmHF6bnX4	Dry Canyon trail Dog park	1429 W Antler Ave, Redmond, OR 97756, USA	44.2767250	-121.1839110	917 m		parks	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: Open 24 hours Tuesday: 6:00 AM – 12:00 AM Wednesday: Open 24 hours Thursday: 6:00 AM – 12:00 AM Friday: Open 24 hours Saturday: 6:00 AM – 12:00 AM Sunday: Open 24 hours	View Photos (4)
ChIJswmNVU0rv1QRfEmhe7rbX9o	DUG DEEP JEWELRY	714 NW Hemlock Ave, Redmond, OR 97756, USA	44.2835670	-121.1756680	1,225 m		gift shops	establishment,jewelry_store,point_of_interest,store	Page \| Maps	(253) 208-0540	View Hours Monday: 7:00 AM – 5:00 PM Tuesday: 7:00 AM – 5:00 PM Wednesday: 7:00 AM – 5:00 PM Thursday: 7:00 AM – 5:00 PM Friday: 7:00 AM – 5:00 PM Saturday: Open 24 hours Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJh3fAPiYrv1QRpOP_eg4WWIY	Dutch Bros Coffee	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697990	-121.1842810	882 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJo_b4Dekqv1QRFjjVNnO67Q8	Dutch Bros Coffee	650 NW Jackpine Ave, Redmond, OR 97756, USA	44.2853920	-121.1743990	1,421 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJv-zgi9LUuFQR0V678QtcXR0	Dutch Bros Coffee	1990 S Hwy 97, Redmond, OR 97756, USA	44.2578020	-121.1799770	1,717 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJGfQD1hIrv1QRKrBK_ODeVoM	Dylan’s Mexican food	865 SW 17th St unit 101, Redmond, OR 97756, USA	44.2690290	-121.1882290	1,207 m		food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 527-4004	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 – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJU9HcRdoqv1QR9T3csxUwSec	E BarGrill	314 SW 5th St, Redmond, OR 97756, USA	44.2742760	-121.1729530	200 m		bars, bistros, breakfast, brewery, cocktails, desserts, dining, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-7050	View Hours Monday: 11:00 AM – 8:30 PM Tuesday: 11:00 AM – 8:30 PM Wednesday: 11:00 AM – 8:30 PM Thursday: 11:00 AM – 8:30 PM Friday: 11:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: 9:00 AM – 8:30 PM	View Photos (4)
ChIJlwAWOiMtv1QRYW5BRtYV_DQ	E farm	1825 SW 55th St, Redmond, OR 97756, USA	44.2597400	-121.2357130	5,125 m		farms	establishment,point_of_interest	Page \| Maps	(541) 815-7706		No photos available
ChIJSUKZDpQsv1QR7VsZTYLgFtg	Eagle Crest Day Spa	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2600190	-121.2626800	7,205 m		massage, spas	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 923-9647		View Photos (1)
ChIJl7JRa5Qsv1QRknvp_YCcODc	Eagle Crest Golf (edited)	1590 Mountain Quail Dr, Redmond, OR 97756, USA (edited)	44.2596430	-121.2626810	7,214 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 923-5002		View Photos (4)
ChIJO-QNPsMtv1QR59rfmORKRAg	Eagle Crest Golf Course Seclusion (edited)	1995 Cinnamon Teal Dr, Redmond, OR 97756, USA (edited)	44.2590570	-121.2737660	8,092 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps			View Photos (4)
ChIJod7ssvIsv1QRq_2BxehEP6Y	Eagle Crest Putting Course	1100 Red Wing Loop, Redmond, OR 97756, USA	44.2628250	-121.2739640	8,040 m		driving range, golf lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-5002	View Hours Monday: 8:00 AM – 6:30 PM Tuesday: 8:00 AM – 6:30 PM Wednesday: 8:00 AM – 6:30 PM Thursday: 8:00 AM – 6:30 PM Friday: 8:00 AM – 6:30 PM Saturday: 8:00 AM – 6:30 PM Sunday: 8:00 AM – 6:30 PM	View Photos (4)
ChIJ4U2cUocsv1QR8Q5Z1U_1uuc	Eagle Crest Resort	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2598710	-121.2629020	7,226 m		driving range, golf courses, hotels, resorts	establishment,lodging,point_of_interest,real_estate_agency,tourist_attraction,travel_agency	Page \| Maps \| Website	(855) 682-4786	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)
ChIJv23Br6Isv1QR-H2UiJrr0Gg	Eagle Crest Resort	Eagle Crest Resort Timeshare, 514 Redtail Hawk Dr, Redmond, OR 97756, USA	44.2572210	-121.2517700	6,431 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(855) 682-4786		View Photos (4)
ChIJI_sTxu0tv1QR05vyqwLVLaM	Eagle Crest Resort Ridge Course (edited)	Coopers Hawk Dr, Redmond, OR 97756, USA (edited)	44.2629010	-121.2735520	8,006 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 923-5002	View Hours Monday: 9:30 AM – 4:00 PM Tuesday: 9:30 AM – 4:00 PM Wednesday: 9:30 AM – 4:00 PM Thursday: 9:30 AM – 4:00 PM Friday: 9:30 AM – 4:00 PM Saturday: 9:30 AM – 4:00 PM Sunday: 9:30 AM – 4:00 PM	View Photos (4)
ChIJGwckEo0sv1QRaJFdA7v0ZQY	Eagle Ridge Golf Pro Shop	8300 Coopers Hawk Dr, Redmond, OR 97756, USA	44.2642920	-121.2717220	7,842 m		driving range, golf courses, golf lessons	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-5002		View Photos (4)
ChIJj5QTJGopv1QRvjAqvzGZE2s	Eagle Rock	8825 NW 93rd Ln, Terrebonne, OR 97760, USA	44.3602440	-121.2859710	13,206 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJ–OMvOUqv1QRxDA_TpPutb8	Edward Jones – Financial Advisor: Joshua M Werner	655 NW Greenwood Ave #4, Redmond, OR 97756, USA	44.2823990	-121.1749780	1,091 m		markets	establishment,finance,point_of_interest	Page \| Maps \| Website	(541) 923-7773	View Hours Monday: 7:30 AM – 4:00 PM Tuesday: 7:30 AM – 4:00 PM Wednesday: 7:30 AM – 4:00 PM Thursday: 7:30 AM – 4:00 PM Friday: 7:30 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJH4VhWx0rv1QRAoTZdYKpdZY	El ChangoLeon Mexican food	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 699-9930	View Hours Monday: Closed Tuesday: 11:30 AM – 7:00 PM Wednesday: 11:00 AM – 6:30 PM Thursday: 3:00 – 7:00 PM Friday: 3:00 – 7:00 PM Saturday: 3:00 – 7:00 PM Sunday: Closed	View Photos (4)
ChIJdcoUlc4rv1QRI_QYB1G2qbY	El imperio	245 SW 6th St, Redmond, OR 97756, USA	44.2748110	-121.1744290	247 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 325-6415	View Hours Monday: Closed 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 – 8:00 PM	View Photos (4)
ChIJSUDCDjUrv1QRq1GRLrBr2qg	El Patron Mexican Kitchen	1555 NW 6th St, Redmond, OR 97756, USA	44.2906330	-121.1744750	2,003 m		food trucks, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 279-3955	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: 9:00 AM – 7:00 PM Friday: 9:00 AM – 7:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJW3U8vGcrv1QRKpwH0atxfkg	El Tortellini	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 527-9979	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJcUAD4bQrv1QR4XdfTCThkjE	Elements Public House	lunch (edited)	44.2934270	-121.1744270	2,314 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 9:00 PM Wednesday: 3:00 – 9:00 PM Thursday: 3:00 – 9:00 PM Friday: 3:00 – 9:00 PM Saturday: 3:00 – 9:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)
ChIJ-3UW297VuFQRMBODBRjq4uE	Enterprise Rent-A-Car	3113 S Hwy 97 STE 105, Redmond, OR 97756, USA	44.2479830	-121.1885370	2,977 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 699-3134	View Hours Monday: 8:00 AM – 6:00 PM 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: Closed Sunday: Closed	View Photos (4)
ChIJI8dU-Nkqv1QRk_nFF7gUCeQ	Enterprise Rent-A-Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2531150	-121.1607320	2,410 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(833) 827-6502	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)