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

Previous Next

Page 24 of 29

Showing 576 to 600 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJsfutgsUrv1QRyH1kInXquI0	Small Town Coffee Co.	900 NW Spruce Tree Pl, Redmond, OR 97756, USA	44.3020790	-121.1775090	3,288 m		coffee shops	cafe,establishment,food,point_of_interest	Page \| Maps \| Website	(971) 300-9469	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: Closed	View Photos (4)
ChIJNRyDaIjWvlQRVIFe3-jH69g	Smith Rock	Smith Rock, Oregon 97760, USA	44.3612310	-121.1495880	10,041 m		rock climbing	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJh_C1tYXWvlQRE8jo4FVQJf8	Smith Rock Bivouac Area (The Bivy) (edited)	Terrebonne, OR 97760, USA (edited)	44.3608420	-121.1410040	10,153 m	recreation,outdoors,rv-parks-camping (edited)	camping,rock climbing,state park (edited)	campground,lodging,park,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-7501		View Photos (4)
ChIJy0D6fH4rv1QRGnOfHmBix98	Smith Rock BMX	1935 NE Maple Ave, Redmond, OR 97756, USA	44.2912600	-121.1455990	3,062 m		mountain biking	establishment,point_of_interest	Page \| Maps \| Website	(541) 316-0005		View Photos (4)
ChIJH8jLKpLWvlQRon0OlkWRbXg	Smith Rock Climbing Guides	9297 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606920	-121.1385530	10,189 m		rock climbing	establishment,point_of_interest,school	Page \| Maps \| Website	(541) 788-6225	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJOYjHWdAqv1QRZbzXuJ6MdlU	Smith Rock Coffee Roasters	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 699-1964		View Photos (4)
ChIJeQE_c5kqv1QRNvA6yP2rCdE	Smith Rock Golf Course & Driving Range	1401 NE Maple Ave, Redmond, OR 97756, USA	44.2925930	-121.1515710	2,846 m		driving range	establishment,point_of_interest	Page \| Maps	(541) 923-3426		View Photos (4)
ChIJF3qCDnvWvlQRd8o4Qwdlu2c	Smith Rock Ranch	1250 NE Wilcox Ave, Terrebonne, OR 97760, USA	44.3552730	-121.1513700	9,364 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-1414	View Hours Monday: Closed Tuesday: 12:00 – 6:00 PM Wednesday: 12:00 – 6:00 PM Thursday: 12:00 – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJHcjLKpLWvlQRl17g5s7mOGQ	Smith Rock State Park	CROOKED RIVER, OR 97760, USA	44.3682460	-121.1405810	10,959 m	outdoors	hiking, mountain biking, parks, point of interest, rock climbing, state parks, state parks,hiking,mountain biking,rock climbing,parks,state parks,hiking,mountain biking,rock climbing,tourist attraction, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJQUyFQFPXvlQR-LS_xFdfMqM	Smith Rock State Park Welcome Center	CROOKED RIVER, OR 97760, USA	44.3658890	-121.1373730	10,771 m		state parks, state parks,rock climbing	establishment,point_of_interest,travel_agency	Page \| Maps \| Website		View Hours Monday: 8:00 AM – 1:00 AM Tuesday: Closed Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 4:00 PM Sunday: 8:00 AM – 4:00 PM	View Photos (4)
ChIJmwluEQbZvlQRj1kzGEwsj7k	Smith Rock Trail Rides	20890a NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 604-6769	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: 7:00 AM – 7:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJq4LmROkqv1QRlXojK1yuw7w	Sno-Cap Drive In Redmond	1053 NW 6th St, Redmond, OR 97756, USA	44.2863570	-121.1743480	1,528 m		bars, bars,pubs,desserts,family friendly,bars,pubs,desserts, desserts, family friendly, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-2343	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJa_YtIysrv1QR9MS6eYVxv8I	Society of Saint Vincent de Paul Redmond – Food Distribution Center	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		thrift stores	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 923-5264	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 1:30 PM Thursday: 10:00 AM – 1:30 PM Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJsWHRMI0qv1QRDAg2Iqp7fW8	Sonic Drive-In	500 NW Oak tree Ln, Redmond, OR 97756, USA	44.2942140	-121.1732090	2,402 m		bars	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 526-5855	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 12:00 AM Saturday: 8:00 AM – 12:00 AM Sunday: 8:00 AM – 11:00 PM	View Photos (4)
ChIJwR4Q3HXVuFQR3Z8mr4Xu-zA	Sora Sushi	3853 SW 21st St Ste 109, Redmond, OR 97756, USA	44.2404830	-121.1939890	3,915 m		bars, bars,pubs, pubs, restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-9867	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: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJg_ejsu4rv1QRukipX9Gq6VE	Sourcito	915 SW Rimrock Way Ste 202, Redmond, OR 97756, USA	44.2679560	-121.1931330	1,615 m		desserts	establishment,food,point_of_interest,store	Page \| Maps			View Photos (1)
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJjc6HNScrv1QRO2xbroQsfac	Spudbowl City Park	SW 15th St @, SW Black Butte Blvd, Redmond, OR 97756, USA	44.2752840	-121.1833910	810 m		parks, parks,playgrounds,rock climbing,parks,playgrounds,rock climbing, playgrounds, rock climbing	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 6:30 AM – 9:00 PM Friday: 6:30 AM – 9:00 PM Saturday: 6:30 AM – 9:00 PM Sunday: 6:30 AM – 9:00 PM	View Photos (4)
ChIJm3h5Lysrv1QRPI5Q-Q6IvmU	St. Vincent De Paul Thrift Store	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		antiques, antiques,thrift stores,antiques,thrift stores,vintage, shopping, thrift stores	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-9840	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 9:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJvXiWadArv1QRfMl_xU_ABxM	Stable Inn & Mountain View POA’s	3099 NW Williams Way, Redmond, OR 97756, USA	44.3270550	-121.2040260	6,510 m		horseback rides	establishment,point_of_interest,tourist_attraction,travel_agency	Page \| Maps \| Website	(541) 419-6445	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)
ChIJkYRUxO4qv1QRtBbjiXCA4vk	Stack Park	820 NW Kingwood Pl, Redmond, OR 97756, USA	44.2871550	-121.1770800	1,636 m		hiking, parks, parks,playgrounds,hiking,parks,playgrounds,hiking,tourist attraction, playgrounds, state parks	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	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)
ChIJC1sVINYqv1QRSsXG481xViY	Starbucks (edited)	944 SW 9th St, Redmond, OR 97756, USA (edited)	44.2677300	-121.1761600	572 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,store,food,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-5100	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: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJo91SskXSuFQRPh7s9eU3-8Q	Starbucks (edited)	1705 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA (edited)	44.2607500	-121.1795400	1,394 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,food,point_of_interest,store,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-4160	View Hours Monday: 6:00 AM – 6:00 PM Tuesday: 6:00 AM – 6:00 PM Wednesday: 6:00 AM – 6:00 PM Thursday: 6:00 AM – 6:00 PM Friday: 6:00 AM – 6:00 PM Saturday: 6:00 AM – 6:00 PM Sunday: 6:00 AM – 6:00 PM	View Photos (3)
ChIJkQoHICUrv1QR7JDaRE-upUA	Starbucks Coffee Company	885 SW Rimrock Way, Redmond, OR 97756, USA	44.2689400	-121.1927900	1,557 m		breakfast, coffee shops, shopping	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-9679	View Hours Monday: 4:30 AM – 8:00 PM Tuesday: 4:30 AM – 8:00 PM Wednesday: 4:30 AM – 8:00 PM Thursday: 4:30 AM – 8:00 PM Friday: 4:30 AM – 8:00 PM Saturday: 4:30 AM – 9:00 PM Sunday: 4:30 AM – 9:00 PM	View Photos (4)
ChIJO-hUAJUrv1QRm6xAjtwZWXo	Starbucks Coffee Company	1830 NW 6th St, Redmond, OR 97756, USA	44.2936000	-121.1734000	2,333 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(689) 800-7044	View Hours Monday: 4:30 AM – 9:00 PM Tuesday: 4:30 AM – 9:00 PM Wednesday: 4:30 AM – 9:00 PM Thursday: 4:30 AM – 9:00 PM Friday: 4:30 AM – 9:00 PM Saturday: 5:00 AM – 9:00 PM Sunday: 5:00 AM – 9:00 PM	View Photos (4)