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: 9
Limit per Page: 25
Offset: 200
Total Pages: 29

Results:

Total Available Records: 705
Total After Limits: 705
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 200, 25

Previous Next

Page 9 of 29

Showing 201 to 225 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJS2oAQSgrv1QRBG0hJzFPQGI	Dry Canyon Community Art Center	415 SW 6th St, Redmond, OR 97756, USA	44.2732550	-121.1745540	87 m		gift shops, gift shops,shopping	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, nature preserve, parks, parks,nature preserve,state parks,hiking,mountain biking,parks,nature preserve,state parks,hiking,mountain biking, point of interest, state parks	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		hiking, parks, parks,hiking,trailheads,parks,hiking,trailheads, 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, parks,hiking	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, coffee shops,grocery stores	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, family friendly, 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
ChIJgceDHAAtv1QRomcpgIDanZE	Eagle Crest	2001 Mountain Quail Dr, Redmond, OR 97756, USA	44.2564580	-121.2587020	6,986 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			No photos available
ChIJZU8Yp-0sv1QR-4KxHPjaKn8	EAGLE CREST CHALET – ON GOLF COURSE WITH PRIVATE HOT TUB AND EV CHARGING!	Eagle Crest, OR 97756, USA	44.2602500	-121.2744600	8,123 m		golf courses	establishment,lodging,point_of_interest	Page \| Maps			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)
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)
ChIJK3x3PO4sv1QRHz_UtJik-c0	Eagle Crest Retreat on Golf course, Private w/View	Eagle Crest, OR 97756, USA	44.2593690	-121.2801210	8,584 m		golf courses	establishment,lodging,point_of_interest	Page \| Maps			No photos available
ChIJPzQfXpgsv1QRfa9woCroOpc	Eagle Crest Sports Center	1580 Swallow Ln, Redmond, OR 97756, USA	44.2607220	-121.2493670	6,151 m		spas	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-9627	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: 8:00 AM – 9:00 PM	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)
ChIJy8Q_gtAqv1QRVj8E-FG27rA	Eberhards Dairy Products	235 SW Evergreen Ave, Redmond, OR 97756, USA	44.2731770	-121.1707250	262 m		desserts	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 548-5181	View Hours Monday: 8:00 AM – 4:00 PM Tuesday: 8:00 AM – 4:00 PM Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	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)