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

Previous Next

Page 15 of 27

Showing 351 to 375 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	point_of_interest,establishment	Maps			No photos available
ChIJAQAUQGosv1QRzH9ldH-i9jg	Lucid Farms	640 NW 103rd St, Redmond, OR 97756, USA	44.2824300	-121.2946810	9,676 m		farms	point_of_interest,establishment	Maps	(503) 407-5293		No photos available
ChIJkfbA9UzSuFQRsoE2vhas2kY	Lucky 7	2392 S Hwy 97, Redmond, OR 97756, USA	44.2541200	-121.1823950	2,165 m		bars, cocktails, nightlife, pool tables, pubs	bar,point_of_interest,establishment	Maps \| Website	(541) 923-4377	View Hours Monday: 10:00 AM – 9:00 PM Tuesday: 10:00 AM – 12:00 AM Wednesday: 10:00 AM – 12:00 AM Thursday: 10:00 AM – 12:00 AM Friday: 10:00 AM – 12:00 AM Saturday: 10:00 AM – 12:00 AM Sunday: 10:00 AM – 9:00 PM	View Photos (4)
ChIJBctTKD_VuFQRjPPbpggeKXQ	Luna View Park	3660 SW Reservoir Dr, Redmond, OR 97756, USA	44.2499970	-121.2107270	3,863 m		parks, playgrounds	park,point_of_interest,establishment	Maps \| Website			View Photos (4)
ChIJP0mlmRvXvlQRuMOtOI2wDCM	Luna’s Taqueria	1350 NW Canal Blvd, Redmond, OR 97756, USA	44.2880580	-121.1679440	1,781 m		breakfast, family friendly, food trucks, restaurants	restaurant,point_of_interest,food,establishment	Maps \| Website	(541) 279-3356	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJESpW8d8rv1QRCvdItyDWcPM	Lunar massage	418 SW 6th St, Redmond, OR 97756, USA	44.2732420	-121.1739770	69 m		massage	point_of_interest,establishment	Maps \| Website	(541) 815-0513	View Hours Monday: 10:30 AM – 8:00 PM Tuesday: 12:00 – 5:00 PM Wednesday: 10:30 AM – 8:00 PM Thursday: 10:30 AM – 5:00 PM Friday: 10:30 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJk1eVk1Irv1QR_eZlbb-NUCo	M Caffè/ Kooki	235 SW 6th St, Redmond, OR 97756, USA	44.2749870	-121.1745630	268 m		coffee shops	cafe,food,point_of_interest,store,establishment	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)
ChIJ6y3y0nQrv1QRpIFul8xhRhg	M&w Markets	900 SW 23rd St, Redmond, OR 97756, USA	44.2679840	-121.1934960	1,642 m		grocery stores, markets, shopping	hardware_store,home_goods_store,store,point_of_interest,establishment	Maps	(541) 548-5070	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 – 9:00 PM	View Photos (4)
ChIJkyaul87UuFQREuznlPAyt6Q	Madaline’s Grill & Steak House	2414 S Hwy 97, Redmond, OR 97756, USA	44.2536460	-121.1826990	2,223 m		bars, breakfast, dining, family friendly, food trucks, lunch, pubs, restaurants	restaurant,food,point_of_interest,establishment	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)
ChIJ2duG4fEqv1QRuOdOz8cwD8I&	Maple Bridge Climbing Arches at Paul Hathaway Memorial Park (edited)	1021 NW Rockcrest Ct, Redmond, OR 97756, USA (edited)	44.2910690	-999.9999999		outdoors (edited)	rock climbing, parks, point-of-interest (edited)	park,point_of_interest,establishment (edited)	Maps \| Website (edited)			No photos available
ChIJO4clJtUrv1QReKuj0qaWep8	Maple Moon Home & Gift	307 NW 7th St, Redmond, OR 97756, USA	44.2785020	-121.1756100	668 m		boutiques, gift shops, grocery stores, shopping	grocery_or_supermarket,home_goods_store,food,point_of_interest,store,establishment	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 (edited)	15523 US-97, Culver, OR 97734, USA (edited)	44.4116450	-121.1966530	15,564 m	beer-wine-spirits (edited)	wine bars,seasonal, point of interest (edited)	tourist_attraction,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(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	No photos available
ChIJLUCGgVkrv1QROkPLx-KGKfg	Marshalls	367 NW Oak tree Ln, Redmond, OR 97756, USA	44.2947120	-121.1705930	2,471 m		shopping	department_store,clothing_store,store,point_of_interest,establishment	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 (edited)	20275 Newcomb Rd, Bend, OR 97701, USA (edited)	44.2116340	-121.3029780	12,316 m	outdoors (edited)	climbing, point-of-interest, mountain biking (edited)	park,point_of_interest,establishment,mountain_biking (edited)	Maps \| Website (edited)	(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	No photos available
ChIJE7ZzgpIqv1QRQN_sZOI2SUI	Maurices	355 NW Oak tree Ln, Redmond, OR 97756, USA	44.2946830	-121.1714150	2,461 m		boutiques, shopping	clothing_store,store,point_of_interest,establishment	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, lunch, restaurants	restaurant,food,point_of_interest,establishment	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)
ChIJ47aEJwDRvlQRLqITEmyHa94	McCoin homestead & apple orchard	Jefferson County, OR 97741, USA	44.4290330	-121.0888550	18,661 m		point of interest	point_of_interest,establishment	Maps			No photos available
ChIJbRTYuM7UuFQRU5idQPn7xHQ	McDonald’s	2456 S Hwy 97, Redmond, OR 97756, USA	44.2532170	-121.1827740	2,270 m		breakfast, coffee shops, lunch	cafe,restaurant,food,point_of_interest,store,establishment	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,restaurant,food,store,point_of_interest,establishment	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 of Redmond	1421 S Hwy 97, Redmond, OR 97756, USA	44.2629760	-121.1773340	1,106 m		wellness center	health,point_of_interest,establishment	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 – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJz7JYYzU3v1QRSphU5xhlPEk	McKenzie Pass Scenic Bikeway – Start (edited)	Village Green City Park Sisters, OR 97759 (edited)	44.2890820	-121.5493360	29,942 m	outdoors (edited)	mountain biking, point of interest, local parks (edited)	mountain_biking,point_of_interest,local_parks (edited)	Maps \| Website	(541) 549-6022	View Hours Monday: 7:30 AM – 4:30 PM Tuesday: 7:30 AM – 4:30 PM Wednesday: 7:30 AM – 4:30 PM Thursday: 7:30 AM – 4:30 PM Friday: 7:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJdzuNWw0yuVQRwKLfEBc0ntg	Meadow Lakes Golf Course (edited)	300 SW Meadow Lakes Dr, Prineville, OR 97754, USA	44.2970930	-120.8532500	25,671 m	golf (edited)	golf courses,golf lessons,driving range (edited)	golf courses,golf lessons,driving range (edited)	Maps \| Website (edited)	(541) 447-7113	View Hours Monday: 8:00 AM – 7:00 PM Tuesday: 8:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 7:00 PM	View Photos (4)
ChIJg_3xktIrv1QR7iHCwWkWMB0	Melissa Goray LMT	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m		massage	point_of_interest,establishment	Maps \| Website	(541) 312-4059	View Hours Monday: Closed Tuesday: Closed Wednesday: 8:30 AM – 8:00 PM Thursday: Closed Friday: 8:30 AM – 8:00 PM Saturday: 8:30 AM – 8:00 PM Sunday: 10:00 AM – 5:00 PM	View Photos (1)
ChIJKwUCEwMrv1QRzfWYQWJE8KI	Mer Massage & Ashiatsu	818 SW Forest Ave Suite B, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		massage	point_of_interest,spa,establishment	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 – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 2:00 PM Saturday: Closed 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, family friendly, lunch, restaurants	restaurant,food,point_of_interest,establishment	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)