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: 17
Limit per Page: 25
Offset: 400
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 400, 25

Previous Next

Page 17 of 27

Showing 401 to 425 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJx2D2EdvbvlQRkV_VPctwijk	North Fishing Pier Day Use Area	FRWV+J9, Culver, OR 97734, USA	44.4965840	-121.1565010	24,942 m		fishing	point_of_interest,establishment	Maps			View Photos (3)
ChIJS-oIbN0rv1QRnIYsHn_X6A4	NorthFresh Sushi – Redmond	lunch (edited)	44.2723530	-121.1716650	182 m	restaurants (edited)	restaurants (edited)	restaurant,food,point_of_interest,establishment	Maps	dining (edited)	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 – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJGVZ-o2orv1QRGveWJw8yITw	Northstar Massage Therapy	716 SW 11th St, Redmond, OR 97756, USA	44.2703030	-121.1793770	505 m		massage	point_of_interest,establishment	Maps \| Website	(541) 815-0883	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 – 4:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJbbq2_PBRuVQRHxqDsh4jU_0	Ochoco Forest Camp Group Pavilion	Aud&Di Campground Service, 3160 NE 3rd St, Prineville, OR 97754, USA	44.3026800	-120.8092320	29,220 m		campgrounds	campground,park,lodging,point_of_interest,establishment	Maps \| Website	(541) 416-6500		View Photos (2)
ChIJCaAUkZM2uVQR3X4w_RRLZJ0	Ochoco Lake County Campgrounds	11700 N E Ochoco Hwy, Prineville, OR 97754, USA	44.3059710	-120.7010510	37,821 m		campgrounds, koa	campground,lodging,park,point_of_interest,establishment	Maps \| Website	(541) 447-2599		View Photos (4)
ChIJ9dKLt5U2uVQRM9auBvtxC7w	Ochoco Reservoir	Lake Front Ln, Prineville, OR 97754, USA	44.3043750	-120.7070010	37,333 m		campgrounds	campground,lodging,park,point_of_interest,establishment	Maps \| Website	(541) 447-1209		View Photos (4)
ChIJdT2UJdoqv1QRE_k8wwzeTfg	Odem Theater Pub (edited)	349 SW 6th St, Redmond, OR 97756, USA (edited)	44.2738220	-121.1745690	143 m		live music, live music,pubs,theatres, pubs, theatres, point of interest (edited)	restaurant,movie_theater,bar,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 425-1850		No photos available
ChIJr065mvrXvlQRnfwIkPJ3Pe0	Odin Falls Alpacas	9101 NW 31st St, Terrebonne, OR 97760, USA	44.3588330	-121.2052690	9,906 m		farms	point_of_interest,establishment	Maps \| Website	(541) 410-2324	View Hours Monday: 9:00 AM – 4:00 PM Tuesday: 9:00 AM – 4:00 PM Wednesday: 9:00 AM – 4:00 PM Thursday: 9:00 AM – 4:00 PM Friday: 9:00 AM – 4:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: 9:00 AM – 4:00 PM	No photos available
ChIJPdBp-tkqv1QR2NREwgiIowk	Oishi Redmond (edited)	511 SW 6th St Redmond, Oregon 97756 (edited)	44.2724710	-121.1745770	55 m	restaurants (edited)	dining, restaurants, lunch (edited)	dining,restaurants,lunch (edited)	Maps \| Website (edited)	(541) 548-3035	View Hours Monday: Closed Tuesday: 11:00 AM – 3:00 PM, 4:00 – 8:30 PM Wednesday: 11:00 AM – 3:00 PM, 4:00 – 8:30 PM Thursday: 11:00 AM – 3:00 PM, 4:00 – 8:30 PM Friday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Saturday: 12:00 – 3:00 PM, 4:00 – 8:30 PM Sunday: Closed	No photos available
ChIJj-lFjMnUuFQRE1lDZNBfR68	Ola’ Day Spa	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2520580	-121.1887000	2,572 m		massage, spas	hair_care,clothing_store,spa,beauty_salon,store,point_of_interest,establishment	Maps \| Website	(541) 504-5215	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	View Photos (4)
ChIJi01lkdsqv1QRgRhDS7YoyZI	One Street Down Cafe	124 SW 7th St, Redmond, OR 97756, USA	44.2760830	-121.1751470	397 m		bakeries, breakfast, coffee shops, lunch, restaurants	cafe,bakery,restaurant,food,point_of_interest,store,establishment	Maps \| Website	(541) 647-2341	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)
ChIJ4a5qy88qv1QROtr91A-aVVg	Opportunity Foundation	835 OR-126, Redmond, OR 97756, USA	44.2716820	-121.1615910	987 m		thrift stores	point_of_interest,establishment	Maps \| Website	(541) 548-2611	View Hours Monday: 6:30 AM – 6:00 PM Tuesday: 6:30 AM – 5:30 PM Wednesday: 6:30 AM – 6:00 PM Thursday: 6:30 AM – 6:00 PM Friday: 6:30 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJu7-NM84qv1QR_ncvUM9mTtk	Opportunity Foundation of Central Oregon Thrift Store	3294 S Hwy 97, Redmond, OR 97756, USA	44.2456620	-121.1885040	3,215 m		thrift stores, vintage	store,point_of_interest,establishment	Maps	(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	No photos available
ChIJCWSgmJQrv1QRvGaKKlPLFzU	Optimal Medicine	753 SW 11th St A, Redmond, OR 97756, USA	44.2697820	-121.1799000	571 m		wellness center	health,point_of_interest,establishment	Maps \| Website	(541) 728-0700	View Hours Monday: 8:00 AM – 4:30 PM Tuesday: 8:00 AM – 4:30 PM Wednesday: 8:00 AM – 4:30 PM Thursday: 8:00 AM – 4:30 PM Friday: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJd63umNYrv1QRqwZwuiHKU8E	Órale Street Tacos	652 NW 7th St, Redmond, OR 97756, USA	44.2818600	-121.1750010	1,031 m	food-trucks (edited)	food trucks (edited)	restaurant,point_of_interest,food,establishment	Maps \| Website	(541) 550-6237	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: Closed	View Photos (4)
ChIJmbBM85_duFQR8DqG6fWxp70	Oregon Badlands Wilderness	Oregon Badlands Wilderness, Bend, OR 97701, USA	44.0050390	-121.0066370	32,611 m	outdoors	hiking, point-of-interest	tourist_attraction,park,point_of_interest,establishment	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)
ChIJV4DGzCzhvlQRWUHAt7S5hxQ	Oregon HooDoos Trailhead	Montgomery Rd, Culver, OR 97734, USA	44.5752500	-121.4234860	39,053 m		hiking	park,point_of_interest,establishment	Maps	(208) 369-7822		View Photos (4)
ChIJvWZuOTC9uFQRjRJuzpU0XFc	Oregon Observatory	57245 River Rd, Sunriver, OR 97707, USA	43.8852940	-121.4477870	48,306 m	outdoors	hiking, point-of-interest	tourist_attraction,point_of_interest,establishment	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	point_of_interest,establishment	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, trailheads	tourist_attraction,park,point_of_interest,establishment	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, brewery, cocktails, family friendly, food trucks, nightlife, pool tables, pubs, wine bars	bar,point_of_interest,establishment	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: 11:00 AM – 9:00 PM	View Photos (4)
ChIJUcORo4HVuFQR036KcwxEaXo	Overland Expo Pacific Northwest	Mount Jefferson Dr, Redmond, OR 97756, USA	44.2372630	-121.1844730	4,020 m		rv parks	point_of_interest,establishment	Maps \| Website	(317) 207-2089	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 9:00 AM – 3:00 PM	View Photos (4)
ChIJewUv_tcqv1QRczCaMRNaZlI	Pacific Northwest Massage Therapy	716 SW 11th St #102, Redmond, OR 97756, USA	44.2702980	-121.1793560	504 m		massage	point_of_interest,establishment	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	natural_feature,establishment	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,park,lodging,point_of_interest,establishment	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)