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

Previous Next

Page 24 of 26

Showing 576 to 600 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJZ1h4WgDPuFQRMXmbDnhyUg0	The Landing	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		brewery, brewery,food trucks, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 12:00 – 10:00 PM Saturday: 12:00 – 10:00 PM Sunday: 12:00 – 9:30 PM	View Photos (4)
ChIJMQ4S-5Msv1QRW6O70jki7ng	The Lodge at Eagle Crest	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2607220	-121.2625140	7,177 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 923-2453		View Photos (4)
ChIJFelkhMErv1QRj0q9yVB8BdA	The Mighty Greek	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks, food trucks,restaurants,lunch,dining,family friendly, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 380-0283	View Hours Monday: Closed 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: Closed	View Photos (4)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs,restaurants,breakfast,lunch,dining, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3731	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJ01L9jMTUuFQRT_0H9QOak8k	The Original Pancake House Redmond	3030 SW 6th St, Redmond, OR 97756, USA	44.2488200	-121.1729740	2,648 m		breakfast, restaurants, restaurants,breakfast,dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-2515	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: 6:00 AM – 2:00 PM Sunday: 6:00 AM – 2:00 PM	View Photos (4)
ChIJmzvwdTIrv1QRzT5vr2KiJSg	The Original Peruvian Food & Minimarket	1530 S Hwy 97, Redmond, OR 97756, USA	44.2618670	-121.1774720	1,229 m		desserts, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 460-0144	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 10:00 AM – 7:00 PM	View Photos (4)
ChIJt7CAXJ4qv1QRmWDMsvLPYCk	The Radlands	1859 NE Maple Ave, Redmond, OR 97756, USA	44.2919890	-121.1461790	3,085 m	outdoors	mountain biking, point of interest	establishment,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 7:30 PM Tuesday: 6:00 AM – 7:30 PM Wednesday: 6:00 AM – 7:30 PM Thursday: 6:00 AM – 7:30 PM Friday: 6:00 AM – 7:30 PM Saturday: 6:00 AM – 7:30 PM Sunday: 6:00 AM – 7:30 PM	View Photos (4)
ChIJJbJ295Ysv1QRK0dYiUZ9UoA	The Resort Course At Eagle Crest	7300 Robin Ct, Redmond, OR 97756, USA	44.2596380	-121.2575350	6,813 m		driving range, golf courses, golf lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4653	View Hours Monday: 8:30 PM – 12:00 AM Tuesday: 8:30 PM – 12:00 AM Wednesday: 8:30 PM – 12:00 AM Thursday: 8:30 PM – 12:00 AM Friday: 8:30 PM – 12:00 AM Saturday: 8:30 PM – 12:00 AM Sunday: 12:00 AM – 6:30 PM, 8:30 PM – 12:00 AM	View Photos (4)
ChIJFWK3Ejt6z1QR5gwhhjRBRkA	The Rogue Chef Breakfast	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		breakfast, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 678-2559	View Hours Monday: 7:00 AM – 12:00 PM Tuesday: 7:00 AM – 12:00 PM Wednesday: 7:00 AM – 12:00 PM Thursday: 7:00 AM – 12:00 PM Friday: 7:00 AM – 12:00 PM Saturday: 7:00 AM – 12:00 PM Sunday: Closed	View Photos (4)
ChIJmdc9yMYrv1QRqWkW-OrnumI	The Rooftop at SCP Redmond	restaurants (edited)	44.2721630	-121.1745910	74 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
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)
ChIJkbM2nI8rv1QROyeG0x0jnoQ	The Style Haus	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 279-9332	View Hours Monday: Closed Tuesday: 11:00 AM – 5:00 PM 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: Closed	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, hiking,trailheads	establishment,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		bars,cocktails,bars,cocktails,breakfast,dining, dining, lunch, pubs, restaurants, wine bar, winery	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3121	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: 8:00 AM – 6:00 PM Sunday: 8:00 AM – 6:00 PM	View Photos (4)
ChIJTSL70-7VuFQR_I_lnjsS0VI	The Well Oiled Machine Drive Thru Delicatessen	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2518540	-121.1891000	2,606 m		breakfast, coffee shops, coffee shops,breakfast,lunch, juice bars, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 527-1937	View Hours Monday: Closed 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: 8:00 AM – 2:00 PM 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, bars,cocktails,nightlife,pool tables,bars,cocktails,nightlife,pool tables,pubs, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,point_of_interest	Page \| Maps \| Website	(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, coffee shops,bakeries,lunch,family friendly,shopping	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)