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: 15
Limit per Page: 25
Offset: 350
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 350, 25

Previous Next

Page 15 of 26

Showing 351 to 375 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJi7gs8IErv1QRnWdgTECy3jg	Lunavista Barbershop	411 SW Cascade Ave Unit C, Redmond, OR 97756, USA	44.2748140	-121.1725050	269 m		family friendly	establishment,hair_care,health,point_of_interest	Page \| Maps \| Website	(541) 527-1420	View Hours Monday: Closed Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJRw-0Vvcqv1QRoenbHueXMog	Luxurious 5 bedroom w pool table	Redmond, OR 97756, USA	44.2931330	-121.1894300	2,594 m		pool tables	establishment,lodging,point_of_interest	Page \| Maps \| Website			No photos available
ChIJk1eVk1Irv1QR_eZlbb-NUCo	M Caffè	235 SW 6th St, Redmond, OR 97756, USA	44.2749870	-121.1745630	268 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: 5:00 AM – 12:00 PM Wednesday: 5:00 AM – 12:00 PM Thursday: 5:00 AM – 12:00 PM Friday: 5:00 AM – 12:00 PM Saturday: 6:00 AM – 12:00 PM Sunday: Closed	View Photos (4)
ChIJkyaul87UuFQREuznlPAyt6Q	Madaline’s Mexican Steakhouse	2414 S Hwy 97, Redmond, OR 97756, USA	44.2536460	-121.1826990	2,223 m		bars, cocktails, desserts, desserts,breakfast, dining, food trucks, lunch, nightlife, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-9964	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJO4clJtUrv1QReKuj0qaWep8	Maple Moon Home & Gift	307 NW 7th St, Redmond, OR 97756, USA	44.2785020	-121.1756100	668 m		gift shops, grocery stores, shopping	home_goods_store,grocery_or_supermarket,food,point_of_interest,store,establishment	Page \| Maps \| Website	(541) 279-6652	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 5:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJHXICnnzXvlQRRtxLRomdp7g	Maragas Winery	15523 US-97, Culver, OR 97734, USA	44.4116450	-121.1966530	15,564 m	beer-wine-spirits (edited)	wine bar (edited)	establishment,food,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 546-5464	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:30 AM – 5:00 PM Thursday: 11:30 AM – 5:00 PM Friday: 11:30 AM – 5:00 PM Saturday: 11:30 AM – 5:00 PM Sunday: 11:30 AM – 5:00 PM	View Photos (4)
ChIJLUCGgVkrv1QROkPLx-KGKfg	Marshalls	367 NW Oak tree Ln, Redmond, OR 97756, USA	44.2947120	-121.1705930	2,471 m		shopping	clothing_store,department_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 407-3483	View Hours Monday: 9:30 AM – 9:30 PM Tuesday: 9:30 AM – 9:30 PM Wednesday: 9:30 AM – 9:30 PM Thursday: 9:30 AM – 9:30 PM Friday: 9:30 AM – 9:30 PM Saturday: 9:30 AM – 9:30 PM Sunday: 9:30 AM – 9:30 PM	View Photos (4)
ChIJq3TOwKXSuFQR52junYwHgYI	Maston Trail System	20275 Newcomb Rd, Bend, OR 97701, USA	44.2116340	-121.3029780	12,316 m	outdoors	point of interest	establishment,park,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)
ChIJE7ZzgpIqv1QRQN_sZOI2SUI	Maurices	355 NW Oak tree Ln, Redmond, OR 97756, USA	44.2946830	-121.1714150	2,461 m		boutiques, boutiques,shopping, 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: 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, 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, 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)
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	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,shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 238-6703	View Hours Monday: 8:00 AM – 4:00 PM 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)