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

Previous Next

Page 22 of 24

Showing 526 to 550 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJyUYfxZgrv1QRobNKc04mWw4	The Sanctuary Event Space	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 526-7979	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ4U2cUocsv1QRPqv0WHUDzoQ	The Spa at Eagle Crest	8100 Coopers Hawk Dr, Redmond, OR 97756, USA	44.2633950	-121.2704170	7,752 m		spas	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 923-9647		View Photos (3)
ChIJRfWqF-fdvlQR0gBWuK9P83g	The Tam-a-lau Trailhead	7255-7399 SW Jordan Rd, Terrebonne, OR 97760, USA	44.5352650	-121.2841870	30,490 m		hiking	establishment,park,point_of_interest	Page \| Maps \| Website	(541) 546-3412	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)
ChIJo7EHWZnUuFQRP9qNAv98w7c	The View Tap and Grill	1938 SW Elkhorn Ave Drive, Redmond, OR 97756, USA	44.2316880	-121.1911680	4,754 m		dining, lunch, pubs, restaurants, wine bar, winery	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3121	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJTSL70-7VuFQR_I_lnjsS0VI	The Well Oiled Machine Drive Thru Delicatessen	2600 Canal Blvd, Redmond, OR 97756, USA	44.2518540	-121.1891000	2,606 m		breakfast, coffee shops, juice bars, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 527-1937	View Hours Monday: Closed Tuesday: 7:00 AM – 3:00 PM Wednesday: 7:00 AM – 3:00 PM Thursday: 7:00 AM – 3:00 PM Friday: 7:00 AM – 3:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ-YwJ1WMrv1QRY6ZnNeA-Hq8	The Well Table located in Ola Day Spa	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2520490	-121.1887500	2,574 m		massage, spas	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-5215	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:15 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:15 PM Friday: 9:00 AM – 2:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJYW3hHADXvlQRXuymABvPYeY	The Zoo Climbing	9VJP+JQ, Terrebonne, OR 97760, USA	44.3815400	-121.1130800	13,042 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (3)
ChIJxXHU_fUpv1QR6XZd-7yQqLg	Thordarson Farms Redmond,Oregon	Redmond, OR 97756, USA	44.3189160	-121.2698500	9,208 m		farms	establishment,point_of_interest	Page \| Maps			No photos available
ChIJNX5fYxSzuFQRM0FghCexq_o	Three Creek Lake	Three Creek Lake, Oregon 97703, USA	44.0990330	-121.6272880	40,980 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJ-ZJJxf01v1QRtP4XTV7EPjI	Three Creek Lake Campground	NF-16, Sisters, OR 97759, USA	44.0969420	-121.6238110	40,847 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 383-5300		View Photos (4)
ChIJiU_zE1jVuFQRcZUjv7OPL88	Three Sisters Conference Center	3800 SE Airport Way, Redmond, OR 97756, USA	44.2375890	-121.1853060	3,999 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 585-1569		No photos available
ChIJ_cWbWtYrv1QRP9thHFDfZrA	Thrive Restorative Massage	4110 NW 39th Dr, Redmond, OR 97756, USA	44.3140940	-121.2111450	5,481 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 279-6441	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: Closed Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJOa0U7LnUuFQRp3ScJLGUrr8	Timber’s Bar & Grill Redmond	3315 S Hwy 97, Redmond, OR 97756, USA	44.2457240	-121.1910630	3,288 m		bars, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,point_of_interest	Page \| Maps	(541) 923-7604	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJW2MII8Yrv1QRhr8CvrDAels	Tite Knot Craft Coffee	706 SW 10th St, Redmond, OR 97756, USA	44.2704250	-121.1783210	427 m		bakeries, coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-5568	View Hours Monday: 6:00 AM – 4:00 PM Tuesday: 6:00 AM – 4:00 PM Wednesday: 6:00 AM – 4:00 PM Thursday: 6:00 AM – 4:00 PM Friday: 6:00 AM – 4:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4:00 PM	View Photos (4)
ChIJvZxchNwrv1QRTUiDPY6tuJ4	Tite Knot Craft Coffee	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-5568	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: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJ4agFB04rv1QR7F1pEK5Ffoo	Tite Knot Craft Coffee – Central Bakery	950 SW Veterans Way, Redmond, OR 97756, USA	44.2674300	-121.1790250	706 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-1353	View Hours Monday: 6:00 AM – 1:00 PM Tuesday: 6:00 AM – 1:00 PM Wednesday: 6:00 AM – 1:00 PM Thursday: 6:00 AM – 1:00 PM Friday: 6:00 AM – 1:00 PM Saturday: 7:00 AM – 1:00 PM Sunday: 7:00 AM – 1:00 PM	No photos available
ChIJm_TKCOkqv1QR2qAobwDEMTM	Tobacco Joe	909 NW 6th St, Redmond, OR 97756, USA	44.2849240	-121.1743300	1,368 m		coffee shops	establishment,point_of_interest,store	Page \| Maps	(541) 923-1630	View Hours Monday: 6:00 AM – 8:00 PM Tuesday: 6:00 AM – 8:00 PM Wednesday: 6:00 AM – 8:00 PM Thursday: 6:00 AM – 8:00 PM Friday: 6:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (4)
ChIJJel20Skrv1QRrn0MaqlJ9aA	Towne Center	101 SW Indian Ave, Redmond, OR 97756, USA	44.2679930	-121.1780970	613 m		shopping	establishment,point_of_interest,shopping_mall	Page \| Maps			No photos available
ChIJ8xhuChArv1QRJ6Vpj3LAG_o	Transcendence Therapeutic Massage	813 SW Highland Ave Suite 203, Redmond, OR 97756, USA	44.2698140	-121.1767460	385 m		massage	establishment,point_of_interest	Page \| Maps	(541) 815-3897	View Hours Monday: Closed Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 9:00 AM – 1:00 PM Sunday: Closed	View Photos (4)
ChIJQx0aRkrPuFQR8NiBhyiy3ug	Treasure Valley Coffee of Central Oregon	4620 SW 23rd St Building A, Redmond, OR 97756, USA	44.2344340	-121.1937000	4,529 m		coffee shops	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-1595	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 – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJS3vg0HMrv1QR_mp-qOBFnnw	Trendy Tots	344 SW 7th St, Redmond, OR 97756, USA	44.2738500	-121.1750820	165 m		thrift stores	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 279-4704	View Hours Monday: 11:00 AM – 4:00 PM Tuesday: 11:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 11:00 AM – 4:00 PM Friday: 11:00 AM – 4:00 PM Saturday: 11:00 AM – 4:00 PM Sunday: Closed	No photos available
ChIJrXiMfigrv1QRFvkk4mnI8Sk	Trinity Bikes	1730 SW Parkway Dr, Redmond, OR 97756, USA	44.2697030	-121.1873370	1,116 m	outdoors (edited)	mountain biking (edited)	bicycle_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-5650	View Hours Monday: Closed Tuesday: 10:00 AM – 5:30 PM Wednesday: 10:00 AM – 5:30 PM Thursday: 10:00 AM – 5:30 PM Friday: 10:00 AM – 5:30 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJwdNmv68yv1QRT1u_GKjaTDs	Tumalo Canal Trailhead	Oregon 97703, USA	44.2204530	-121.3393490	14,397 m		hiking, mountain biking	establishment,park,point_of_interest	Page \| Maps	(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)
ChIJP81I0g6xuFQRDzFmHl2j-yU	Tumalo Falls	Tumalo Falls, Oregon 97703, USA	44.0339560	-121.5668790	41,074 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)