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: 26
Limit per Page: 25
Offset: 625
Total Pages: 29

Results:

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

Previous Next

Page 26 of 29

Showing 626 to 650 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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,antiques,gift shops,thrift stores,vintage, gift shops, shopping, thrift stores, 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,gift shops, desserts, gift shops	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, state parks,koa	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)
ChIJZ1h4WgDPuFQRMXmbDnhyUg0	The Landing	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		brewery, brewery,food trucks, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 12:00 – 10:00 PM Saturday: 12:00 – 10:00 PM Sunday: 12:00 – 9:30 PM	View Photos (4)
ChIJMQ4S-5Msv1QRW6O70jki7ng	The Lodge at Eagle Crest	1522 SW Cline Falls Rd, Redmond, OR 97756, USA	44.2607220	-121.2625140	7,177 m		hotels, hotels,resorts,golf courses, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(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, family friendly, food trucks, food trucks,restaurants,lunch,dining,family friendly,food trucks,restaurants,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 380-0283	View Hours Monday: Closed 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: Closed	View Photos (4)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs,restaurants,breakfast,lunch,dining, breakfast, cocktails, dining, live music, lunch, nightlife, pool tables, pubs, restaurants	bar,establishment,point_of_interest	Page \| 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, dining, restaurants, restaurants,breakfast,dining,restaurants,breakfast,dining	establishment,food,point_of_interest,restaurant	Page \| 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, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 460-0144	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 10: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	establishment,point_of_interest	Page \| 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)
ChIJJbJ295Ysv1QRK0dYiUZ9UoA	The Resort Course at Eagle Crest	7300 Robin Ct, Redmond, OR 97756, USA	44.2596380	-121.2575350	6,813 m		driving range, golf courses, golf courses,golf lessons,driving range, golf lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4653	View Hours Monday: 6:15 AM – 8:15 PM Tuesday: 6:15 AM – 8:15 PM Wednesday: 6:15 AM – 8:15 PM Thursday: 6:15 AM – 8:15 PM Friday: 6:15 AM – 8:15 PM Saturday: 6:15 AM – 8:15 PM Sunday: 6:15 AM – 8:15 PM	View Photos (4)
ChIJFWK3Ejt6z1QR5gwhhjRBRkA	The Rogue Chef Breakfast	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		breakfast, food trucks	establishment,food,point_of_interest,restaurant	Page \| 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,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:00 – 8:00 PM Thursday: 4:00 – 8:00 PM Friday: 4:00 – 8:00 PM Saturday: 4:00 – 8: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	establishment,point_of_interest	Page \| 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	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 923-9647		View Photos (3)
ChIJkbM2nI8rv1QROyeG0x0jnoQ	The Style Haus	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 279-9332	View Hours Monday: Closed Tuesday: 11:00 AM – 5:00 PM 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)
ChIJRfWqF-fdvlQR0gBWuK9P83g	The Tam-a-lau Trailhead	7255-7399 SW Jordan Rd, Terrebonne, OR 97760, USA	44.5352650	-121.2841870	30,490 m		hiking, hiking,trailheads,hiking,trailheads, trailheads	establishment,point_of_interest	Page \| Maps \| Website	(541) 546-3412	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJY1d2YAArv1QRaIDqBc-J_DA	The Vault Taphouse	245 SW 6th St, Redmond, OR 97756, USA	44.2748000	-121.1745060	247 m		bars,nightlife,pubs	bar,establishment,point_of_interest	Page \| Maps		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 – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 12:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	No photos available
ChIJo7EHWZnUuFQRP9qNAv98w7c	The View Tap and Grill	1938 SW Elkhorn Ave Drive, Redmond, OR 97756, USA	44.2316880	-121.1911680	4,754 m		bars, bars,cocktails,bars,cocktails,breakfast,dining,cocktails,breakfast,dining, breakfast, cocktails, dining, lunch, pubs, restaurants, wine bar, winery	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3121	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)
ChIJTSL70-7VuFQR_I_lnjsS0VI	The Well Oiled Machine Drive Thru Delicatessen	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2518540	-121.1891000	2,606 m		breakfast, coffee shops, coffee shops,breakfast,lunch,coffee shops,restaurants,breakfast,lunch,dining, juice bars, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 527-1937	View Hours Monday: Closed Tuesday: 6:00 AM – 3:00 PM Wednesday: 6:00 AM – 3:00 PM Thursday: 6:00 AM – 3:00 PM Friday: 6:00 AM – 3:00 PM Saturday: 8:00 AM – 2:00 PM 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, massage,spas, spas	establishment,point_of_interest	Page \| 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	establishment,point_of_interest	Page \| Maps			View Photos (3)