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

Previous Next

Page 19 of 29

Showing 451 to 475 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJvWZuOTC9uFQRjRJuzpU0XFc	Oregon Observatory at Sunriver Nature Center & Observatory	57245 River Rd, Sunriver, OR 97707, USA	43.8852940	-121.4477870	48,306 m	outdoors	hiking, point of interest	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 593-4394	View Hours Monday: Closed Tuesday: Closed Wednesday: 10:00 AM – 3:00 PM, 7:00 – 8:30 PM Thursday: 10:00 AM – 3:00 PM Friday: 10:00 AM – 3:00 PM Saturday: 10:00 AM – 3:00 PM, 7:00 – 8:30 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJm2nNEdoqv1QRSqOJnffpC1o	Oregon Party Rentals	1950 SW Badger Ave STE 104, Redmond, OR 97756, USA	44.2379190	-121.1897970	4,060 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-5500	View Hours Monday: 10:00 AM – 6:00 PM 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 – 3:00 PM Sunday: Closed	No photos available
ChIJdf5tV9fYvlQR3duwvZlmrSI	Otter Bench Trailhead	11185 SW Horny Hollow Trail, Terrebonne, OR 97760, USA	44.4625810	-121.2829140	22,830 m		hiking, hiking,trailheads,hiking,trailheads, trailheads	establishment,point_of_interest,tourist_attraction	Page \| Maps		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)
ChIJ9TGCT4Urv1QRVIES0CnilQc	Otto’s Landing	652 NW 7th St, Redmond, OR 97756, USA	44.2818360	-121.1750230	1,028 m		bars, bars,cocktails,nightlife,pool tables,bars,cocktails,nightlife,pool tables,pubs,brewery,food trucks,restaurants,dining,family friendly,family fun, brewery, cocktails, food trucks, microbrewery, nightlife, pool tables, pubs	bar,establishment,food,liquor_store,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 699-1307	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: 10:00 AM – 9:00 PM	View Photos (4)
ChIJmSqPNeErv1QRhgeicmrt340	P!ZZA – REDMOND	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		live music, live music,lunch,restaurants, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 634-2947	View Hours Monday: Closed 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	View Photos (4)
ChIJewUv_tcqv1QRczCaMRNaZlI	Pacific Northwest Massage Therapy	716 SW 11th St #102, Redmond, OR 97756, USA	44.2702970	-121.1793560	504 m		massage	establishment,point_of_interest	Page \| Maps	(541) 598-5541	View Hours Monday: 9:30 AM – 12:00 PM Tuesday: 2:00 – 5:30 PM Wednesday: 9:30 AM – 5:30 PM Thursday: Closed Friday: Closed Saturday: 9:30 AM – 4:00 PM Sunday: Closed	No photos available
ChIJZf5BqxwFvFQRWHHAosT_saE	Painted Hills	Painted Hills, Oregon 97750, USA	44.6615220	-120.2730730	83,548 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJYbd4bq4muVQRx-ZgTg9MOv8	Palisades Campground	Palisades Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1315820	-120.8221660	32,127 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(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)
ChIJASrA_Ngrv1QRuWqXqKEyyqg	Panaderia y Pasteleria el Moy #2	520 NW Greenwood Ave, Redmond, OR 97756, USA	44.2818010	-121.1737590	1,021 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 516-0961	View Hours Monday: 7:00 AM – 9:00 PM Tuesday: 7:00 AM – 9:00 PM Wednesday: 7:00 AM – 9:00 PM Thursday: 7:00 AM – 9:00 PM Friday: 7:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 9:00 PM	No photos available
ChIJUWGjFY0qv1QRnZppSKZrHjg	Panda Express	455 NW Oak tree Ln, Redmond, OR 97756, USA	44.2943280	-121.1718920	2,419 m		dining	establishment,food,meal_delivery,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-1968	View Hours Monday: 9:30 AM – 10:00 PM Tuesday: 9:30 AM – 10:00 PM Wednesday: 9:30 AM – 10:00 PM Thursday: 9:00 AM – 10:30 PM Friday: 9:00 AM – 11:00 PM Saturday: 9:00 AM – 10:30 PM Sunday: 9:30 AM – 10:00 PM	View Photos (4)
ChIJlaawUQArv1QRkKMYlaUhOHI	Pangaea Guild Hall – Coffee and Cocktails	652 SW 6th St, Redmond, OR 97756, USA	44.2707520	-121.1739710	208 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,coffee shops,lunch,family friendly,shopping,bars,cocktails,nightlife,pubs,coffee shops,lunch,family friendly, cocktails, coffee shops, family friendly, lunch, nightlife, pubs, shopping	bar,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-7641	View Hours Monday: Closed Tuesday: 5:00 – 10:00 PM Wednesday: 5:00 – 10:00 PM Thursday: 5:00 – 10:00 PM Friday: 5:00 – 11:00 PM Saturday: 9:00 AM – 11:00 PM Sunday: 9:00 AM – 10:00 PM	View Photos (4)
ChIJW1npeO0qv1QRcPpmGIWJAVQ	Pappy’s Pizzeria	1655 NW 6th St, Redmond, OR 97756, USA	44.2913350	-121.1744830	2,081 m		restaurants	establishment,food,meal_delivery,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-1118	View Hours Monday: 11:00 AM – 11:00 PM Tuesday: 11:00 AM – 11:00 PM Wednesday: 11:00 AM – 11:00 PM Thursday: 11:00 AM – 11:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 11:00 PM	View Photos (4)
ChIJ9_Ctmrsrv1QRLVS7YZi-VNk	Parker Eventing	8515 W Antler Ave, Redmond, OR 97756, USA	44.2785900	-121.2740100	7,996 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 771-2031	View Hours Monday: Closed 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: Closed	No photos available
ChIJ8fz7agDRvlQRW-nEAPJBwuk	Parking for The Zoo	9WX2+WQ, Terrebonne, OR 97760, USA	44.3997850	-121.0980350	15,374 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (2)
ChIJ6YJIBI0rv1QRZzHEIwbumwA	Parking Lot for Playground	401 SW 15th St, Redmond, OR 97756, USA	44.2730740	-121.1844370	839 m		parks, playgrounds	establishment,park,point_of_interest	Page \| Maps			View Photos (2)
ChIJ2duG4fEqv1QRuOdOz8cwD8I	Paul Hathaway Memorial Park	1021 NW Rockcrest Ct, Redmond, OR 97756, USA	44.2906730	-121.1800210	2,065 m	outdoors	parks, parks,hiking, point of interest	establishment,park,point_of_interest	Page \| 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: 7:00 AM – 9:30 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)
ChIJ1VfCqzePuFQRm_qLJANFiLU	Paulina Lake Hot Spring	Little Crater Campground, La Pine, OR 97739, USA	43.7320950	-121.2523330	60,430 m	outdoors	point of interest	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJ31fYgcArv1QRqIg6Swoh9jk	Peak Wellness Services	128 W Antler Ave, Redmond, OR 97756, USA	44.2762570	-121.1696440	529 m		wellness center	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 640-3031	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: Closed Saturday: Closed Sunday: Closed	View Photos (3)
ChIJo_3WpfTuvlQRNlQV7HJh2eU	Pelton Park	3300 NW Pelton Dam Rd, Madras, OR 97741, USA	44.6857110	-121.2370490	46,206 m	outdoors	campgrounds, hiking, point of interest	establishment,park,point_of_interest	Page \| Maps \| Website	(503) 464-8515	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: Closed Sunday: Closed	View Photos (4)
ChIJH-2Di44rv1QRcyiyaqpe1xg	Penske Truck Rental	3920 US-97, Redmond, OR 97756, USA	44.3114250	-121.1711430	4,321 m		car rentals	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 699-3244	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:00 AM – 5:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: Closed	View Photos (1)
ChIJQ53B0SfivlQRCroFzC_DOeA	Perry South Campground	Montgomery Rd, Culver, OR 97734, USA	44.5848450	-121.4475810	40,958 m		campgrounds	campground,establishment,lodging,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (4)
ChIJP0JN4abXvlQRB87qXcM_mOs	Peter Skene Ogden State Scenic Viewpoint	US-97, Terrebonne, OR 97760, USA	44.3912060	-121.1933420	13,276 m	outdoors	point of interest, state parks	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949	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: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJsX15N_LSuFQRyKuyO3eC6NY	Petersen Rock Garden & Museum	7930 SW 77th St, Redmond, OR 97756, USA	44.2033160	-121.2622450	10,435 m		tourist attraction	establishment,museum,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 904-0557	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJhw_qYcIqv1QRWH7G1p2L4aE	Physical Justice House of Healing	654 NW 4th St, Redmond, OR 97756, USA	44.2818720	-121.1718560	1,042 m		massage, massage,spas	establishment,health,point_of_interest	Page \| Maps	(541) 280-2535	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 3:00 PM Friday: 11:00 AM – 3:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJIy3nywTGuFQRnE_rjHPpr8U	Pilot Butte	Pilot Butte, Bend, OR 97701, USA	44.0606730	-121.2833640	25,132 m	outdoors (edited)	point of interest (edited)	establishment,natural_feature	Page \| Maps			View Photos (4)