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

Previous Next

Page 21 of 27

Showing 501 to 525 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJO9bp6CUrv1QRFVLllXuFzcU	Rimrock Taphouse	845 SW 17th St #301, Redmond, OR 97756, USA	44.2690360	-121.1877580	1,172 m		bars, brewery, cocktails, live music, microbrewery, nightlife, pubs	bar,point_of_interest,establishment	Maps \| Website	(541) 923-4200	View Hours Monday: 4:00 – 9:00 PM Tuesday: 11:30 AM – 9:00 PM Wednesday: 11:30 AM – 9:00 PM Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 10:00 PM Saturday: 11:30 AM – 10:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJRw2vlg0rv1QRloYN5KHRyLc	Rincón Azteca A Family Mexican Cuisine	526 SW 6th St, Redmond, OR 97756, USA	44.2721350	-121.1739750	54 m		cocktails, dining, family friendly, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 548-4084	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ9U43ktnUuFQRNyqGzqNgwdw	Risse Racing Technology, Inc.	2237 SW 2nd Ct Suite C, Redmond, OR 97756, USA	44.2550200	-121.1716250	1,966 m		mountain biking	point_of_interest,establishment	Maps \| Website	(541) 526-7242	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ50R7asnUuFQRASnSRNfcsnM	Rite Aid	1514 SW Highland Ave, Redmond, OR 97756, USA	44.2690540	-121.1849860	966 m		coffee shops	drugstore,convenience_store,store,food,health,point_of_interest,establishment	Maps \| Website	(541) 548-6041	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: 9:00 AM – 8:00 PM	View Photos (4)
ChIJ41tFB4kXv1QRiVae7AA9LZg	Riverside Campground	12500 SW River Rd, Camp Sherman, OR 97730, USA	44.4414740	-121.6335990	41,087 m		campgrounds	campground,park,lodging,point_of_interest,establishment	Maps \| Website			View Photos (3)
ChIJ1Y53bSYrv1QRaLsl31PGYBU	Robin E. Meyer, LMT, CA	1655 SW Highland Ave Suite 1, Redmond, OR 97756, USA	44.2698320	-121.1864260	1,043 m		massage	doctor,health,point_of_interest,establishment	Maps	(541) 923-2019	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJpYNqfrnXvlQRmburndI6uw4	Rock Climbing Wall	9980 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3653510	-121.1379480	10,701 m		rock climbing	point_of_interest,establishment	Maps			View Photos (4)
ChIJbR7994TWvlQRQpVVgo2nlx0	Rockhard	9297 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606920	-121.1385530	10,189 m		shopping	store,food,point_of_interest,establishment	Maps	(541) 788-6225	View Hours Monday: 12:00 – 6:00 PM Tuesday: 12:00 – 6:00 PM Wednesday: 12:00 – 6:00 PM Thursday: 12:00 – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 12:00 – 6:00 PM Sunday: 12:00 – 6:00 PM	View Photos (4)
ChIJHS-Sc48rv1QRKmMuwNSdYqw	Rockin’ Roasters	122 SW 5th St, Redmond, OR 97756, USA	44.2760710	-121.1729900	391 m		coffee shops	cafe,store,food,point_of_interest,establishment	Maps \| Website		View Hours Monday: Closed Tuesday: 7:00 AM – 3:00 PM Wednesday: 7:00 AM – 3:00 PM Thursday: 7:00 AM – 3:00 PM Friday: 7:00 AM – 3:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4:00 PM	View Photos (4)
ChIJk3fm8YIrv1QRSgYR27_MrI0	Rod’s Quality Meats	323 NW 6th St, Redmond, OR 97756, USA	44.2786440	-121.1745120	671 m		meat markets	store,food,point_of_interest,establishment	Maps \| Website	(541) 516-0733	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJWTsCWK4rv1QRNy9lrY7mVhM	ROUX	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714150	-121.1723010	186 m		food trucks	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 213-5237	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:30 PM Saturday: 11:00 AM – 8:30 PM Sunday: 11:00 AM – 8:30 PM	View Photos (4)
ChIJ9UgBpofYvlQR33onOd6SDmM	Ryan’s Produce	451 NW 5th St, Redmond, OR 97756, USA	44.2796900	-121.1734850	787 m		farmers markets, grocery stores	grocery_or_supermarket,food,point_of_interest,store,establishment	Maps	(541) 923-2081	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: Closed	No photos available
ChIJSxaI0ywrv1QR4Jkdxy6TfMI	Safeway	1705 S Hwy 97, Redmond, OR 97756, USA	44.2607570	-121.1796260	1,395 m		bakeries, coffee shops, desserts, grocery stores, juice bars, meat markets, shopping	grocery_or_supermarket,florist,supermarket,bakery,store,food,point_of_interest,establishment	Maps \| Website	(541) 504-4160	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJR2YSzywrv1QRFMFpi__40e4	Safeway Bakery	1705 S Hwy 97, Redmond, OR 97756, USA	44.2608850	-121.1794290	1,377 m		bakeries, desserts	bakery,food,store,point_of_interest,establishment	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, lunch, restaurants	restaurant,food,point_of_interest,establishment	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 (edited)	333 SW 15th St, Redmond, OR 97756, USA (edited)	44.2723480	-121.1856900	937 m	recreation (edited)	parks, parks,playgrounds, playgrounds, point of interest (edited)	park,tourist_attraction,point_of_interest,establishment (edited)	Maps \| Website (edited)	(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	No photos available
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, dining, lunch, restaurants	restaurant,food,point_of_interest,establishment	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 – 10:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 11: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, food trucks, gift shops, grocery stores, markets, meat markets	grocery_or_supermarket,point_of_interest,food,store,establishment	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: Closed	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	park,point_of_interest,establishment	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)	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)
ChIJA5PovIEsvFQRb1QbxDjQfc0	Shaniko	Shaniko, OR 97037, USA	45.0037360	-120.7522670	87,875 m	recreation	point of interest	locality,political	Maps \| Website			View Photos (4)
ChIJI4-4HWHTuFQRHm41YREKmao	Shannon Development Corporation	6100 S Hwy 97, Redmond, OR 97756, USA	44.2211140	-121.2096900	6,397 m		rv parks	rv_park,lodging,point_of_interest,establishment	Maps	(541) 923-4104		No photos available
ChIJdyi79YDIuFQRRQuegdHxorY	Shred Town Food Truck (edited)	Wild Ride Brewing, 332 SW 5th St, Redmond, OR 97756, USA (edited)	44.2739980	-121.1728980	174 m	food-trucks (edited)	brewery, brewery,food trucks,restaurants,lunch,dining, dining, food trucks, lunch, restaurants (edited)	meal_takeaway,restaurant,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(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	No photos available
ChIJ69QfC5Esv1QR833VW7H6Fus	Silver Leaf Market	7535 Falcon Crest Dr # 200, Redmond, OR 97756, USA	44.2628170	-121.2624180	7,130 m		grocery stores, markets, shopping	grocery_or_supermarket,store,food,point_of_interest,establishment	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	gas_station,convenience_store,store,food,point_of_interest,establishment	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)