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

Previous Next

Page 20 of 24

Showing 476 to 500 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJjc6HNScrv1QRO2xbroQsfac	Spudbowl City Park	SW 15th St @, SW Black Butte Blvd, Redmond, OR 97756, USA	44.2752840	-121.1833910	810 m		parks, playgrounds	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 6:30 AM – 9:00 PM Friday: 6:30 AM – 9:00 PM Saturday: 6:30 AM – 9:00 PM Sunday: 6:30 AM – 9:00 PM	View Photos (4)
ChIJm3h5Lysrv1QRPI5Q-Q6IvmU	St. Vincent De Paul Thrift Store	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		shopping, thrift stores	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-9840	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 9:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJkYRUxO4qv1QRtBbjiXCA4vk	Stack Park	820 NW Kingwood Pl, Redmond, OR 97756, USA	44.2871550	-121.1770800	1,636 m		parks, playgrounds, state parks	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 8:00 AM – 6:00 PM Saturday: 8:00 AM – 6:00 PM Sunday: 8:00 AM – 6:00 PM	View Photos (4)
ChIJC1sVINYqv1QRSsXG481xViY	Starbucks (edited)	944 SW 9th St, Redmond, OR 97756, USA (edited)	44.2677300	-121.1761600	572 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,store,food,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-5100	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)
ChIJkQoHICUrv1QR7JDaRE-upUA	Starbucks	885 SW Rimrock Way, Redmond, OR 97756, USA	44.2689400	-121.1927900	1,557 m		breakfast, coffee shops, shopping	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-9679	View Hours Monday: 4:30 AM – 7:30 PM Tuesday: 4:30 AM – 7:30 PM Wednesday: 4:30 AM – 7:30 PM Thursday: 4:30 AM – 7:30 PM Friday: 4:30 AM – 7:30 PM Saturday: 5:00 AM – 7:00 PM Sunday: 5:00 AM – 7:00 PM	View Photos (3)
ChIJO-hUAJUrv1QRm6xAjtwZWXo	Starbucks	1830 NW 6th St, Redmond, OR 97756, USA	44.2936000	-121.1734000	2,333 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(689) 800-7044	View Hours Monday: 4:30 AM – 7:00 PM Tuesday: 4:30 AM – 7:00 PM Wednesday: 4:30 AM – 7:00 PM Thursday: 4:30 AM – 7:00 PM Friday: 4:30 AM – 7:00 PM Saturday: 5:00 AM – 7:00 PM Sunday: 5:00 AM – 7:00 PM	View Photos (4)
ChIJo91SskXSuFQRPh7s9eU3-8Q	Starbucks (edited)	1705 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA (edited)	44.2607500	-121.1795400	1,394 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,food,point_of_interest,store,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-4160	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 (3)
ChIJt2IOuSsrv1QRX1uuuvYxrCw	Starbucks	1400 SW Canal Blvd, Redmond, OR 97756, USA	44.2637100	-121.1776900	1,035 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 923-4188	View Hours Monday: 4:30 AM – 7:00 PM Tuesday: 4:30 AM – 7:00 PM Wednesday: 4:30 AM – 7:00 PM Thursday: 4:30 AM – 7:00 PM Friday: 4:30 AM – 7:00 PM Saturday: 5:00 AM – 7:00 PM Sunday: 5:00 AM – 7:00 PM	View Photos (4)
ChIJi_uRyIknv1QR0FuGWUeeQGY	Steelhead Falls	Deschutes River, Oregon, Terrebonne, OR 97760, USA	44.4164590	-121.2898970	18,463 m	outdoors	point-of-interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)
ChIJ79s0CZ8muVQR5Dc2mXeiD8E	Stillwater Campground	Stillwater Campground Rd, Prineville, OR 97754, USA	44.1450790	-120.8292970	30,913 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700	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)
ChIJ36THt83UuFQRjTogxZuxZIk	Subway	2209 S Hwy 97, Redmond, OR 97756, USA	44.2557130	-121.1823430	1,996 m		lunch	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-5814	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)
ChIJ89MmB_Itv1QRnjL8htvqMWU	Summit Crest Neighborhood Park	4892 SW Volcano Ave, Redmond, OR 97756, USA	44.2480920	-121.2262990	4,984 m		parks	establishment,park,point_of_interest	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
ChIJKR4OuSrXvlQR0fsZ1xzjlnI	Sungrounded Farm	211 NE Wilcox Ave, Terrebonne, OR 97760, USA	44.3568580	-121.1663450	9,386 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 604-8009		View Photos (4)
ChIJKXn1NgDTuFQRVM_ndFU9MIE	Sunriver Brewing Co – Redmond Pub	3750 SW Badger Ave, Redmond, OR 97756, USA	44.2371930	-121.2125430	4,998 m		bars, brewery, cocktails, microbrewery, pubs	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 585-5449	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJcW-Sam0rv1QR9ECnVg5Zqlo	Sunshine Wellness	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2663330	-121.1681220	838 m		wellness center	establishment,health,point_of_interest,spa	Page \| Maps	(541) 678-2826		No photos available
ChIJZwSilLvUuFQRrJpyclLAueA	Super 8 by Wyndham Redmond (edited)	3629 SW 21st Pl, Redmond, OR 97756, USA (edited)	44.2427590	-121.1914310	3,601 m	hotels-motels,rv-parks-camping (edited)	hotels,motels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-8881	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)
ChIJo3Pt7_IVv1QRGvAy6B6lC78	Suttle Lake	Suttle Lake, Oregon 97759, USA	44.4250720	-121.7329210	47,572 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJH87OW_ndvlQRFwvcFQzhXG8	SW Jordan Bridge	SW Jordan Rd, Terrebonne, OR 97760, USA	44.5288570	-121.2646800	29,390 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps		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)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4645	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJw3eUFgIrv1QR1Im-STuPNPk	Sweet and Salty Shoppe	738 SW Highland Ave, Redmond, OR 97756, USA	44.2694640	-121.1762380	397 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 604-1062		View Photos (4)
ChIJVV7i9Nkqv1QRyWHlBp2qjGU	Sweet Oasis Chocolate Shop	535 SW 6th St, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		bakeries, desserts	establishment,food,point_of_interest,store	Page \| Maps	(541) 408-0821	View Hours Monday: Closed Tuesday: 11:00 AM – 6:00 PM Wednesday: 11:00 AM – 6:00 PM Thursday: 11:00 AM – 6:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJvywcSRErv1QRSSNO5F2LZAc	Tacos El Poblanito	404 SW Forest Ave, Redmond, OR 97756, USA	44.2713590	-121.1724040	185 m		food trucks, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 279-3145	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJebCqymldv1QR2ivpC1qxzWI	Tamolitch Falls (Blue Pool)	National Forest Road 2672-655, McKenzie Bridge, OR 97413, USA	44.3120370	-122.0270490	68,043 m	outdoors	point-of-interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3381	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)
ChIJIU_noaorv1QRj1XuAFfRx68	TeaCupFuls	Inside Walmart, 300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2920480	-121.1705990	2,176 m		bakeries, coffee shops, juice bars	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-3154	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)