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: 8
Limit per Page: 25
Offset: 175
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 175, 25

Previous Next

Page 8 of 29

Showing 176 to 200 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Search Term	Types	Links	Phone	Hours	Photos
ChIJFY5UIRkrv1QRVB0JfCCG798	CVS	1514 SW Highland Ave, Redmond, OR 97756, USA	44.2691840	-121.1847540	943 m	desserts	clothing_store,convenience_store,drugstore,establishment,food,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-6041	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9:00 PM Thursday: 8:00 AM – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 9:00 AM – 8:00 PM	View Photos (3)
ChIJcfZKYQArv1QRBmOrKI-tKfA	CVS Pharmacy	1514 SW Highland Ave, Redmond, OR 97756, USA	44.2691840	-121.1847540	943 m	juice bars	establishment,health,pharmacy,point_of_interest,store	Page \| Maps \| Website	(541) 548-6041	View Hours Monday: 9:00 AM – 1:30 PM, 2:00 – 7:00 PM Tuesday: 9:00 AM – 1:30 PM, 2:00 – 7:00 PM Wednesday: 9:00 AM – 1:30 PM, 2:00 – 7:00 PM Thursday: 9:00 AM – 1:30 PM, 2:00 – 7:00 PM Friday: 9:00 AM – 1:30 PM, 2:00 – 7:00 PM Saturday: 9:00 AM – 1:30 PM, 2:00 – 6:00 PM Sunday: 9:00 AM – 1:30 PM, 2:00 – 6:00 PM	View Photos (2)
ChIJeSAC2ILavlQRoW7ovBffQ44	Cyrus Horse Campground	Prineville, OR 97754, USA	44.4479630	-121.1038740	20,277 m	campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6640		View Photos (4)
ChIJq7ILL8nUuFQRqDAoTJUWs7Y	Dairy Queen	2542 S Hwy 97, Redmond, OR 97756, USA	44.2519210	-121.1837800	2,432 m	desserts	establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-2616	View Hours Monday: 10:30 AM – 9:00 PM Tuesday: 10:30 AM – 9:00 PM Wednesday: 10:30 AM – 9:00 PM Thursday: 10:30 AM – 9:00 PM Friday: 10:30 AM – 9:30 PM Saturday: 11:00 AM – 9:30 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJg46ufybVuFQRHqdDNMuhm7Y	DAM Creative-Redbubble	2250 SW 21st St, Redmond, OR 97756, USA	44.2557690	-121.1912850	2,329 m	boutiques, gift shops	art_gallery,clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website		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
ChIJn4JJidjUuFQR_QVq2C_J8YM	Dancing River Gifts & Coffee	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2529810	-121.1608730	2,418 m	coffee shops, coffee shops,gift shops,gift shops, gift shops, shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-0280	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: 8:00 AM – 4:00 PM	View Photos (4)
ChIJEcH4-zPUvlQRNMYqcR43QQ8	DD Ranch	3836 NE Smith Rock Way, Terrebonne, OR 97760, USA	44.3465550	-121.1216070	9,215 m	event venues, family fun, farms, farms,event venues,family fun,farms,event venues	establishment,food,point_of_interest,store,tourist_attraction	Page \| Maps \| Website	(541) 233-8359	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 – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJJdf_U60ASWURlbTQkXi2GUU	Deby Grant LMT- Massage Therapy	405 SW 6th St, Redmond, OR 97756, USA	44.2733190	-121.1745720	93 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 419-5659		View Photos (4)
ChIJ06XH5xEquVQRnC_YutzzA9I	Dee Bar Farms	6402 SW Powell Butte Hwy, Powell Butte, OR 97753, USA	44.2452200	-121.0468210	10,570 m	event venues, farms, farms,event venues,farms,event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 408-6927		View Photos (4)
ChIJsaHsZJTUuFQRMSPLddrCcZs	Deschutes County Fair & Expo Center	3800 SW Airport Wy, Redmond, OR 97756, USA	44.2381170	-121.1853420	3,943 m	family fun, farmers markets, live music, live music,family fun,live music,rv parks	establishment,point_of_interest	Page \| Maps \| Website	(541) 548-2711	View Hours Monday: 8:00 AM – 5:00 PM 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: Closed Sunday: Closed	View Photos (4)
ChIJySTPqbHHuFQR8Hx4-ovu45E	Deschutes Gift Baskets offers Pacific NW Style Gift Baskets & Gift Boxes for local delivery & ship nationwide	632 SW 6th St Ste 1, Redmond, OR 97756, USA	44.2710780	-121.1739630	171 m	gift shops, gift shops,shopping,gift shops, shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 977-1036	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJDz5Oe1PSuFQR3uLNHilffL8	Deschutes Hop Farm	8451 S Hwy 97, Redmond, OR 97756, USA	44.1984020	-121.2324860	9,480 m	farms	establishment,point_of_interest	Page \| Maps	(541) 525-5898	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: Open 24 hours Friday: Open 24 hours Saturday: Open 24 hours Sunday: 9:00 AM – 7:00 PM	No photos available
ChIJ7TyAWOgrv1QR5v5xSfqrkMA	Deschutes River Lavender	5703 NW Maple Ave, Redmond, OR 97756, USA	44.2912890	-121.2373230	5,457 m	farms, farms,gift shops,farms,gift shops, gift shops	establishment,point_of_interest,store	Page \| Maps \| Website	(714) 227-6794		View Photos (4)
ChIJW8noIy4rv1QRTNvI2z_O02E	Desert Lily Bodywork	418 SW 6th St, Redmond, OR 97756, USA	44.2732420	-121.1739680	69 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(833) 481-3895	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 12:00 – 4:30 PM Friday: 12:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJZVluKAIrv1QR10_B1RNFw-c	Desert Prairie	404 SW 6th St Ste 100, Redmond, OR 97756, USA	44.2733350	-121.1740130	80 m	boutiques, boutiques,gift shops,shopping,boutiques,gift shops,shopping, gift shops, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-1887	View Hours Monday: 10:00 AM – 5:30 PM Tuesday: 10:00 AM – 5:30 PM Wednesday: 10:00 AM – 5:30 PM Thursday: 10:00 AM – 5:30 PM Friday: 10:00 AM – 5:30 PM Saturday: 10:00 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJd05pv-krv1QRBoxRKH3-XKs	Desert Sky Massage Therapy	1129 SW 12th St, Redmond, OR 97756, USA	44.2661270	-121.1810280	917 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 699-1441		View Photos (4)
ChIJeWBq8dkqv1QRdcA_f-niRhw	Diego’s Spirited Kitchen	447 SW 6th St, Redmond, OR 97756, USA	44.2728220	-121.1744640	49 m	bars, bars,cocktails,nightlife,bars,cocktails,pubs,restaurants,lunch,dining,family friendly,bars,cocktails,nightlife,pubs,brewery,restaurants,lunch,dining,family friendly, brewery, cocktails, dining, family friendly, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-2002	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: Closed	View Photos (4)
ChIJ8a3rG67HuFQRZt-dJvqPjAI	Discovery With Horses	6262 SW Nighthawk Ave, Redmond, OR 97756, USA	44.2151110	-121.2450490	8,544 m	horseback rides	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 815-2017	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	No photos available
ChIJ1YkTCskrv1QRBM7YTyMXzU4	District Day Spa	823 SW 12th St, Redmond, OR 97756, USA	44.2691460	-121.1809830	682 m	spas	beauty_salon,establishment,point_of_interest	Page \| Maps \| Website	(541) 548-5352		No photos available
ChIJR1NzVXErv1QRTbTqSUcJlOE	Don Gabino’s Mexican Grill	530 SW 6th St Ste 102, Redmond, OR 97756, USA	44.2719360	-121.1739710	76 m	breakfast, breakfast,lunch,breakfast,dining, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(458) 836-7577	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJs6KM3VvVuFQReo-RvihOicg	Doozys	1729 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2534450	-121.1867190	2,363 m	coffee shops	cafe,establishment,food,point_of_interest	Page \| Maps	(541) 316-2242	View Hours Monday: 7:00 AM – 2:00 AM Tuesday: 7:00 AM – 2:00 AM Wednesday: 7:00 AM – 2:00 AM Thursday: 7:00 AM – 2:00 AM Friday: 7:00 AM – 2:00 AM Saturday: 7:00 AM – 2:00 AM Sunday: 7:00 AM – 2:00 AM	View Photos (2)
ChIJSw_tV9cqv1QRLNc53CS77VA	Double J Saloon	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m	bars, pool tables, pubs	bar,point_of_interest,establishment	Page \| Maps	(541) 923-1868		View Photos (4)
ChIJncT7DKrVuFQRYWeqdi_72o8	Double K Collectibles	2130 S Hwy 97 a, Redmond, OR 97756, USA	44.2562770	-121.1809400	1,901 m	vintage	establishment,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJv8uUGM8rv1QR7vmOXDVoY90	Double T’s Smoothies and Paninis	404 SW Forest Ave, Redmond, OR 97756, USA	44.2712610	-121.1724220	193 m	breakfast, coffee shops, desserts, desserts,juice bars,food trucks,breakfast, food trucks, juice bars	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 4:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 4:00 PM Friday: 11:00 AM – 4:00 PM Saturday: 11:00 AM – 4:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJt_Qk0-srv1QRFxXY2DHjjSE	Dry Canyon Club + EV Charging Station	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2839490	-121.1888140	1,730 m	bars, brewery, brewery,food trucks,brewery,food trucks, food trucks	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 550-9340	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: 10:00 AM – 10:00 PM Sunday: 10:00 AM – 9:00 PM	View Photos (4)