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

Results:

Total Available Records: 645
Total After Limits: 645
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 375, 25

Previous Next

Page 16 of 26

Showing 376 to 400 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJo_N7si4rv1QRRIwX-feuOJY	Morning story	457 SW 6th St, Redmond, OR 97756, USA	44.2726900	-121.1744030	39 m		bakeries, bars,coffee shops,bakeries,desserts,grocery stores,breakfast,shopping, breakfast, coffee shops, desserts, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps	(541) 604-4551	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: Closed	View Photos (4)
ChIJn5ZcTszUuFQR2ahfHxUkIyE	Motel 6 Redmond, OR	2247 S Hwy 97, Redmond, OR 97756, USA	44.2557710	-121.1837020	2,029 m		hotels	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 442-4512	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)
ChIJ2Z5ETSGvuFQRBJrDIKwKQi4	Mount Bachelor	Mount Bachelor, Oregon 97703, USA	43.9791670	-121.6886110	52,463 m	outdoors	hiking, point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJBZpxAVUcvlQR6qmut8B2HYM	Mount Hood	Mt Hood, Oregon 97041, USA	45.3736150	-121.6959510	129,162 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJwcqgQs7XvlQRLaxNGkpwKu0	Mountain view equine	9201 NW 31st St, Terrebonne, OR 97760, USA	44.3589230	-121.2077040	9,966 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 661-6600	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: Closed	View Photos (1)
ChIJN784-ygrv1QR6VfDSnksqa0	MUSIC LIFE	232 SW 5th St, Redmond, OR 97756, USA	44.2749500	-121.1729040	271 m		live music	establishment,point_of_interest,school	Page \| Maps \| Website	(541) 527-4426	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: Closed	View Photos (4)
ChIJnzXXoykrv1QRsjlXApn38Q8	Namaspa Yoga & Massage	974 SW Veterans Way, Redmond, OR 97756, USA	44.2668470	-121.1791030	763 m		massage, spas	establishment,gym,health,point_of_interest	Page \| Maps \| Website	(541) 550-8550	View Hours Monday: 9:00 AM – 8:30 PM Tuesday: 9:00 AM – 6:30 PM Wednesday: 9:00 AM – 8:30 PM Thursday: 4:00 – 6:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 9:00 – 11:00 AM Sunday: 9:00 – 11:00 AM	View Photos (2)
ChIJFc5ze-LVuFQRn1IZM6ZulNE	Namson Asian Fusion	2498 S Hwy 97, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 336-9086	View Hours Monday: Closed 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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJcaIytCfVuFQRAGVip2NUV18	National Car Rental	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2527920	-121.1603590	2,455 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(844) 370-7399	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 1:00 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJMV-EKNDUuFQRSe25dKcl2z4	Neighborimpact – Supportive Services	S 1st St, Redmond, OR 97756, USA	44.2541530	-121.1706280	2,070 m		thrift stores	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 548-2380	View Hours Monday: 8:30 AM – 4:30 PM Tuesday: 8:30 AM – 4:30 PM Wednesday: 8:30 AM – 4:30 PM Thursday: 8:30 AM – 4:30 PM Friday: 8:30 AM – 4:30 PM Saturday: Closed Sunday: Closed	No photos available
ChIJxc5OK-gtv1QRqNEV0UDpCWw	NEK Farm & Pheasants	7117 SW Wickiup Ave, Redmond, OR 97756, USA	44.2490970	-121.2540620	6,897 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 728-7100	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJVV69zSkrv1QRqDtf9JojQwU	New York City Sub Shop Redmond	946 SW Veterans Way #103, Redmond, OR 97756, USA	44.2681780	-121.1779730	590 m		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		markets, markets,grocery stores,meat markets,shopping, 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)
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, koa	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 447-2599		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, live music, nightlife, pubs, 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		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, 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)