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

Previous Next

Page 7 of 26

Showing 151 to 175 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJWUtgagQPx1QRh17ukFOxTC8	Crescent Lake	Crescent Lake, Oregon 97733, USA	43.4747940	-121.9854810	110,008 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (3)
ChIJFT1Qqw7WvlQRolpm-QOAhoA	Crescent Moon Ranch	7566 US-97, Terrebonne, OR 97760, USA	44.3451380	-121.1781310	8,071 m	shopping (edited)	family fun (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-2285	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)
ChIJh0op4tkqv1QR5Z29ZGr-Yl4	Cricket On the Hearth	521 SW 6th St #101, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		gift shops	establishment,point_of_interest,store	Page \| Maps	(541) 504-7770	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	No photos available
ChIJh2CKoykrv1QRuaf8PZH4gI4	Croutons Redmond	974 SW Veterans Way Ste 6, Redmond, OR 97756, USA	44.2671220	-121.1791080	738 m		lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-1500	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM 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)
ChIJu3MkWQLWvlQRQMRwYTcltaI	Crown C Farms	2609 NW Odem Ave, Terrebonne, OR 97760, USA	44.3435460	-121.1968180	8,094 m		farms	establishment,point_of_interest	Page \| Maps	(541) 480-9070		No photos available
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps			View Photos (1)
ChIJZ9b-zHrVuFQRMveL-ZnISEg	Cuportunity Coffee Kiosk	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458880	-121.1884060	3,188 m		coffee shops, thrift stores	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		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: Closed Sunday: Closed	View Photos (2)
ChIJiQuH7j4rv1QRXYH_WzQE1UQ	Cuppa Yo Frozen Yogurt Redmond, OR	446 SW 6th St, Redmond, OR 97756, USA	44.2728200	-121.1739340	22 m		desserts, juice bars	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 899-5955	View Hours Monday: 12:00 – 9:00 PM Tuesday: 12:00 – 9:00 PM Wednesday: 12:00 – 9:00 PM Thursday: 12:00 – 9:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 9:00 PM	View Photos (4)
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, 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		farms, farms,event venues,family fun	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		farms, 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		farmers markets, live music,family fun	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	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,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: 10:30 AM – 3:00 PM 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, 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, brewery, cocktails, dining, 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)