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

Previous Next

Page 19 of 24

Showing 451 to 475 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJRZ0iPggrv1QR1zjvtSQBcq0	Sally’s Wok	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 815-5006	View Hours Monday: 11:30 AM – 8:00 PM Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: Closed Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 8:00 PM	View Photos (4)
ChIJdQtQHycrv1QRo-jfyv_hXVY	Sam Johnson Park	333 SW 15th St, Redmond, OR 97756, USA	44.2723480	-121.1856900	937 m		parks, playgrounds	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 504-2000	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (4)
ChIJMc0Duukqv1QRHNrcMeHFBnY	Sassy’s Cafe	843 NW 5th St Suite C, Redmond, OR 97756, USA	44.2834850	-121.1736450	1,208 m		bars, breakfast, coffee shops, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-2442	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 11:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 10:00 PM	View Photos (4)
ChIJX4VPJiYrv1QR9fzg60yjcvA	Schoolhouse Produce	1430 SW Highland Ave, Redmond, OR 97756, USA	44.2693440	-121.1837840	866 m		farmers markets, grocery stores, markets, meat markets	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 504-7112	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: 10:00 AM – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJfWJrLE3fvlQRUtLUeU5wvKE	Scout Camp Trailhead	9505-9445 SW Scout Camp Trail, Terrebonne, OR 97760, USA	44.4610710	-121.3214640	24,014 m		hiking	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)
ChIJvZA_fkMrv1QRZXuft3Gmi40	SCP Redmond Hotel (edited)	521 SW 6th St Ste 100, Redmond, OR 97756, USA (edited)	44.2722780	-121.1745490	63 m	hotels-motels (edited)	hotels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(866) 627-8345	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)
ChIJw0-syFIrv1QR9Fga5G95FIw	Shawn’s Jamaican Vybz	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks	establishment,food,point_of_interest	Page \| Maps	(541) 508-2391	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 12:00 – 8:00 PM Friday: 12:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJdyi79YDIuFQRRQuegdHxorY	Shred Town Food Truck	Wild Ride Brewing, 332 SW 5th St, Redmond, OR 97756, USA	44.2739980	-121.1728980	174 m		brewery, dining, food trucks, juice bars, lunch, restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 640-9453	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)
ChIJ69QfC5Esv1QR833VW7H6Fus	Silver Leaf Market	7535 Falcon Crest Dr # 200, Redmond, OR 97756, USA	44.2628170	-121.2624180	7,130 m		grocery stores, markets, shopping	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps	(541) 526-5009	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9: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 – 9:00 PM	View Photos (4)
ChIJWYQa6Rorv1QR2r4WWx8LDAk	Sinclair Gas Station	712 SW 5th St, Redmond, OR 97756, USA	44.2702440	-121.1730240	274 m		grocery stores	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps \| Website	(541) 504-7829	View Hours Monday: 5:30 AM – 12:00 PM Tuesday: 5:30 AM – 12:00 PM Wednesday: 5:30 AM – 12:00 PM Thursday: 5:30 AM – 12:00 PM Friday: 5:30 AM – 12:00 PM Saturday: 5:30 AM – 12:00 PM Sunday: 5:30 AM – 12:00 PM	View Photos (4)
ChIJfZnhGwDVuFQRzoUj_Sgn8sw	Sisters Coffee Shop	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530530	-121.1606580	2,419 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| 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,establishment,lodging,park,point_of_interest	Page \| 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		grocery stores, lunch, markets, meat markets, smokehouses	establishment,food,point_of_interest,restaurant,store	Page \| 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)
ChIJT2v8ufIqv1QRsQHaL9WVENM	Sleep Inn & Suites Redmond	1847 NW 6th St, Redmond, OR 97756, USA	44.2930710	-121.1748130	2,275 m	hotels-motels (edited)	hotels (edited)	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 516-6269		View Photos (4)
ChIJNRyDaIjWvlQRVIFe3-jH69g	Smith Rock	Smith Rock, Oregon 97760, USA	44.3612310	-121.1495880	10,041 m		rock climbing	establishment,natural_feature	Page \| 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)	Page \| 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	establishment,point_of_interest	Page \| 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	establishment,point_of_interest,school	Page \| 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	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 699-1964		View Photos (4)
ChIJeQE_c5kqv1QRNvA6yP2rCdE	Smith Rock Golf Course & Driving Range	1401 NE Maple Ave, Redmond, OR 97756, USA	44.2925930	-121.1515710	2,846 m		driving range	establishment,point_of_interest	Page \| Maps	(541) 923-3426		View Photos (4)
ChIJHcjLKpLWvlQRl17g5s7mOGQ	Smith Rock State Park	Oregon 97760, USA	44.3682460	-121.1405810	10,959 m	outdoors	point of interest, point-of-interest, rock climbing, state parks, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJmwluEQbZvlQRj1kzGEwsj7k	Smith Rock Trail Rides	20890a NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| 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	1053 NW 6th St, Redmond, OR 97756, USA	44.2863570	-121.1743480	1,528 m		bars, desserts, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJsWHRMI0qv1QRDAg2Iqp7fW8	Sonic Drive-In	500 NW Oak tree Ln, Redmond, OR 97756, USA	44.2942080	-121.1732480	2,401 m		bars	establishment,food,point_of_interest,restaurant	Page \| 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:00 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	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| 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)