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: 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 375, 25

Previous Next

Page 16 of 27

Showing 376 to 400 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJqXlEJUwrv1QRq83Kacpsdcs	Mi Placita	Mi Placita LLC, 340 NW 5th St, Redmond, OR 97756, USA	44.2784640	-121.1728970	655 m		dining, family friendly, lunch	restaurant,food,point_of_interest,establishment	Maps	(541) 527-1338	View Hours Monday: 10:00 AM – 8:00 PM Tuesday: 10:00 AM – 8:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 9:00 PM Saturday: 10:00 AM – 9:00 PM Sunday: 10:00 AM – 9:00 PM	View Photos (4)
ChIJIcsYuMsrv1QR4N1YCgkb4Aw	Mickey’s Adventures	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores	book_store,store,point_of_interest,establishment	Maps	(206) 228-3155	View Hours Monday: 9:30 AM – 5:00 PM Tuesday: 9:30 AM – 5:00 PM Wednesday: 9:30 AM – 5:00 PM Thursday: 9:30 AM – 5:00 PM Friday: 9:30 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJo9PM7ZLWvlQRc4ahlE6wvC0?	Misery Ridge Trail (edited)	Misery Ridge Trail, Oregon 97760, USA	44.3695500	-121.1414740	11,083 m	outdoors (edited)	hiking, point of interest (edited)	hiking,point_of_interest (edited)	Maps			No photos available
ChIJwzUf4i4rv1QR2gC0jG6ZtCo	Mo’s Egg House	950 SW Veterans Way, Redmond, OR 97756, USA	44.2674830	-121.1788790	694 m		breakfast	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 527-4314	View Hours Monday: 6:30 AM – 2:00 PM Tuesday: 6:30 AM – 2:00 PM Wednesday: 6:30 AM – 2:00 PM Thursday: 6:30 AM – 2:00 PM Friday: 6:30 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJ16Klq9Aqv1QRQyXRIHHgqsY	Moe’s Food Mart	516 SW 5th St, Redmond, OR 97756, USA	44.2722970	-121.1728730	91 m		grocery stores	convenience_store,gas_station,food,store,point_of_interest,establishment	Maps	(541) 548-1225	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: 7:00 AM – 9:00 PM	View Photos (3)
ChIJhRGGHFMrv1QRVAiRX-p6-lQ	Molly McKee-Nickson Massage	2337 SW Valleyview Dr, Redmond, OR 97756, USA	44.2539880	-121.2100860	3,548 m		massage	point_of_interest,establishment	Maps \| Website	(541) 490-0865	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: Closed Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (3)
ChIJYfRBprTZvlQRzJOpZP1z9-M	Mom’s Kitchen Catering Co.	528 SW 6th St, Redmond, OR 97756, USA	44.2720480	-121.1740020	64 m		desserts	food,point_of_interest,establishment	Maps \| Website	(541) 213-9696	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJaSOyOwMrv1QRMVWraykHxVU	MoneyGram	944 SW Veterans Way, Redmond, OR 97756, USA	44.2672980	-121.1763060	622 m		grocery stores	finance,point_of_interest,establishment	Maps \| Website	(541) 504-5100	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 11:00 PM	No photos available
ChIJW8fF4LbXvlQR2BYeQWfHhXQ	Monkey Face	Misery, Ridge Trail, Terrebonne, OR 97760, USA	44.3701150	-121.1426570	11,123 m		rock climbing	point_of_interest,establishment	Maps			View Photos (4)
ChIJo9PM7ZLWvlQRc4ahlE6wvC0	Monkey Face	Monkey Face, Oregon 97760, USA	44.3706220	-121.1440460	11,153 m		rock climbing	natural_feature,establishment	Maps			View Photos (4)
ChIJu8dWDo7WvlQRLOxgmFG-9fQ	Morning Glory Wall	Morning Glory Wall, Oregon 97760, USA	44.3669450	-121.1435740	10,763 m		rock climbing	natural_feature,establishment	Maps			No photos available
ChIJo_N7si4rv1QRRIwX-feuOJY	Morning story	457 SW 6th St, Redmond, OR 97756, USA	44.2726900	-121.1744030	39 m		bakeries, bars, breakfast, coffee shops, desserts, grocery stores, lunch	cafe,restaurant,point_of_interest,food,store,establishment	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	lodging,point_of_interest,establishment	Maps \| Website	(541) 923-2100	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	natural_feature,establishment	Maps			View Photos (4)
ChIJBZpxAVUcvlQR6qmut8B2HYM	Mount Hood	Mt Hood, Oregon 97041, USA	45.3736150	-121.6959510	129,162 m	outdoors	point-of-interest	natural_feature,establishment	Maps			View Photos (4)
ChIJOZ5lIW7TuFQRyMTTRMwAQ3g	Mountain View Mobile Home Park	6100 S Hwy 97, Redmond, OR 97756, USA	44.2207660	-121.2100370	6,444 m		rv parks	rv_park,lodging,point_of_interest,establishment	Maps \| Website	(541) 923-4104		View Photos (4)
ChIJ1wvjjK65uFQR5Uao9AwfHpo	Mt. Bachelor Ski Resort (edited)	13000 SW Century Drive, Bend, OR 97702, USA	43.9897850	-121.6846770	51,485 m	outdoors (edited)	skiing,resort (edited)	tourist_attraction,point_of_interest,establishment	Maps \| Website	(541) 382-1709	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	View Photos (4)
ChIJN784-ygrv1QR6VfDSnksqa0	MUSIC LIFE	232 SW 5th St, Redmond, OR 97756, USA	44.2749500	-121.1729040	271 m		live music	school,point_of_interest,establishment	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	gym,health,point_of_interest,establishment	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)
ChIJcaIytCfVuFQRAGVip2NUV18	National Car Rental	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2527920	-121.1603590	2,455 m		car rentals	car_rental,point_of_interest,establishment	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 – 12:30 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)
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	meal_takeaway,restaurant,point_of_interest,food,establishment	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: Closed	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	tourist_attraction,park,point_of_interest,establishment	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,restaurant,food,point_of_interest,establishment	Maps \| Website	lunch (edited)	View Hours Monday: 4:00 – 9:00 PM Tuesday: 4:00 – 9:00 PM 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: 4:00 – 9:00 PM	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, shopping	shopping_mall,point_of_interest,establishment	Maps		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	View Photos (4)
ChIJk3_cYywsv1QRzU90a7sU3_Q	North Barr Trailhead	Barr Rd, Redmond, OR 97756, USA	44.2878050	-121.3361850	13,027 m		trailheads	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)