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: 16
Limit per Page: 25
Offset: 375
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 375, 25

Previous Next

Page 16 of 29

Showing 376 to 400 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ8QthECgrv1QRCEBuWDpd6-U	Loco Place	1106 SW Highland Ave, Redmond, OR 97756, USA	44.2693550	-121.1797660	590 m		desserts, family friendly, food trucks, food trucks,restaurants,lunch,family friendly,food trucks,family friendly, lunch, restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps	(541) 527-1238	View Hours Monday: Closed Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8: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)
ChIJ79Inuosrv1QRgVCck7bm4cI	Lombardy’s Tavern (This is NOT Bangers & Brews)	lunch (edited)	44.2690550	-121.1756600	420 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJQb3g8rcmuVQRYSJ9Dv2rX-Q	Lone Pine Campground	OR-27, Prineville, OR 97754, USA	44.1296040	-120.8369880	31,214 m		campgrounds	campground,establishment,lodging,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)
ChIJ-84vWdcqv1QRvW4ya-5O9RE	Los Brothers Taco Shop	542 SW 6th St, Redmond, OR 97756, USA	44.2719440	-121.1738890	75 m		lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 504-7178	View Hours Monday: 9:00 AM – 8:30 PM Tuesday: 9:00 AM – 8:30 PM Wednesday: 9:00 AM – 8:30 PM Thursday: 9:00 AM – 8:30 PM Friday: 9:00 AM – 8:30 PM Saturday: 9:00 AM – 8:30 PM Sunday: Closed	View Photos (4)
ChIJgTOYyknVuFQRWSMhLTLHqyE	Los Langostinos Restaurant	3113 S Hwy 97 #103, Redmond, OR 97756, USA	44.2480660	-121.1885990	2,970 m		bars, cocktails, live music, live music,restaurants, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 604-7580	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJN4gFkykrv1QR7NUEGRE6ySc	Louise Nicole	521 SW 6th St ste 100, Redmond, OR 97756, USA	44.2722780	-121.1745490	63 m		massage	establishment,point_of_interest	Page \| Maps	(567) 501-2819	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)
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	establishment,point_of_interest	Page \| Maps			No photos available
ChIJAQAUQGosv1QRzH9ldH-i9jg	Lucid Farms	640 NW 103rd St, Redmond, OR 97756, USA	44.2824300	-121.2946810	9,676 m		farms	establishment,point_of_interest	Page \| 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, bars,nightlife,pool tables,bars,nightlife,pool tables,pubs,bars,nightlife,pool tables,pubs, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,point_of_interest	Page \| 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, parks,playgrounds,parks,playgrounds, playgrounds	establishment,park,point_of_interest	Page \| 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, restaurants	restaurant,food,point_of_interest,establishment	Page \| 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	establishment,point_of_interest	Page \| 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
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)
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, breakfast, cocktails, desserts, desserts,breakfast,dining, 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)
ChIJSU-sSQUrv1QRxkyS_EWafq0	Mana Folly	439 SW 6th St, Redmond, OR 97756, USA	44.2729760	-121.1745920	67 m		shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 897-9840	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: Closed Wednesday: 11:00 AM – 7:00 PM Thursday: 3:00 – 7:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7: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,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 – 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)
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 of Redmond	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)