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: 12
Limit per Page: 25
Offset: 275
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 275, 25

Previous Next

Page 12 of 26

Showing 276 to 300 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJe3_e_nkrv1QR4qPHcygIUO8	High Desert Music Hall	818 SW Forest Ave, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		bars,cocktails,live music,bars,cocktails,live music,pubs,event venues, event venues, food trucks, live music	establishment,point_of_interest	Page \| Maps \| Website	(541) 527-1387		View Photos (4)
ChIJMcJUKZ8qv1QRHTDIvZJyOKM	High Desert Sports Complex	1859 NE Maple Ave, Redmond, OR 97756, USA	44.2920230	-121.1473310	3,022 m		family fun,parks	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-1001	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)
ChIJ0bDcnyQrv1QRMLBMPuAVSVs	Highland Grub and Go	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697810	-121.1853190	961 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 5:00 AM – 8:00 PM Tuesday: 5:00 AM – 8:00 PM Wednesday: 5:00 AM – 8:00 PM Thursday: 5:00 AM – 8:00 PM Friday: 5:00 AM – 8:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 8:00 PM	View Photos (4)
ChIJSbrw9PrJuFQR2hiNzKwfcU8	Historic Old Cabin Ruins	Oregon 97703, USA	44.1033890	-121.3393840	22,982 m		historic landmarks	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJl9tzmsIqv1QRDSqoKGveaLA	Hola!	514 NW Greenwood Ave, Redmond, OR 97756, USA	44.2817850	-121.1733830	1,020 m		cocktails, cocktails,live music,cocktails,live music,restaurants,lunch,dining,family friendly, live music, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7290	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJDYSx6dwqv1QR-ENJ3dajD0o	Hold My Halo Hideaway- Downtown Walk to Bars, Restaurants, Concerts, & Shopping!	Redmond, OR 97756, USA	44.2811130	-121.1748660	947 m		bars	establishment,lodging,point_of_interest	Page \| Maps			No photos available
ChIJsS__lvMrv1QRA4s8zenoeJ4	Homeslice Pizza	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m	food-trucks (edited)	food trucks (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 306-8314	View Hours Monday: 12:00 – 8:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 9:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJX81aCKorv1QRi-Sdc9Txutc	Homestead Pump Track	767 NW Canal Blvd, Redmond, OR 97756, USA	44.2834450	-121.1686740	1,274 m	outdoors	family fun,parks,mountain biking, mountain biking, parks, point of interest	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-2000	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJeTVVj5Urv1QRqKgR332Q8jU	Homestead Shoppes- Urban Homestead Co	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		boutiques, gift shops, shopping	clothing_store,store,point_of_interest,establishment	Page \| Maps \| Website	(541) 604-1062	View Hours Monday: 10:30 AM – 4:30 PM Tuesday: 10:30 AM – 4:30 PM Wednesday: 10:30 AM – 4:30 PM Thursday: 10:30 AM – 4:30 PM Friday: 10:30 AM – 4:30 PM Saturday: 10:30 AM – 4:00 PM Sunday: Closed	View Photos (1)
ChIJsWQvQ9cqv1QRTFGd9qQ_-s8	Honey & Pine Coffee Company	610 SW 6th St, Redmond, OR 97756, USA	44.2713720	-121.1736070	141 m		bakeries, bars,pubs,coffee shops,bakeries,family friendly, breakfast, coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 604-0822	View Hours Monday: 6:00 AM – 6:00 PM Tuesday: 6:00 AM – 6:00 PM Wednesday: 6:00 AM – 6:00 PM Thursday: 6:00 AM – 6:00 PM Friday: 6:00 AM – 6:00 PM Saturday: 6:00 AM – 6:00 PM Sunday: 6:00 AM – 6:00 PM	View Photos (4)
ChIJnX2OP0w3v1QRa6S6FFt3zCg	Hoodoo Ski Area	27400 Big Lake Road, Sisters, OR 97759, USA	44.4086440	-121.8714160	57,494 m	outdoors	skiing	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3799	View Hours Monday: Closed Tuesday: Closed Wednesday: 9:00 AM – 9:00 PM Thursday: 9:00 AM – 9:00 PM Friday: 9:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: 9:00 AM – 4:00 PM	View Photos (4)
ChIJTbJyI7orv1QRTz27mBwSv5w	Hope Playground	401 SW 15th St, Redmond, OR 97756, USA	44.2734140	-121.1846650	860 m		parks,playgrounds,rock climbing, playgrounds, rock climbing	establishment,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJiQq70Scrv1QREcA_N607L3Y	House of Hope Ministries	724 SW 14th St, Redmond, OR 97756, USA	44.2700200	-121.1826340	752 m		thrift stores	establishment,point_of_interest	Page \| Maps \| Website	(541) 390-1594	View Hours Monday: 12:30 – 2:00 PM Tuesday: Closed Wednesday: Closed Thursday: 12:30 – 2:00 PM Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJfcCSV-kqv1QR6Aju_KN3Fw0	Hub Motel	1128 NW 6th St, 1154 NW 6th St, Redmond, OR 97756, USA	44.2868200	-121.1736330	1,579 m		hotels	establishment,lodging,point_of_interest	Page \| Maps \| Website	(800) 784-3482		View Photos (4)
ChIJ_QttG9sqv1QRlMOKu0qCRnQ	Human Touch Massage Center	341 SW Black Butte Blvd, Redmond, OR 97756, USA	44.2756950	-121.1718830	378 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 923-9708		No photos available
ChIJq6pa8drUuFQRqAQLsKvH_wg	Hunt Long Range	2606 SW 4th St, Redmond, OR 97756, USA	44.2514490	-121.1700190	2,375 m		driving range, shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1820	View Hours Monday: 6:00 AM – 5:00 PM Tuesday: 6:00 AM – 5:00 PM Wednesday: 6:00 AM – 5:00 PM Thursday: 6:00 AM – 5:00 PM Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJeRO2t9cqv1QRbg6I-B-a7bI	Ida’s Cupcake Cafe, Redmond	445 SW 6th St, Redmond, OR 97756, USA	44.2729040	-121.1745710	61 m		bakeries, bakeries,desserts, coffee shops, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-6077	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 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJkcDtyGTVuFQRP4prAO1hghU	IHOP	3807 SW 21st St, Redmond, OR 97756, USA	44.2412650	-121.1921760	3,778 m		breakfast	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-4777	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJbZz3G-87v1QReu-cFiQyh0Q	Indian ford campground	Indian Ford Rd, Sisters, OR 97759, USA	44.3587800	-121.6105130	36,032 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (3)
ChIJ_ysij0grv1QRbvShDgSXegU	Indian tadka	123 SW 5th St, Redmond, OR 97756, USA	44.2759040	-121.1729080	374 m	food-trucks (edited)	food trucks (edited)	meal_takeaway,restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: 11:00 AM – 8:00 PM 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 – 8:00 PM	View Photos (4)
ChIJH4FAr-srv1QRAweoCHMgJFg	Indian tadka	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		restaurants,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 7:45 PM Tuesday: Closed Wednesday: 11:00 AM – 7:45 PM Thursday: 11:00 AM – 7:45 PM Friday: 11:00 AM – 7:45 PM Saturday: 11:00 AM – 7:45 PM Sunday: 11:00 AM – 7:45 PM	View Photos (4)
ChIJQbpvDv0rv1QRNw9JdvxktaU	Initiative Brewing (the Hub)	424 NW 5th St, Redmond, OR 97756, USA	44.2799660	-121.1729920	820 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, brewery, cocktails, food trucks, live music, microbrewery, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4380	View Hours Monday: 11:00 AM – 8:00 PM 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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJHxdYl8grv1QRHvAKRrvBA24	Inner Balance Therapeutic Massage	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727000	-121.1745910	54 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(971) 208-3363	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: Closed Sunday: Closed	View Photos (3)
ChIJOYjHWdAqv1QRrJQoj6YZVDc	J C’s Java & Such	106 SE Evergreen Ave, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m		coffee shops	cafe,food,point_of_interest,store,establishment	Page \| Maps		View Hours Monday: 7:00 AM – 6:00 PM Tuesday: 7:00 AM – 6:00 PM Wednesday: 7:00 AM – 6:00 PM Thursday: 7:00 AM – 6:00 PM Friday: 7:00 AM – 6:00 PM Saturday: 7:00 AM – 6:00 PM Sunday: Closed	No photos available
ChIJWW_oVLfdvlQRui_hg2lwa6E	Jericho Lane Farmhouse	3999-3301 SW Jericho Ln, Culver, OR 97734, USA	44.5020890	-121.1969430	25,581 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)