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: 13
Limit per Page: 25
Offset: 300
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 300, 25

Previous Next

Page 13 of 29

Showing 301 to 325 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJBetWAa_VuFQRujCxDWTBj90	High Desert Activity Center	6RP7+2F, 3800 SW Airport Way, Redmond, OR 97756, USA	44.2350800	-121.1863640	4,290 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJMXiOOHQrv1QRsxjtPy5QPW8	High Desert Cigars	520 SW Evergreen Ave, Redmond, OR 97756, USA	44.2724280	-121.1736600	30 m		bars	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-4706	View Hours Monday: Closed Tuesday: 12:00 – 7:00 PM Wednesday: 12:00 – 7:00 PM Thursday: 12:00 – 7:00 PM Friday: 12:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ7bLUIkLTuFQRv1Pg9pJ-rFw	High Desert Farms Nursery Sales	5180 SW Canal Blvd, Redmond, OR 97756, USA	44.2283820	-121.2218650	6,227 m		farms	establishment,point_of_interest	Page \| Maps	(541) 548-5020	View Hours Monday: Closed 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 – 5:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJQQhiJ6pf-G4R_tCH3gYL1Ws	High Desert Florals	249 NW 6th St Unit 2, Redmond, OR 97756, USA	44.2780460	-121.1745320	605 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 923-3977	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJR6HFJWIrv1QRx9S5g05rphU	High Desert Geckos Exotic Pets & Supplies	905 SW Rimrock Way Ste 101, Redmond, OR 97756, USA	44.2683770	-121.1924250	1,547 m		gift shops	establishment,pet_store,point_of_interest,store	Page \| Maps \| Website	(541) 527-5082	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: 10:00 AM – 6:00 PM	View Photos (4)
ChIJe3_e_nkrv1QR4qPHcygIUO8	High Desert Music Hall	818 SW Forest Ave, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		bars, bars,cocktails,live music,bars,cocktails,live music,pubs,event venues,bars,cocktails,live music,pubs,brewery,food trucks,event venues, brewery, cocktails, event venues, food trucks, live music, pubs	establishment,point_of_interest	Page \| Maps \| Website	(541) 527-1387		View Photos (4)
ChIJsUFG_Gk_IIERs68sxIk_LJI	High Desert Retreat Spa	1110 NE King Way, Redmond, OR 97756, USA	44.3060140	-121.1556140	3,989 m		spas	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 279-1720		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, family fun,parks,parks,playgrounds, 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, restaurants,breakfast,dining,family friendly	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,cocktails,restaurants,lunch,family friendly, dining, family friendly, live music, lunch, restaurants	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)
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, family fun,parks,mountain biking,parks,mountain biking,tours, 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, bars,pubs,coffee shops,bakeries,family friendly,coffee shops,bakeries,lunch,family friendly, breakfast, coffee shops, family friendly, pubs	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, parks,playgrounds,rock climbing,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
ChIJy7i7yNIrv1QR6XCfclndRJc	House of the Book	307 NW 7th St, Redmond, OR 97756, USA	44.2785330	-121.1756440	672 m		bookstores	book_store,establishment,point_of_interest,store	Page \| Maps \| Website	(458) 312-9962	View Hours Monday: Closed Tuesday: Closed Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJfcCSV-kqv1QR6Aju_KN3Fw0	Hub Motel	1128 NW 6th St, Redmond, OR 97756, USA	44.2867970	-121.1736350	1,576 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,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, breakfast,restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-4777	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 11:00 PM	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)