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

Previous Next

Page 20 of 29

Showing 476 to 500 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ3b8T0ZYrv1QRx88GFPBG6HA	Pink Sprinkled Bakery	858 NW Redwood Ave, Redmond, OR 97756, USA	44.3002400	-121.1773270	3,083 m		bakeries, bakeries,desserts,bakeries,desserts, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 350-7954	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ57m4d3wrv1QR2OOtqOYrRWk	Playground	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2674800	-121.1908150	1,461 m		playgrounds	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ9csSlychuVQRhXmYz4C4QRc	Poison Butte Campground	OR-27, Prineville, OR 97754, USA	44.1204050	-120.7982720	34,399 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)
ChIJ5f71FJvVvlQR8PWtPXIt0Gs	Poppy Farms, LLC	6945 NE 11th St, Redmond, OR 97756, USA	44.3395310	-121.1568310	7,563 m		farms	establishment,point_of_interest	Page \| Maps	(541) 663-6352	View Hours Monday: 7:00 AM – 9:00 PM Tuesday: 7:00 AM – 9:00 PM Wednesday: 7:00 AM – 9:00 PM Thursday: 7:00 AM – 9:00 PM Friday: 7:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 9:00 PM	View Photos (1)
ChIJJ1BVuNkqv1QRWc322019HaA	Possibilities Thrift Store Redmond	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458090	-121.1885220	3,200 m		antiques, antiques,thrift stores,vintage,antiques,thrift stores,vintage, thrift stores, vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJMwqh-f4juVQRppulN5J4yqQ	Post Pile Campground	OR-27, Prineville, OR 97754, USA	44.1289380	-120.8005150	33,783 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)
ChIJ7wDCYTrTuFQRf_C6jwTzPZg	Precise Rifle Solutions	5637 SW Harvest Ave, Redmond, OR 97756, USA	44.2285230	-121.2360230	6,965 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 728-1952	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJVVWxKksrv1QRks360QBDPPg	Prescott Honey	2668 SW Salmon Ave, Redmond, OR 97756, USA	44.2544860	-121.1988540	2,830 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 977-8848		No photos available
ChIJY7x3pWcrv1QRH7zW0Ps6WwM	Provisions Market at SCP Redmond	521 SW 6th St, Redmond, OR 97756, USA	44.2722780	-121.1745490	63 m		bakeries, breakfast, coffee shops, coffee shops,restaurants,breakfast,lunch,dining,family friendly,gift shops,shopping,coffee shops,restaurants,breakfast,lunch,dining,family friendly, dining, family friendly, gift shops, lunch, restaurants, shopping	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 508-7600	View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJ_-zwLdBQv1QRYNW5J1HOkrk	Proxy Falls	Proxy Falls, Oregon 97413, USA	44.1617860	-121.9278260	61,332 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJ-1q8LQArv1QRVMod9zsK488	PSALM @ 122	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,restaurants,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 647-9068	View Hours Monday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Wednesday: Closed Thursday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Saturday: 4:00 – 8:00 PM Sunday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM	View Photos (4)
ChIJI8dU-Nkqv1QRzkhUMKKZY6Q	Public Information Verification, LLC	Redmond, OR 97756, USA	44.2726580	-121.1739210	4 m		point of interest	establishment,point_of_interest	Page \| Maps	(877) 605-7710		No photos available
ChIJoQqCnRLWvlQRfmshx3JloYU	Pump House Bar & Grill	8320 US-97, Terrebonne, OR 97760, USA	44.3518410	-121.1783370	8,816 m		bars, cocktails, live music, nightlife, pubs, restaurants, restaurants,bars,cocktails,live music,nightlife,pubs,dining	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 287-4393	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJp3WRIwAtuVQRqq2plUKH1Lk	Quadruple Bypass Trailhead – 66 Trail System	Crook County, OR 97754, USA	44.3039340	-120.8873490	23,075 m		mountain biking	establishment,park,point_of_interest	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)
ChIJvVgVBYkrv1QRTWxDHj7vyRY	Quartz Park	2027 SW Quartz Ave, Redmond, OR 97756, USA	44.2588760	-121.1902130	2,005 m		parks, parks,playgrounds,parks,playgrounds, playgrounds	establishment,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)
ChIJV8lcm_Erv1QRtdSqhyCKfIM	Quartz park skate spot	2027 SW Quartz Ave, Redmond, OR 97756, USA	44.2594200	-121.1894200	1,918 m		parks	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
ChIJzd47LvUqv1QRJqG9EjI_VZM	Quince Park	1195 NW Quince Ave, Redmond, OR 97756, USA	44.2985540	-121.1803610	2,929 m		parks, parks,playgrounds,parks,playgrounds,tourist attraction, playgrounds	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 504-2000	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: 6:00 AM – 9:00 PM	View Photos (4)
ChIJT3xI-GQrv1QRcMXk4wMNo4U	Rachel Mitzel, PMHNP-BC, CRNA	145 SW 6th St, Redmond, OR 97756, USA	44.2758260	-121.1745350	360 m		wellness center	doctor,establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 699-6128	View Hours Monday: 9:00 AM – 2:30 PM Tuesday: 9:00 AM – 2:30 PM Wednesday: 9:00 AM – 2:30 PM Thursday: 9:00 AM – 2:30 PM Friday: 9:00 AM – 2:30 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJrXpiFPDWvlQRG-3o3C_xDZc	Ranch at the Canyons	11050 Vineyard Way, Terrebonne, OR 97760, USA	44.3671610	-121.1576830	10,592 m	beer-wine-spirits (edited)	wine bar (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-6020	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJcRSJ_xsrv1QRMSEW7IGnoNI	Red Beard Barbecue	652 NW 7th St, Redmond, OR 97756, USA	44.2818600	-121.1750010	1,031 m		food trucks, lunch, restaurants	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 420-7928	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJfVNbQNoqv1QRqiP6Sq4zUCU	Red Road Pizza Cart	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		brewery, brewery,food trucks, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 639-5366	View Hours Monday: Closed 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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: Closed	View Photos (4)
ChIJPysfqIUrv1QRq6ZOE9Lje2I	Redefined Wellness	405 SW 6th St, Redmond, OR 97756, USA	44.2733190	-121.1745720	93 m		spas, spas,wellness center	establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 527-7535	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: 8:00 AM – 1:00 PM Sunday: Closed	View Photos (4)
ChIJmQ339SLVuFQR8BblLnQMm7o	Redmond Air Center	1740 SE Ochoco Way, Redmond, OR 97756, USA	44.2606240	-121.1476130	2,483 m	family-friendly (edited)	tours (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-7200	View Hours Monday: 7:45 AM – 4:30 PM Tuesday: 7:45 AM – 4:30 PM Wednesday: 7:45 AM – 4:30 PM Thursday: 7:45 AM – 4:30 PM Friday: 7:45 AM – 4:30 PM Saturday: Closed Sunday: Closed	No photos available
ChIJ_THn_9kqv1QRWktUgL14nsg	Redmond Antique Mall	106 SE Evergreen Ave Ste M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, antiques,shopping,thrift stores,vintage,antiques,shopping,thrift stores,vintage, shopping, thrift stores, vintage	establishment,furniture_store,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6208	View Hours Monday: 10:30 AM – 5:30 PM Tuesday: 10:30 AM – 5:30 PM Wednesday: 10:30 AM – 5:30 PM Thursday: 10:30 AM – 5:30 PM Friday: 10:30 AM – 5:30 PM Saturday: 10:30 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJqcIV0cvUuFQRET-QkeZuwpY	Redmond Area Park and Recreation District	465 SW Rimrock Way, Redmond, OR 97756, USA	44.2732850	-121.1905440	1,326 m		parks, parks,playgrounds,parks,playgrounds,rv parks, playgrounds	establishment,point_of_interest	Page \| Maps \| Website	(541) 548-7275	View Hours Monday: 5:00 AM – 9:00 PM Tuesday: 5:00 AM – 9:45 PM Wednesday: 5:00 AM – 9:00 PM Thursday: 5:00 AM – 9:00 PM Friday: 5:00 AM – 9:00 PM Saturday: 1:00 – 5:00 PM Sunday: 12:00 – 3:30 PM	View Photos (3)