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: 21
Limit per Page: 25
Offset: 500
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 500, 25

Previous Next

Page 21 of 24

Showing 501 to 525 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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, desserts, dining, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 348-8101	View Hours Monday: Closed Tuesday: 4:00 – 8:30 PM Wednesday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Thursday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Friday: 11:30 AM – 2:00 PM, 4:00 – 9:00 PM Saturday: 11:30 AM – 2:00 PM, 4:00 – 9:00 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, cocktails, live music, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 526-7979	View Hours Monday: 3:00 – 7:00 PM Tuesday: Closed Wednesday: 2:00 – 8:00 PM Thursday: 2: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 and Company	2127 S Hwy 97, Redmond, OR 97756, USA	44.2566580	-121.1821550	1,892 m		antiques, 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)
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,establishment,food,point_of_interest,store	Page \| 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, 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, 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)
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)	Page \| Maps \| Website (edited)	(541) 516-3990	View Hours Monday: 6:00 AM – 9:00 PM Tuesday: 6:00 AM – 9:00 PM Wednesday: 6:00 AM – 9:00 PM Thursday: 6:00 AM – 9:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 6:00 AM – 9: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)	establishment,point_of_interest,school	Page \| Maps \| Website	(541) 803-7625	View Hours Monday: 10:00 AM – 8:00 PM Tuesday: 10:00 AM – 8:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 6: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, 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)
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,establishment,point_of_interest,store	Page \| 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,establishment,point_of_interest,store	Page \| Maps \| Website			View Photos (1)
ChIJMQ4S-5Msv1QRW6O70jki7ng	The Lodge at Eagle Crest	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2607220	-121.2625140	7,177 m		hotels, 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		food trucks, 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, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	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.2488200	-121.1729740	2,648 m		breakfast, restaurants	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 – 8: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 lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4653	View Hours Monday: 8:30 PM – 12:00 AM Tuesday: 8:30 PM – 12:00 AM Wednesday: 8:30 PM – 12:00 AM Thursday: 8:30 PM – 12:00 AM Friday: 8:30 PM – 12:00 AM Saturday: 8:30 PM – 12:00 AM Sunday: 12:00 AM – 6:30 PM, 8:30 PM – 12:00 AM	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: Closed Thursday: Closed Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)