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: 25
Limit per Page: 25
Offset: 600
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 600, 25

Previous Next

Page 25 of 29

Showing 601 to 625 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJt2IOuSsrv1QRX1uuuvYxrCw	Starbucks Coffee Company	1400 SW Canal Blvd, Redmond, OR 97756, USA	44.2637100	-121.1776900	1,035 m		breakfast, coffee shops, coffee shops,breakfast	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 923-4188	View Hours Monday: 4:30 AM – 9:00 PM Tuesday: 4:30 AM – 9:00 PM Wednesday: 4:30 AM – 9:00 PM Thursday: 4:30 AM – 9:00 PM Friday: 4:30 AM – 9:00 PM Saturday: 4:30 AM – 9:00 PM Sunday: 4:30 AM – 9:00 PM	View Photos (4)
ChIJi_uRyIknv1QR0FuGWUeeQGY	Steelhead Falls	Deschutes River, Oregon, Terrebonne, OR 97760, USA	44.4164590	-121.2898970	18,463 m	outdoors	point of interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)
ChIJz1FQEAAnv1QRMk5rk-fi1Cc	Steelhead Falls Trail	Steelhead falls, SW River Rd, Terrebonne, OR 97760, USA	44.4110400	-121.2921890	18,038 m		trailheads	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ7xpR6j4rv1QRsRiGAabBjGU	Steep Teahouse and Gifts	307 NW 7th St, Redmond, OR 97756, USA	44.2785330	-121.1756440	672 m		desserts, desserts,gift shops,vintage,desserts,gift shops,vintage, gift shops, vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 508-1286	View Hours Monday: Closed 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 – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ79s0CZ8muVQR5Dc2mXeiD8E	Stillwater Campground	Stillwater Campground Rd, Prineville, OR 97754, USA	44.1450790	-120.8292970	30,913 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)
ChIJ0eHyjnYrv1QRAJfslpXkNpc	Stoop Waffle at Pangaea Guild Hall	652 SW 6th St Unit 2, Redmond, OR 97756, USA	44.2707640	-121.1739930	207 m		breakfast, family friendly, lunch, restaurants, restaurants,breakfast,lunch,family friendly,restaurants,breakfast,lunch,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-7641	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: Closed Saturday: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJ36THt83UuFQRjTogxZuxZIk	Subway	2209 S Hwy 97, Redmond, OR 97756, USA	44.2557130	-121.1823430	1,996 m		lunch	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-5814	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)
ChIJ89MmB_Itv1QRnjL8htvqMWU	Summit Crest Neighborhood Park	4892 SW Volcano Ave, Redmond, OR 97756, USA	44.2480920	-121.2262990	4,984 m		parks	establishment,park,point_of_interest	Page \| Maps \| Website		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 (1)
ChIJKR4OuSrXvlQR0fsZ1xzjlnI	Sungrounded Farm	211 NE Wilcox Ave, Terrebonne, OR 97760, USA	44.3568580	-121.1663450	9,386 m		farms, farms,farmers markets,markets	establishment,point_of_interest	Page \| Maps \| Website	(541) 604-8009		View Photos (4)
ChIJKXn1NgDTuFQRVM_ndFU9MIE	Sunriver Brewing Co – Redmond Pub	3750 SW Badger Ave, Redmond, OR 97756, USA	44.2371930	-121.2125430	4,998 m		bars, bars,cocktails,bars,cocktails,pubs,brewery,microbrewery,bars,cocktails,pubs,brewery,microbrewery, brewery, cocktails, microbrewery, pubs	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 585-5449	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)
ChIJcW-Sam0rv1QR9ECnVg5Zqlo	Sunshine Wellness	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2663330	-121.1681220	838 m		wellness center	establishment,health,point_of_interest,spa	Page \| Maps	(541) 678-2826		No photos available
ChIJZwSilLvUuFQRrJpyclLAueA	Super 8 by Wyndham Redmond (edited)	3629 SW 21st Pl, Redmond, OR 97756, USA (edited)	44.2427590	-121.1914310	3,601 m	hotels-motels,rv-parks-camping (edited)	hotels,motels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-8881	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)
ChIJo3Pt7_IVv1QRGvAy6B6lC78	Suttle Lake	Suttle Lake, Oregon 97759, USA	44.4250720	-121.7329210	47,572 m	outdoors	hiking, point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJH87OW_ndvlQRFwvcFQzhXG8	SW Jordan Bridge	SW Jordan Rd, Terrebonne, OR 97760, USA	44.5288570	-121.2646800	29,390 m		tourist attraction	establishment,point_of_interest,tourist_attraction	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 (4)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4645	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJw3eUFgIrv1QR1Im-STuPNPk	Sweet and Salty Shoppe	738 SW Highland Ave, Redmond, OR 97756, USA	44.2694640	-121.1762380	397 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 604-1062		View Photos (4)
ChIJVV7i9Nkqv1QRyWHlBp2qjGU	Sweet Oasis Chocolate Shop	535 SW 6th St, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		bakeries, bakeries,desserts,gift shops,shopping,bakeries,desserts,gift shops,shopping, desserts, gift shops, shopping	establishment,food,point_of_interest,store	Page \| Maps	(541) 408-0821	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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJvywcSRErv1QRSSNO5F2LZAc	Tacos El Poblanito	404 SW Forest Ave, Redmond, OR 97756, USA	44.2713590	-121.1724040	185 m		brewery, family friendly, food trucks, food trucks,restaurants,lunch,family friendly,brewery,food trucks,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 279-3145	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)
ChIJebCqymldv1QR2ivpC1qxzWI	Tamolitch Falls (Blue Pool)	National Forest Road 2672-655, McKenzie Bridge, OR 97413, USA	44.3120370	-122.0270490	68,043 m	outdoors	point of interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3381	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)
ChIJIU_noaorv1QRj1XuAFfRx68	TeaCupFuls	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2920480	-121.1705990	2,176 m		bakeries, bars, bars,bakeries,juice bars,bakeries,juice bars, coffee shops, juice bars	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-3154	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)
ChIJFVsg_lMrv1QR8B_EHbOFCk4	Teresa Variel LMT	307 NW 7th St, Redmond, OR 97756, USA	44.2785480	-121.1756540	673 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 598-5832	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: Closed	No photos available
ChIJWVC5uZErv1QRNibUxGNe-Nk	Terra Kitchen	509 SW 6th St, Redmond, OR 97756, USA	44.2723800	-121.1744230	48 m		cocktails, cocktails,restaurants,lunch,dining,cocktails,restaurants,lunch,dining, desserts, dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 348-8101	View Hours Monday: Closed Tuesday: 3:00 – 8:00 PM Wednesday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Thursday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Friday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Saturday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJESyGgSUrv1QR4Mi5-iXwbUs	Testimony Wine Bar	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		bars, bars,cocktails,live music,bars,cocktails,live music,nightlife,pubs,winery,wine bar,bars,cocktails,live music,nightlife,pubs,winery,wine bar, cocktails, live music, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 400-1556	View Hours Monday: 3:00 – 7:00 PM Tuesday: Closed Wednesday: 2:00 – 8:00 PM Thursday: 1:00 – 8:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 2:00 – 6:00 PM	View Photos (4)
ChIJ_9vJoykrv1QRrLT-3CM76So	Thai O Restaurant	974 SW Veterans Way, Redmond, OR 97756, USA	44.2668320	-121.1789070	756 m		dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4883	View Hours Monday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Wednesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Thursday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Saturday: 4:30 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJQ8vqdVYrv1QRAvp0OzqM-j0	That Guy’s Bistro	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		bistros, food trucks, food trucks,restaurants,lunch,dining,family friendly, lunch, nightlife, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 521-9170	View Hours Monday: 11:30 AM – 8:00 PM Tuesday: Closed Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 8:00 PM	View Photos (4)