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: 16
Limit per Page: 25
Offset: 375
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 375, 25

Previous Next

Page 16 of 24

Showing 376 to 400 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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, 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)
ChIJo_3WpfTuvlQRNlQV7HJh2eU	Pelton Park	3300 NW Pelton Dam Rd, Madras, OR 97741, USA	44.6857110	-121.2370490	46,206 m	outdoors	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,park,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: 10:00 AM – 4:00 PM 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	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)
ChIJ3b8T0ZYrv1QRx88GFPBG6HA	Pink Sprinkled Bakery	858 NW Redwood Ave, Redmond, OR 97756, USA	44.3002400	-121.1773270	3,083 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 350-7954	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 – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ57m4d3wrv1QR2OOtqOYrRWk	Playground	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2674800	-121.1908150	1,461 m		playgrounds	establishment,point_of_interest	Page \| Maps			No photos available
ChIJpYNqfrnXvlQRmburndI6uw4	Playground (Rock climbing wall)	9980 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3653510	-121.1379480	10,701 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJ9csSlychuVQRhXmYz4C4QRc	Poison Butte Campground	OR-27, Prineville, OR 97754, USA	44.1204050	-120.7982720	34,399 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)
ChIJJ1BVuNkqv1QRWc322019HaA	Possibilities Thrift Store Redmond	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458090	-121.1885220	3,200 m		thrift stores, vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 3: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 (4)
ChIJMwqh-f4juVQRppulN5J4yqQ	Post Pile Campground	OR-27, Prineville, OR 97754, USA	44.1289380	-120.8005150	33,783 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)
ChIJRY2rOegqv1QRFZ-3n3VLS1E	Precious Curves	618 NW Hemlock Ave, Redmond, OR 97756, USA	44.2830840	-121.1747970	1,166 m		boutiques, thrift stores	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 639-2855	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	No photos available
ChIJ7wDCYTrTuFQRf_C6jwTzPZg	Precise Rifle Solutions	5637 SW Harvest Ave, Redmond, OR 97756, USA	44.2285230	-121.2360230	6,965 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 728-1952	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: Closed Sunday: Closed	No photos available
ChIJVVWxKksrv1QRks360QBDPPg	Prescott Honey	2668 SW Salmon Ave, Redmond, OR 97756, USA	44.2544860	-121.1988540	2,830 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 977-8848		No photos available
ChIJY7x3pWcrv1QRH7zW0Ps6WwM	Provisions Market at SCP Redmond	521 SW 6th St, Redmond, OR 97756, USA	44.2722780	-121.1745490	63 m		bakeries, breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 508-7600	View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJ_-zwLdBQv1QRYNW5J1HOkrk	Proxy Falls	Proxy Falls, Oregon 97413, USA	44.1617860	-121.9278260	61,332 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJp3WRIwAtuVQRqq2plUKH1Lk	Quadruple Bypass Trailhead – 66 Trail System	Crook County, OR 97754, USA	44.3039340	-120.8873490	23,075 m		mountain biking	establishment,park,point_of_interest	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)
ChIJvVgVBYkrv1QRTWxDHj7vyRY	Quartz Park	2027 SW Quartz Ave, Redmond, OR 97756, USA	44.2588760	-121.1902130	2,005 m		parks, playgrounds	establishment,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)