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: 18
Limit per Page: 25
Offset: 425
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 425, 25

Previous Next

Page 18 of 29

Showing 426 to 450 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJVV69zSkrv1QRqDtf9JojQwU	New York City Sub Shop Redmond	946 SW Veterans Way #103, Redmond, OR 97756, USA	44.2681780	-121.1779730	590 m		family friendly, lunch, lunch,family friendly	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4400	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 – 6:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJn0EJ6w-RuFQRiuPCpdLD-YA	Newberry National Volcanic Monument	Bend, OR 97702, USA	43.9098550	-121.3568950	42,903 m	outdoors	hiking, point of interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 383-5300	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: 9:00 AM – 5:00 PM	View Photos (4)
ChIJ69QfC5Esv1QRnRVhLGWGHi0	Niblick & Greene’s	restaurants (edited)	44.2629500	-121.2623320	7,121 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJXbFHJCUrv1QRLDjb_Nxn8wY	Nolan Town Center	782 SW Rimrock Way, Redmond, OR 97756, USA	44.2685070	-121.1929330	1,581 m		grocery stores, markets, markets,grocery stores,meat markets,shopping,markets,grocery stores,meat markets,shopping, meat markets, shopping	establishment,point_of_interest,shopping_mall	Page \| Maps		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: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJk3_cYywsv1QRzU90a7sU3_Q	North Barr Trailhead	Barr Rd, Redmond, OR 97756, USA	44.2878050	-121.3361850	13,027 m		trailheads	establishment,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)
ChIJx2D2EdvbvlQRkV_VPctwijk	North Fishing Pier Day Use Area	FRWV+J9, Culver, OR 97734, USA	44.4965840	-121.1565010	24,942 m		fishing	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJ6_QlGwDXvlQR-7-X91De0hY	North Point trail	9VC8+HF, Terrebonne, OR 97760, USA	44.3714780	-121.1337890	11,447 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJS-oIbN0rv1QRnIYsHn_X6A4	NorthFresh Sushi – Redmond	lunch (edited)	44.2723530	-121.1716650	182 m	restaurants (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| 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	establishment,point_of_interest	Page \| 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,establishment,lodging,park,point_of_interest	Page \| 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, campgrounds,koa, koa	campground,establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 447-2599		View Photos (4)
ChIJq9d5BljXuFQRGOUAYsCE_vo	Octane Adventures – Hidden Canyon ATV Tours	17037 Alfalfa Rd, Powell Butte, OR 97753, USA	44.1504500	-121.0431540	17,122 m		tours	establishment,point_of_interest,store,tourist_attraction,travel_agency	Page \| Maps \| Website	(541) 204-4044	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)
ChIJdT2UJdoqv1QRE_k8wwzeTfg	Odem Theater Pub	349 SW 6th St, Redmond, OR 97756, USA	44.2738220	-121.1745690	143 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,theatres,bars,cocktails,live music,nightlife,pubs,restaurants,dining,theatres,vintage, cocktails, dining, live music, nightlife, pubs, restaurants, theatres	bar,establishment,food,movie_theater,point_of_interest,restaurant	Page \| Maps \| Website	(541) 425-1850		View Photos (4)
ChIJr065mvrXvlQRnfwIkPJ3Pe0	Odin Falls Alpacas	9101 NW 31st St, Terrebonne, OR 97760, USA	44.3588330	-121.2052690	9,906 m		farms	establishment,point_of_interest	Page \| Maps \| Website		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	511 SW 6th St, Redmond, OR 97756, USA	44.2724710	-121.1745770	55 m		dining, family friendly, lunch, restaurants, restaurants,lunch,dining,family friendly,restaurants,lunch,dining,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3035	View Hours Monday: Closed Tuesday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Wednesday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Thursday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Friday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Saturday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJj-lFjMnUuFQRE1lDZNBfR68	Ola’ Day Spa	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2520580	-121.1887000	2,572 m		massage, massage,spas, spas	beauty_salon,clothing_store,establishment,hair_care,point_of_interest,spa,store	Page \| 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)
ChIJEWBDJH0rv1QRz0lZhoyJid4	Ollie’s Kitchen	1205 SW Indian Ave, Redmond, OR 97756, USA	44.2687670	-121.1810590	712 m		desserts, desserts,lunch,desserts,lunch, lunch	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-5207	View Hours Monday: 7:30 AM – 6:00 PM Tuesday: 7:30 AM – 6:00 PM Wednesday: 7:30 AM – 6:00 PM Thursday: 7:30 AM – 6:00 PM Friday: 7:30 AM – 6: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, coffee shops,bakeries,desserts,restaurants,breakfast,lunch,dining,family friendly,shopping,coffee shops,bakeries,desserts, desserts, dining, family friendly, lunch, restaurants, shopping	bakery,cafe,establishment,food,point_of_interest,restaurant,store	Page \| 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	establishment,point_of_interest	Page \| 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.2457250	-121.1885150	3,209 m		antiques, antiques,thrift stores,antiques,thrift stores,vintage, thrift stores	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	No photos available
ChIJCWSgmJQrv1QRvGaKKlPLFzU	Optimal Medicine	753 SW 11th St A, Redmond, OR 97756, USA	44.2697820	-121.1799000	571 m		wellness center	establishment,health,point_of_interest	Page \| 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)	establishment,food,point_of_interest,restaurant	Page \| 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)
ChIJDTn_Z9Aqv1QRI4jRVOJEzsY	Orchard Grass Hay and Lambs	126 OR-126, Redmond, OR 97756, USA	44.2725760	-121.1682870	449 m		farms	establishment,point_of_interest	Page \| Maps \| Website			No photos available
ChIJmbBM85_duFQR8DqG6fWxp70	Oregon Badlands Wilderness	Oregon Badlands Wilderness, Bend, OR 97701, USA	43.9571920	-121.0481800	36,482 m	outdoors	hiking, point of interest	establishment,park,point_of_interest,tourist_attraction	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)
ChIJV4DGzCzhvlQRWUHAt7S5hxQ	Oregon HooDoos Trailhead	Montgomery Rd, Culver, OR 97734, USA	44.5752500	-121.4234860	39,053 m		hiking	establishment,park,point_of_interest	Page \| Maps	(208) 369-7822		View Photos (4)