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

Previous Next

Page 23 of 26

Showing 551 to 575 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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	View Photos (1)
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, bars,cocktails,bars,cocktails,pubs,brewery,microbrewery, brewery, cocktails, microbrewery, pubs	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 585-5449	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)
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, bakeries,desserts,gift shops,shopping, 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, food trucks,restaurants,lunch,family friendly, 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	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2920480	-121.1705990	2,176 m		bakeries, bars,bakeries,juice bars, coffee shops, juice bars	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-3154	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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJFVsg_lMrv1QR8B_EHbOFCk4	Teresa Variel LMT	307 NW 7th St, Redmond, OR 97756, USA	44.2785480	-121.1756540	673 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 598-5832	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
ChIJWVC5uZErv1QRNibUxGNe-Nk	Terra Kitchen	509 SW 6th St, Redmond, OR 97756, USA	44.2723800	-121.1744230	48 m		cocktails, cocktails,restaurants,lunch,dining, desserts, dining, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 348-8101	View Hours Monday: Closed Tuesday: 4:00 – 8:00 PM Wednesday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Thursday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Friday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Saturday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJESyGgSUrv1QR4Mi5-iXwbUs	Testimony Wine Bar	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		bars, bars,cocktails,live music,bars,cocktails,live music,nightlife,pubs,winery,wine bar, cocktails, live music, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 400-1556	View Hours Monday: 3:00 – 7:00 PM Tuesday: Closed Wednesday: 2:00 – 8:00 PM Thursday: 1:00 – 8:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 2:00 – 6:00 PM	View Photos (4)
ChIJ_9vJoykrv1QRrLT-3CM76So	Thai O Restaurant	974 SW Veterans Way, Redmond, OR 97756, USA	44.2668320	-121.1789070	756 m		dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4883	View Hours Monday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Wednesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Thursday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Saturday: 4:30 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJQ8vqdVYrv1QRAvp0OzqM-j0	That Guy’s Bistro	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		bistros, food trucks, lunch, nightlife, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 521-9170	View Hours Monday: 11:30 AM – 8:00 PM Tuesday: Closed Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 8:00 PM	View Photos (4)
ChIJU7q3vtgqv1QRx0NS-JiVQKk	The Back Porch & Company	2127 S Hwy 97, Redmond, OR 97756, USA	44.2566580	-121.1821550	1,892 m		antiques, antiques,gift shops,thrift stores,vintage, shopping, vintage	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 526-1161	View Hours Monday: Closed 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: Closed	View Photos (4)
ChIJ2-PcF58rv1QRcnwAfnTwveY	The Burger Cart	845 SW 17th St, Redmond, OR 97756, USA	44.2690320	-121.1876970	1,167 m		dining, food trucks	restaurant,food,point_of_interest,establishment	Page \| Maps		View Hours Monday: Closed Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 7:00 PM	View Photos (4)
ChIJ783ygCUrv1QRRwXQuwX_b8A	The Chocolate Company	895 SW Rimrock Way #102, Redmond, OR 97756, USA	44.2689610	-121.1935080	1,612 m		bakeries, bakeries,desserts,gift shops, desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-8298	View Hours Monday: 11:00 AM – 5:30 PM Tuesday: 11:00 AM – 5:30 PM Wednesday: 11:00 AM – 5:30 PM Thursday: 11:00 AM – 5:30 PM Friday: 11:00 AM – 5:30 PM Saturday: 11:00 AM – 5:30 PM Sunday: Closed	View Photos (4)
ChIJNS0wQ5_dvlQRoIaJJfWhvSQ	The Cove Palisades State Park	The Cove Palisades State Park, Culver, OR 97734, USA	44.5428930	-121.2750710	31,108 m	outdoors	point of interest, state parks	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJ8zqIR4hznwoReHLWy8F2X7I	The Golden Hour Boutique	1368 SW 27th St, Redmond, OR 97756, USA	44.2634340	-121.1993340	2,267 m		boutiques	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 604-9886		View Photos (4)
ChIJu79b1hvVuFQR5PUPiDULpBo	The Jug Rock Gym	2605 S 1st St Unit 2, Redmond, OR 97756, USA	44.2520710	-121.1704180	2,302 m	recreation (edited)	rock climbing (edited)	establishment,point_of_interest,school	Page \| Maps \| Website	(541) 803-7625	View Hours Monday: 12:00 – 8:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 8:00 PM Thursday: 12:00 – 8:00 PM Friday: 12:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)