Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: name
Order: ASC

Pagination:

Current Page: 7
Limit per Page: 25
Offset: 150
Total Pages: 24

Results:

Total Available Records: 583
Total After Limits: 583
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 1=1 ORDER BY COALESCE(e.name, p.name) ASC LIMIT 150, 25

Previous Next

Page 7 of 24

Showing 151 to 175 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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)
ChIJh958ysIqv1QRhf4kRXyXLYo	D & H Texaco Food Mart	539 NW 6th St, Redmond, OR 97756, USA	44.2807170	-121.1744810	901 m		desserts, grocery stores	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps \| Website	(541) 548-1009	View Hours Monday: 6:00 AM – 8:00 PM Tuesday: 6:00 AM – 8:00 PM Wednesday: 6:00 AM – 8:00 PM Thursday: 6:00 AM – 8:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (1)
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, 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	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)
ChIJ06XH5xEquVQRnC_YutzzA9I	Dee Bar Farms	6402 SW Powell Butte Hwy, Powell Butte, OR 97753, USA	44.2452200	-121.0468210	10,570 m		farms	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	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 hand-delivered and shipped gifts for all occasions.	632 SW 6th St ste 1, Redmond, OR 97756, USA	44.2710780	-121.1739630	171 m		gift shops	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: Closed 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
ChIJeUWr3ujdvlQR3p2oOM2EYrc	Deschutes River Campground, A, B & C Loops	7300 SW Jordan Rd, Culver, OR 97734, USA	44.5370850	-121.2789300	30,567 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 546-3412		View Photos (4)
ChIJZVluKAIrv1QR10_B1RNFw-c	Desert Prairie	404 SW 6th St Suite 100, Redmond, OR 97756, USA	44.2734090	-121.1740130	88 m		boutiques, 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)
ChIJO1psLWfTuFQRjBPyiPlQC3M	Desert Terrace Mobile Estates	5063 S Hwy 97, Redmond, OR 97756, USA	44.2296860	-121.2073720	5,467 m		rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps	(541) 548-2546		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, 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)
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
ChIJz_POJMjUuFQRRHQZ43jHcc0	Dollar Tree	2925 S Hwy 97 Suite 106, Redmond, OR 97756, USA	44.2497040	-121.1877570	2,776 m		juice bars, shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(971) 439-0388	View Hours Monday: 8:00 AM – 10:00 PM Tuesday: 8:00 AM – 10:00 PM Wednesday: 8:00 AM – 10:00 PM Thursday: 8:00 AM – 10:00 PM Friday: 8:00 AM – 10:00 PM Saturday: 8:00 AM – 10:00 PM Sunday: 8: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	No photos available
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)
ChIJv8uUGM8rv1QR7vmOXDVoY90	Double T’s Smoothies and Paninis	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2839170	-121.1888170	1,727 m		coffee shops, juice bars	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 8:00 AM – 4:00 PM Tuesday: 8:00 AM – 4:00 PM Wednesday: Closed Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: 9:00 AM – 4:00 PM	View Photos (4)
ChIJt_Qk0-srv1QRFxXY2DHjjSE	Dry Canyon Club	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2839490	-121.1888140	1,730 m		bars, brewery, 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)
ChIJKa5gyd8qv1QR0IIQ9dCL34c	Dry Canyon Disc Golf Course (edited)	1515 W Antler Ave, Redmond, OR 97756, USA (edited)	44.2772660	-121.1843650	979 m	outdoors,recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7275		View Photos (4)
ChIJPWUNQyUrv1QRdpIVQnbQzxs	Dry Canyon Park & Trail System	Unnamed Road, Redmond, OR 97756, USA	44.3022990	-121.1902760	3,548 m	outdoors	hiking, mountain biking, point-of-interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 9:30 PM Tuesday: 6:00 AM – 9:30 PM Wednesday: 6:00 AM – 9:30 PM Thursday: 6:00 AM – 9:30 PM Friday: 6:00 AM – 9:30 PM Saturday: 6:00 AM – 9:30 PM Sunday: 6:00 AM – 9:30 PM	View Photos (4)
ChIJD0k1Bdwqv1QRKphf2ef14PI	Dry Canyon Trail	135 NW 9th St, Redmond, OR 97756, USA	44.2763800	-121.1835580	874 m		parks	establishment,park,point_of_interest	Page \| Maps			View Photos (4)