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: 23
Limit per Page: 25
Offset: 550
Total Pages: 29

Results:

Total Available Records: 705
Total After Limits: 705
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 550, 25

Previous Next

Page 23 of 29

Showing 551 to 575 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJPW6bz0vVuFQRxv7b6MYKgQY	Ross Dress for Less	1629 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2537490	-121.1856800	2,298 m		shopping	clothing_store,department_store,establishment,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 548-5008	View Hours Monday: 9:30 AM – 9:30 PM Tuesday: 9:30 AM – 9:30 PM Wednesday: 9:30 AM – 9:30 PM Thursday: 9:30 AM – 9:30 PM Friday: 9:00 AM – 10:00 PM Saturday: 9:00 AM – 10:00 PM Sunday: 9:00 AM – 9:00 PM	View Photos (4)
ChIJWTsCWK4rv1QRNy9lrY7mVhM	ROUX	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks, food trucks,dining	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,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		family friendly, food trucks, food trucks,lunch,family friendly,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: 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, family friendly,parks,playgrounds,state parks,rock climbing,family friendly,parks,playgrounds,state parks,rock climbing,tourist attraction, parks, playgrounds, rock climbing, state parks	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)
ChIJNQgfba3VuFQRQrcjpDl_qF8	Samurai’s	2332 S Hwy 97, Redmond, OR 97756, USA	44.2542020	-121.1819600	2,146 m		vintage	establishment,point_of_interest,store	Page \| Maps	(458) 899-5840	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM 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)
ChIJMc0Duukqv1QRHNrcMeHFBnY	Sassy’s Cafe	843 NW 5th St Ste C, Redmond, OR 97756, USA	44.2834850	-121.1736450	1,208 m		bars, bars,breakfast,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, desserts,farmers markets,markets,farms,grocery stores,gift shops,shopping,desserts,farmers markets,markets,farms,grocery stores,gift shops, farmers markets, farms, gift shops, grocery stores, markets, meat markets, shopping	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)
ChIJS_7xMQArv1QRv6i2qgTHST0	Shady Grove Park	735 NW Greenwood Ave, Redmond, OR 97756, USA	44.2824780	-121.1758890	1,107 m		rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps			No photos available
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,brewery,food trucks,family friendly, dining, family friendly, 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, breakfast,live music,pubs,breakfast, live music, pubs	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, campgrounds,koa	campground,establishment,lodging,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		breakfast, dining, food trucks, food trucks,markets,meat markets,smokehouses,restaurants,breakfast,lunch,shopping,markets,meat markets,smokehouses,dining,shopping, grocery stores, lunch, markets, meat markets, restaurants, shopping, 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)
ChIJ-6saQsswv1QRxtbWAN2RoFM	Sisters Mobile Home Park	1100 US-20, Sisters, OR 97759, USA	44.2863040	-121.5342790	28,728 m		koa	establishment,lodging,point_of_interest,rv_park	Page \| Maps	(541) 549-3861		View Photos (4)
ChIJjWniAXXRvlQRWcvSDXGcNMk	Skull Hollow Campground	Terrebonne, OR 97760, USA	44.3970400	-121.0630790	16,405 m		state parks, state parks,campgrounds	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		dining, family friendly, lunch, restaurants, restaurants,lunch,dining,family friendly,restaurants,lunch,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)