Data

Debug Info (admin only)

Search Criteria:

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

Pagination:

Current Page: 8
Limit per Page: 25
Offset: 175
Total Pages: 26

Results:

Total Available Records: 645
Total After Limits: 645
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 (e.is_published IS NULL OR e.is_published = 1) AND NOT EXISTS (
                SELECT 1 FROM wp_redmond_explorer_edits e2 
                WHERE e2.place_id = p.place_id AND e2.is_published = 0
            ) ORDER BY COALESCE(e.name, p.name) ASC LIMIT 175, 25

Previous Next

Page 8 of 26

Showing 176 to 200 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ8a3rG67HuFQRZt-dJvqPjAI	Discovery With Horses	6262 SW Nighthawk Ave, Redmond, OR 97756, USA	44.2151110	-121.2450490	8,544 m		horseback rides	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 815-2017	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 – 5:00 PM Sunday: 9:00 AM – 5:00 PM	No photos available
ChIJ1YkTCskrv1QRBM7YTyMXzU4	District Day Spa	823 SW 12th St, Redmond, OR 97756, USA	44.2691460	-121.1809830	682 m		spas	beauty_salon,establishment,point_of_interest	Page \| Maps \| Website	(541) 548-5352		No photos available
ChIJR1NzVXErv1QRTbTqSUcJlOE	Don Gabino’s Mexican Grill	530 SW 6th St Ste 102, Redmond, OR 97756, USA	44.2719360	-121.1739710	76 m		breakfast,lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(458) 836-7577	View Hours Monday: 7:00 AM – 10:00 PM 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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJs6KM3VvVuFQReo-RvihOicg	Doozys	1729 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2534450	-121.1867190	2,363 m		coffee shops	cafe,establishment,food,point_of_interest	Page \| Maps	(541) 316-2242	View Hours Monday: 7:00 AM – 2:00 AM Tuesday: 7:00 AM – 2:00 AM Wednesday: 7:00 AM – 2:00 AM Thursday: 7:00 AM – 2:00 AM Friday: 7:00 AM – 2:00 AM Saturday: 7:00 AM – 2:00 AM Sunday: 7:00 AM – 2:00 AM	No photos available
ChIJSw_tV9cqv1QRLNc53CS77VA	Double J Saloon	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		bars, pool tables, pubs	bar,point_of_interest,establishment	Page \| Maps	(541) 923-1868		View Photos (4)
ChIJncT7DKrVuFQRYWeqdi_72o8	Double K Collectibles	2130 S Hwy 97 a, Redmond, OR 97756, USA	44.2562770	-121.1809400	1,901 m		vintage	establishment,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJv8uUGM8rv1QR7vmOXDVoY90	Double T’s Smoothies and Paninis	404 SW Forest Ave, Redmond, OR 97756, USA	44.2712610	-121.1724220	193 m		coffee shops, desserts,juice bars,food trucks,breakfast, juice bars	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 4:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 4:00 PM Friday: 11:00 AM – 4:00 PM Saturday: 11:00 AM – 4:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJt_Qk0-srv1QRFxXY2DHjjSE	Dry Canyon Club + EV Charging Station	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2839490	-121.1888140	1,730 m		bars, brewery, brewery,food trucks, food trucks	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 550-9340	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: 10:00 AM – 10:00 PM Sunday: 10:00 AM – 9:00 PM	View Photos (4)
ChIJS2oAQSgrv1QRBG0hJzFPQGI	Dry Canyon Community Art Center	415 SW 6th St, Redmond, OR 97756, USA	44.2732550	-121.1745540	87 m		gift shops	art_gallery,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 316-5448	View Hours Monday: Closed 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: 11:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJKa5gyd8qv1QR0IIQ9dCL34c	Dry Canyon Disc Golf Course (edited)	1515 W Antler Ave, Redmond, OR 97756, USA (edited)	44.2772660	-121.1843650	979 m	outdoors,recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7275		View Photos (4)
ChIJPWUNQyUrv1QRdpIVQnbQzxs	Dry Canyon Park & Trail System	Unnamed Road, Redmond, OR 97756, USA	44.3022990	-121.1902760	3,548 m	outdoors	hiking, mountain biking, parks,nature preserve,state parks,hiking,mountain biking, point of interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 9:30 PM Tuesday: 6:00 AM – 9:30 PM Wednesday: 6:00 AM – 9:30 PM Thursday: 6:00 AM – 9:30 PM Friday: 6:00 AM – 9:30 PM Saturday: 6:00 AM – 9:30 PM Sunday: 6:00 AM – 9:30 PM	View Photos (4)
ChIJD0k1Bdwqv1QRKphf2ef14PI	Dry Canyon Trail	135 NW 9th St, Redmond, OR 97756, USA	44.2763800	-121.1835580	874 m		parks, parks,hiking,trailheads	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
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)
ChIJJ822XjPVuFQR2N6eOjFeEcI	Dry Canyon Trailhead	SW Reindeer Ave &, SW 19th St, Redmond, OR 97756, USA	44.2566610	-121.1890080	2,143 m		parks	establishment,point_of_interest	Page \| Maps		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 (2)
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		breakfast, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(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, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,desserts,restaurants,breakfast,lunch,dining,family friendly, 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)
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)
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)