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: 24
Limit per Page: 25
Offset: 575
Total Pages: 27

Results:

Total Available Records: 659
Total After Limits: 659
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 575, 25

Previous Next

Page 24 of 27

Showing 576 to 600 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJoQ7j-Corv1QRWYS8Tp9eBfE	The Buggy Stop Market	1280 NW 6th St, Redmond, OR 97756, USA	44.2883480	-121.1735000	1,749 m		desserts, grocery stores, juice bars	convenience_store,food,store,point_of_interest,establishment	Maps	(541) 923-8506	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: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	No photos available
ChIJ2-PcF58rv1QRcnwAfnTwveY	The Burger Cart	845 SW 17th St, Redmond, OR 97756, USA	44.2690320	-121.1876970	1,167 m		dining, family friendly, food trucks, lunch	restaurant,food,point_of_interest,establishment	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 (edited)	895 SW Rimrock Way #102, Redmond, OR 97756, USA (edited)	44.2689610	-121.1935080	1,612 m	shopping (edited)	desserts, shopping, gift shops (edited)	store,food,point_of_interest,establishment,shopping (edited)	Maps \| Website (edited)	(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	No photos available
ChIJNS0wQ5_dvlQRoIaJJfWhvSQ	The Cove Palisades State Park	The Cove Palisades State Park, Culver, OR 97734, USA	44.5428930	-121.2750710	31,108 m	outdoors	campgrounds, fishing, hiking, koa, point-of-interest, rv parks, state parks	park,point_of_interest,establishment	Maps \| Website	(800) 551-6949		View Photos (4)
ChIJ5YiuUtt1CC0RrWzawLAIrSc	The Crow’s Croft LLC	9015 S Hwy 97, Redmond, OR 97756, USA	44.1920770	-121.2380260	10,310 m		farms	point_of_interest,establishment	Maps \| Website	(541) 604-0686		View Photos (3)
ChIJ8zqIR4hznwoReHLWy8F2X7I	The Golden Hour Boutique	1368 SW 27th St, Redmond, OR 97756, USA	44.2634340	-121.1993340	2,267 m		boutiques	clothing_store,store,point_of_interest,establishment	Maps \| Website	(541) 604-9886		View Photos (4)
ChIJv9hJEIwqv1QRT6v_SPRxFKk	The Home Depot (edited)	300 NW Quince Ave, Redmond, OR 97756, USA (edited)	44.2972040	-121.1707820	2,745 m	golf (edited)	Hardware (edited)	hardware_store,furniture_store,home_goods_store,point_of_interest,store,establishment (edited)	Maps \| Website (edited)	(541) 516-3990	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: 7:00 AM – 8:00 PM	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)	point_of_interest,establishment	Maps \| Website	(541) 803-7625	View Hours Monday: 9:00 AM – 9:00 PM Tuesday: 9:00 AM – 9:00 PM Wednesday: 9:00 AM – 9:00 PM Thursday: 9:00 AM – 9:00 PM Friday: 9:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: 9:00 AM – 9:00 PM	View Photos (4)
ChIJE0Majq4rv1QRZuiBkpvA9vw	The Little Free Book Library #75390	568 NW 27th St, Redmond, OR 97756, USA	44.2807030	-121.1989920	2,189 m		bookstores	book_store,store,point_of_interest,establishment	Maps \| Website			View Photos (1)
ChIJdUAZls4tv1QRlop_Q4MJEk8	The Little Free Library #90815	2903 Southwest 50th Street, Redmond, OR 97756, USA	44.2484920	-121.2288260	5,130 m		bookstores	book_store,store,point_of_interest,establishment	Maps \| Website			View Photos (1)
ChIJMQ4S-5Msv1QRW6O70jki7ng	The Lodge at Eagle Crest (edited)	1522 Cline Falls Road, Redmond, OR 97756, USA (edited)	44.2608900	-121.2628700	7,202 m		hotels (edited)	lodging,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 923-2453		View Photos (4)
ChIJFelkhMErv1QRj0q9yVB8BdA	The Mighty Greek	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		dining, food trucks, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(503) 380-0283	View Hours Monday: Closed Tuesday: Closed 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: Closed	View Photos (4)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m		bars, breakfast, cocktails, dining, live music, lunch, nightlife, pool tables, pubs, restaurants, wine bars	bar,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 548-3731	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJ01L9jMTUuFQRT_0H9QOak8k	The Original Pancake House Redmond	3030 SW 6th St, Redmond, OR 97756, USA	44.2487230	-121.1729600	2,658 m		breakfast, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 316-2515	View Hours Monday: 6:00 AM – 2:00 PM Tuesday: 6:00 AM – 2:00 PM Wednesday: 6:00 AM – 2:00 PM Thursday: 6:00 AM – 2:00 PM Friday: 6:00 AM – 2:00 PM Saturday: 6:00 AM – 2:00 PM Sunday: 6:00 AM – 2:00 PM	View Photos (4)
ChIJmzvwdTIrv1QRzT5vr2KiJSg	The Original Peruvian Food & Minimarket	1530 S Hwy 97, Redmond, OR 97756, USA	44.2618670	-121.1774720	1,229 m		desserts, dining, family friendly, restaurants	restaurant,food,point_of_interest,establishment	Maps	(541) 460-0144	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)
ChIJt7CAXJ4qv1QRmWDMsvLPYCk	The Radlands	1859 NE Maple Ave, Redmond, OR 97756, USA	44.2919890	-121.1461790	3,085 m	outdoors	mountain biking, point-of-interest	point_of_interest,establishment	Maps		View Hours Monday: 6:00 AM – 7:30 PM Tuesday: 6:00 AM – 7:30 PM Wednesday: 6:00 AM – 7:30 PM Thursday: 6:00 AM – 7:30 PM Friday: 6:00 AM – 7:30 PM Saturday: 6:00 AM – 7:30 PM Sunday: 6:00 AM – 7:30 PM	View Photos (4)
ChIJFWK3Ejt6z1QR5gwhhjRBRkA	The Rogue Chef Breakfast	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		breakfast, dining, food trucks	restaurant,food,point_of_interest,establishment	Maps	(541) 678-2559	View Hours Monday: 7:00 AM – 12:00 PM Tuesday: 7:00 AM – 12:00 PM Wednesday: 7:00 AM – 12:00 PM Thursday: 7:00 AM – 12:00 PM Friday: 7:00 AM – 12:00 PM Saturday: 7:00 AM – 12:00 PM Sunday: Closed	View Photos (4)
ChIJmdc9yMYrv1QRqWkW-OrnumI	The Rooftop at SCP Redmond	restaurants (edited)	44.2721630	-121.1745910	74 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,restaurant,point_of_interest,food,establishment	Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJyUYfxZgrv1QRobNKc04mWw4	The Sanctuary Event Space	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		event venues	point_of_interest,establishment	Maps \| Website	(541) 526-7979	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ4U2cUocsv1QRPqv0WHUDzoQ	The Spa at Eagle Crest	8100 Coopers Hawk Dr, Redmond, OR 97756, USA	44.2633950	-121.2704170	7,752 m		spas	spa,point_of_interest,establishment	Maps \| Website	(541) 923-9647		View Photos (3)
ChIJRfWqF-fdvlQR0gBWuK9P83g	The Tam-a-lau Trailhead	7255-7399 SW Jordan Rd, Terrebonne, OR 97760, USA	44.5352650	-121.2841870	30,490 m		hiking, state parks	park,point_of_interest,establishment	Maps \| Website	(541) 546-3412	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)
ChIJo7EHWZnUuFQRP9qNAv98w7c	The View Tap and Grill (edited)	1938 SW Elkhorn Ave Drive, Redmond, OR 97756, USA (edited)	44.2316880	-121.1911680	4,754 m		dining, lunch, pubs, restaurants, wine bars, winery (edited)	restaurant,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 548-3121	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJTSL70-7VuFQR_I_lnjsS0VI	The Well Oiled Machine Drive Thru Delicatessen	2600 Canal Blvd, Redmond, OR 97756, USA	44.2518540	-121.1891000	2,606 m		breakfast, coffee shops, grocery stores, juice bars, lunch	cafe,store,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 527-1937	View Hours Monday: Closed Tuesday: 7:00 AM – 4:00 PM Wednesday: 7:00 AM – 4:00 PM Thursday: 7:00 AM – 4:00 PM Friday: 7:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ-YwJ1WMrv1QRY6ZnNeA-Hq8	The Well Table located in Ola Day Spa	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2520490	-121.1887500	2,574 m		massage, spas	point_of_interest,establishment	Maps \| Website	(541) 504-5215	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:15 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:15 PM Friday: 9:00 AM – 2:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJYW3hHADXvlQRXuymABvPYeY	The Zoo Climbing	9VJP+JQ, Terrebonne, OR 97760, USA	44.3815400	-121.1130800	13,042 m		rock climbing	point_of_interest,establishment	Maps			View Photos (3)