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: 14
Limit per Page: 25
Offset: 325
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 325, 25

Previous Next

Page 14 of 24

Showing 326 to 350 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJE7ZzgpIqv1QRQN_sZOI2SUI	Maurices	355 NW Oak tree Ln, Redmond, OR 97756, USA	44.2946830	-121.1714150	2,461 m		boutiques, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-8629	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 – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 11:00 AM – 6:00 PM	View Photos (4)
ChIJAac1VSorv1QRS76k1p4jn4k	Mazatlan Mexican Restaurant \| Redmond	1302 S Hwy 97, Redmond, OR 97756, USA	44.2644460	-121.1753740	916 m		bars, desserts, lunch, nightlife, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7426	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:30 PM Saturday: 11:00 AM – 9:30 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJbRTYuM7UuFQRU5idQPn7xHQ	McDonald’s	2456 S Hwy 97, Redmond, OR 97756, USA	44.2532170	-121.1827740	2,270 m		breakfast, coffee shops, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 923-1923	View Hours Monday: 5:00 AM – 11:00 PM Tuesday: 5:00 AM – 11:00 PM Wednesday: 5:00 AM – 11:00 PM Thursday: 5:00 AM – 11:00 PM Friday: 5:00 AM – 10:00 PM Saturday: 5:00 AM – 10:00 PM Sunday: 5:00 AM – 11:00 PM	View Photos (4)
ChIJkRycFiUrv1QRbqt5bK2V5dU	McDonald’s	895 SW Rimrock Way, Redmond, OR 97756, USA	44.2689730	-121.1936630	1,623 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 504-0073	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 10:00 PM Saturday: 5:00 AM – 10:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJgXHubysrv1QRcyfruHw7F38	McFarland Chiropractic	1421 S Hwy 97, Redmond, OR 97756, USA	44.2629760	-121.1773340	1,106 m		wellness center	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 516-8300	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 12:00 PM Thursday: 10:00 AM – 6:00 PM Friday: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJKwUCEwMrv1QRzfWYQWJE8KI	Mer Massage & Ashiatsu	818 SW Forest Ave Suite B, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		massage	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 639-9333	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 2:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: 8:00 AM – 12:00 PM	View Photos (4)
ChIJT6BQjt4rv1QR5xQ1I4b-8BI	Metolius Rose Farmstand	3920 US-97, Redmond, OR 97756, USA	44.3112490	-121.1714120	4,300 m		farmers markets, markets	establishment,point_of_interest	Page \| Maps	(541) 604-8284	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)
ChIJs5X2uikrv1QR8j5Y4D-cC2Y	Mi Cielo Mexican Restaurant	950 SW Veterans Way #102, Redmond, OR 97756, USA	44.2674300	-121.1790250	706 m		breakfast, dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-3903	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: 9:00 AM – 7:00 PM Friday: 9:00 AM – 7:00 PM Saturday: 8:30 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJIcsYuMsrv1QR4N1YCgkb4Aw	Mickey’s Adventures	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores	book_store,establishment,point_of_interest,store	Page \| 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
ChIJ8bTQSWUqv1QRQJlzV_-JCeo	Milliron Showpigs	900 NW Pershall Way, Redmond, OR 97756, USA	44.3103740	-121.1773040	4,207 m		farms	establishment,food,point_of_interest	Page \| Maps	(541) 728-6364		View Photos (2)
ChIJwzUf4i4rv1QR2gC0jG6ZtCo	Mo’s Egg House	950 SW Veterans Way, Redmond, OR 97756, USA	44.2674830	-121.1788790	694 m		breakfast	establishment,food,point_of_interest,restaurant	Page \| 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		desserts, grocery stores	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| 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	establishment,point_of_interest	Page \| 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	establishment,food,point_of_interest	Page \| 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	establishment,finance,point_of_interest	Page \| 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	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJo_N7si4rv1QRRIwX-feuOJY	Morning story	457 SW 6th St, Redmond, OR 97756, USA	44.2726900	-121.1744030	39 m		bakeries, 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)
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)
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)
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)
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)