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

Previous Next

Page 17 of 29

Showing 401 to 425 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJKwUCEwMrv1QRzfWYQWJE8KI	Mer Massage & Ashiatsu	818 SW Forest Ave Suite B, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		massage, massage,spas	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 639-9333	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: 9:00 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJT6BQjt4rv1QR5xQ1I4b-8BI	Metolius Rose Farmstand	3920 US-97, Redmond, OR 97756, USA	44.3112490	-121.1714120	4,300 m		farmers markets, farmers markets,farms,farmers markets,farms, farms, markets	establishment,point_of_interest	Page \| Maps	(541) 604-8284	View Hours Monday: 10:00 AM – 3:00 PM Tuesday: 10:00 AM – 3:00 PM Wednesday: 10:00 AM – 3:00 PM Thursday: 10:00 AM – 3:00 PM Friday: 10:00 AM – 3:00 PM Saturday: 10:00 AM – 3: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, dining, family friendly, lunch, restaurants, restaurants,breakfast,lunch,dining,family friendly,restaurants,breakfast,lunch,dining,family friendly	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)
ChIJL2pt8drUuFQRn2aIpU5e924	MOA Rifles	2606 SW 4th St, Redmond, OR 97756, USA	44.2514460	-121.1700170	2,375 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1820	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 4:30 PM Saturday: Closed Sunday: Closed	View Photos (4)
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.	827 SW 7th St, Redmond, OR 97756, USA	44.2690600	-121.1756890	420 m		desserts, desserts,lunch,desserts, lunch	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)
ChIJE1ngFPYrv1QRMcpC-gwtLZk	Monarch Coffee Co	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		coffee shops, coffee shops,shopping,coffee shops,shopping, shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 238-6703	View Hours Monday: Closed Tuesday: 8:00 AM – 4:00 PM Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: Closed	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.3706390	-121.1434910	11,165 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJo9PM7ZLWvlQRc4ahlE6wvC0	Monkey Face	Monkey Face, Oregon 97760, USA	44.3706220	-121.1440460	11,153 m		rock climbing	establishment,natural_feature	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, bars, bars,coffee shops,bakeries,desserts,grocery stores,breakfast,shopping,bars,coffee shops,bakeries,desserts,breakfast,dining,shopping, breakfast, coffee shops, desserts, dining, grocery stores, lunch, shopping	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)
ChIJx_9rmekrv1QRcnd-p2s66gE	Mya elegantly body massage therapy and wellness	432 SW 6th St, Redmond, OR 97756, USA	44.2730890	-121.1740260	53 m		massage	establishment,point_of_interest,spa	Page \| Maps	(404) 984-1571		No photos available
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, dining,lunch	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		airports, airports,car rentals, 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)