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

Previous Next

Page 21 of 26

Showing 501 to 525 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJWTsCWK4rv1QRNy9lrY7mVhM	ROUX	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 408-8042	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJR2YSzywrv1QRFMFpi__40e4	Safeway Bakery	1705 S Hwy 97, Redmond, OR 97756, USA	44.2608850	-121.1794290	1,377 m		bakeries, bakeries,desserts, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-4160		View Photos (3)
ChIJRZ0iPggrv1QR1zjvtSQBcq0	Sally’s Wok	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		food trucks, food trucks,lunch,family friendly, 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: Closed 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)
ChIJo8UA8Nkqv1QRy-3yeNGt2dE	Salon Bliss	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2726920	-121.1745380	50 m		massage	establishment,hair_care,point_of_interest	Page \| Maps \| Website	(541) 604-5593	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJdQtQHycrv1QRo-jfyv_hXVY	Sam Johnson Park	333 SW 15th St, Redmond, OR 97756, USA	44.2723480	-121.1856900	937 m		family friendly,parks,playgrounds,state parks,rock climbing, 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 Ste C, Redmond, OR 97756, USA	44.2834850	-121.1736450	1,208 m		bars, bars,breakfast, breakfast, coffee shops, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-2442	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10: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		desserts,farmers markets,markets,farms,grocery stores,gift shops,shopping, 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,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, brewery,food trucks,family friendly, 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)
ChIJ69QfC5Esv1QRAQmDauRRwOU	Silverleaf Café	Eagle Crest Resort, 7535 Falcon Crest Dr #300, Redmond, OR 97756, USA	44.2626950	-121.2624850	7,138 m		breakfast	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-7558	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.2724340	-121.1715260	192 m		food trucks,markets,meat markets,smokehouses,restaurants,breakfast,lunch,shopping, 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)
ChIJjWniAXXRvlQRWcvSDXGcNMk	Skull Hollow Campground	Terrebonne, OR 97760, USA	44.3970400	-121.0630790	16,405 m		state parks	campground,establishment,lodging,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJI8dU-Nkqv1QR1hwSQKB8ors	Sky Hawk Ranch	6287 NE 33rd St, Redmond, OR 97756, USA	44.3280840	-121.1326930	6,986 m		horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 403-0195	View Hours Monday: 6:00 AM – 9:00 PM Tuesday: 6:00 AM – 9:00 PM Wednesday: 6:00 AM – 9:00 PM Thursday: 6:00 AM – 9:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 9: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)
ChIJTSyb43Arv1QRPGa-lYz-05M	Slice Pizza Co.	332 SW 5th St, Redmond, OR 97756, USA	44.2740610	-121.1729140	179 m		restaurants,lunch,dining,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 678-1108	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)
ChIJsfutgsUrv1QRyH1kInXquI0	Small Town Coffee Co.	900 NW Spruce Tree Pl, Redmond, OR 97756, USA	44.3020790	-121.1775090	3,288 m		coffee shops	cafe,establishment,food,point_of_interest	Page \| Maps \| Website	(971) 300-9469	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: Closed	View Photos (3)
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)