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: 27

Results:

Total Available Records: 659
Total After Limits: 659
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 27

Showing 526 to 550 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJfZnhGwDVuFQRzoUj_Sgn8sw	Sisters Coffee Shop	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530530	-121.1606580	2,419 m		coffee shops	cafe,food,store,point_of_interest,establishment	Maps			View Photos (4)
ChIJRRDliMswv1QRRSCxZesqb20	Sisters Creekside Campground	504 S Locust St, Sisters, OR 97759, USA	44.2876610	-121.5437420	29,488 m		campgrounds	campground,park,lodging,point_of_interest,establishment	Maps \| Website	(541) 588-0445		View Photos (4)
ChIJ3RxIsSgrv1QRxS2ac7jVisA	Sisters Meat and Smokehouse – Redmond	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		dining, food trucks, grocery stores, lunch, meat markets, smokehouses	restaurant,food,point_of_interest,store,establishment	Maps \| Website	(458) 899-5249	View Hours Monday: 9:00 AM – 6:00 PM 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 – 6:00 PM Sunday: 9:00 AM – 6:00 PM	View Photos (4)
ChIJ-6saQsswv1QRxtbWAN2RoFM	Sisters RV Park	1100 US-20, Sisters, OR 97759, USA	44.2863040	-121.5342790	28,728 m		koa	rv_park,lodging,point_of_interest,establishment	Maps	(541) 549-3861		View Photos (4)
ChIJT2v8ufIqv1QRsQHaL9WVENM	Sleep Inn & Suites	1847 NW 6th St, Redmond, OR 97756, USA	44.2930710	-121.1748130	2,275 m	hotels-motels (edited)	hotels (edited)	lodging,point_of_interest,establishment	Maps \| Website	(541) 516-6269		View Photos (4)
ChIJRSfijO_QvlQRocjLzJ7L3qs	Smith Rock	Terrebonne, OR 97760, USA	44.3684280	-121.1422180	10,948 m		rock climbing	point_of_interest,establishment	Maps			View Photos (4)
ChIJh_C1tYXWvlQRE8jo4FVQJf8	Smith Rock Bivouac Area (The Bivy) (edited)	Terrebonne, OR 97760, USA (edited)	44.3608420	-121.1410040	10,153 m	recreation,outdoors,rv-parks-camping (edited)	camping,rock climbing,state park (edited)	campground,lodging,park,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 548-7501		View Photos (4)
ChIJy0D6fH4rv1QRGnOfHmBix98	Smith Rock BMX	1935 NE Maple Ave, Redmond, OR 97756, USA	44.2912600	-121.1455990	3,062 m		mountain biking	point_of_interest,establishment	Maps \| Website	(541) 316-0005		View Photos (4)
ChIJH8jLKpLWvlQRon0OlkWRbXg	Smith Rock Climbing Guides	9297 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606920	-121.1385530	10,189 m		rock climbing	school,point_of_interest,establishment	Maps \| Website	(541) 788-6225	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 – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJOYjHWdAqv1QRZbzXuJ6MdlU	Smith Rock Coffee Roasters	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	point_of_interest,food,establishment	Maps \| Website	(541) 699-1964		View Photos (4)
ChIJeQE_c5kqv1QRNvA6yP2rCdE	Smith Rock Golf Course & Driving Range (edited)	1401 NE Maple Ave, Redmond, OR 97756, USA (edited)	44.2925930	-121.1515710	2,846 m		driving range (edited)	point_of_interest,establishment (edited)	Maps	(541) 923-3426		View Photos (4)
ChIJ-Qpo3IjWvlQR2k4osZpABfk	Smith Rock Group	Smith Rock Group, Oregon 97760, USA	44.3631550	-121.1479140	10,277 m		rock climbing	natural_feature,establishment	Maps			No photos available
ChIJNRyDaIjWvlQRVIFe3-jH69g	Smith Rock Peak/Point (edited)	Smith Rock, Oregon 97760, USA (edited)	44.3612310	-121.1495880	10,041 m		rock climbing (edited)	natural_feature,establishment (edited)	Maps			View Photos (4)
ChIJF3qCDnvWvlQRd8o4Qwdlu2c	Smith Rock Ranch (edited)	1250 NE Wilcox Ave, Terrebonne, OR 97760, USA (edited)	44.3552730	-121.1513700	9,364 m		tours,seasonal (edited)	point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 504-1414		View Photos (4)
ChIJHcjLKpLWvlQRl17g5s7mOGQ	Smith Rock State Park (edited)	Oregon 97760, USA (edited)	44.3682460	-121.1405810	10,959 m	recreation (edited)	point of interest, point-of-interest, rock climbing, state parks, tourist attraction, hiking, mountain biking (edited)	tourist_attraction,park,point_of_interest,establishment,hiking,mountain_biking (edited)	Maps \| Website (edited)	(800) 551-6949		No photos available
ChIJmwluEQbZvlQRj1kzGEwsj7k	Smith Rock Trail Rides	20890a NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides, tours	travel_agency,point_of_interest,establishment	Maps \| Website	(541) 604-6769	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJq4LmROkqv1QRlXojK1yuw7w	Sno-Cap Drive In Redmond (edited)	1053 NW 6th St, Redmond, OR 97756, USA (edited)	44.2863570	-121.1743480	1,528 m	restaurants (edited)	restaurants,lunch, lunch, restaurants (edited)	store,restaurant,point_of_interest,food,establishment (edited)	Maps \| Website (edited)	(541) 548-2343	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	No photos available
ChIJsWHRMI0qv1QRDAg2Iqp7fW8	Sonic Drive-In	500 NW Oak tree Ln, Redmond, OR 97756, USA	44.2942080	-121.1732480	2,401 m		bars	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 526-5855	View Hours Monday: 7:00 AM – 10:30 PM Tuesday: 7:00 AM – 10:30 PM Wednesday: 7:00 AM – 10:30 PM Thursday: 7:00 AM – 10:30 PM Friday: 7:00 AM – 11:30 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 10:30 PM	View Photos (4)
ChIJwR4Q3HXVuFQR3Z8mr4Xu-zA	Sora Sushi	3853 SW 21st St STE 109, Redmond, OR 97756, USA	44.2404830	-121.1939890	3,915 m		bars, pubs, restaurants	meal_takeaway,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 923-9867	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: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m		event venues	point_of_interest,establishment	Maps			No photos available
ChIJjc6HNScrv1QRO2xbroQsfac	Spudbowl City Park	SW 15th St @, SW Black Butte Blvd, Redmond, OR 97756, USA	44.2763720	-121.1840290	906 m		parks, playgrounds	park,point_of_interest,establishment	Maps		View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 6:30 AM – 9:00 PM Friday: 6:30 AM – 9:00 PM Saturday: 6:30 AM – 9:00 PM Sunday: 6:30 AM – 9:00 PM	View Photos (4)
ChIJm3h5Lysrv1QRPI5Q-Q6IvmU	St. Vincent De Paul Thrift Store	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		antiques, shopping, thrift stores, vintage	store,food,point_of_interest,establishment	Maps \| Website	(541) 504-9840	View Hours Monday: 9:00 AM – 6:00 PM 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 – 6:00 PM Sunday: Closed	View Photos (4)
ChIJkYRUxO4qv1QRtBbjiXCA4vk	Stack Park	820 NW Kingwood Pl, Redmond, OR 97756, USA	44.2871550	-121.1770800	1,636 m		parks, playgrounds, state parks	park,tourist_attraction,point_of_interest,establishment	Maps \| Website	(541) 548-7275	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)
ChIJC1sVINYqv1QRSsXG481xViY	Starbucks (edited)	944 SW 9th St, Redmond, OR 97756, USA (edited)	44.2675130	-121.1761350	595 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,store,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 504-5100	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJkQoHICUrv1QR7JDaRE-upUA	Starbucks	885 SW Rimrock Way, Redmond, OR 97756, USA	44.2689290	-121.1928500	1,562 m		bars, breakfast, coffee shops, shopping	cafe,restaurant,food,point_of_interest,store,establishment	Maps \| Website	(541) 548-9679	View Hours Monday: 4:30 AM – 7:30 PM Tuesday: 4:30 AM – 7:30 PM Wednesday: 4:30 AM – 7:30 PM Thursday: 4:30 AM – 7:30 PM Friday: 4:30 AM – 7:30 PM Saturday: 5:00 AM – 7:00 PM Sunday: 5:00 AM – 7:00 PM	View Photos (4)