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: 11
Limit per Page: 25
Offset: 250
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 250, 25

Previous Next

Page 11 of 24

Showing 251 to 275 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJmamRNQDZvlQRh-k2PjmDd9w	Heritage House Old Mine & Water Works	6710 S W Ranch House Pl, Crooked River Ranch, OR 97760, USA	44.4477330	-121.2635920	20,736 m		historic landmarks	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJbeu6H9oqv1QRIi46_pG0Z0o	Herringbone Books	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores, shopping	book_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1491	View Hours Monday: 9:30 AM – 6:00 PM Tuesday: 9:30 AM – 6:00 PM Wednesday: 9:30 AM – 6:00 PM Thursday: 9:30 AM – 6:00 PM Friday: 9:30 AM – 6:00 PM Saturday: 9:30 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJI8dU-Nkqv1QRH2auKTBRV3w	Hertz Car Rental – Roberts Field Airport Hle	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2539050	-121.1598220	2,365 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-1411	View Hours Monday: 8:00 AM – 1:00 AM Tuesday: 8:00 AM – 1:00 AM Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 AM Friday: 8:00 AM – 1:00 AM Saturday: 8:00 AM – 1:00 AM Sunday: 8:00 AM – 1:00 AM	View Photos (4)
ChIJo4ai9hgrv1QRgtz5-j3Dcuk	Hideaway Redmond	507 SW 8th St, Redmond, OR 97756, USA	44.2723770	-121.1766400	218 m		bars, breakfast, cocktails, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-5989	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 – 11:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJ7bLUIkLTuFQRv1Pg9pJ-rFw	High Desert Farms Nursery Sales	5180 SW Canal Blvd, Redmond, OR 97756, USA	44.2283820	-121.2218650	6,227 m		farms	establishment,point_of_interest	Page \| Maps	(541) 548-5020	View Hours Monday: Closed 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: 9:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJe3_e_nkrv1QR4qPHcygIUO8	High Desert Music Hall	818 SW Forest Ave, Redmond, OR 97756, USA	44.2712410	-121.1767350	272 m		event venues, food trucks, live music	establishment,point_of_interest	Page \| Maps \| Website	(541) 527-1387		View Photos (4)
ChIJ0bDcnyQrv1QRMLBMPuAVSVs	Highland Grub and Go	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697810	-121.1853190	961 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 5:00 AM – 8:00 PM Tuesday: 5:00 AM – 8:00 PM Wednesday: 5:00 AM – 8:00 PM Thursday: 5:00 AM – 8:00 PM Friday: 5:00 AM – 8:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 8:00 PM	View Photos (4)
ChIJSbrw9PrJuFQR2hiNzKwfcU8	Historic Old Cabin Ruins	Deschutes County, OR 97703, USA	44.1033890	-121.3393840	22,982 m		historic landmarks	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJl9tzmsIqv1QRDSqoKGveaLA	Hola!	514 NW Greenwood Ave, Redmond, OR 97756, USA	44.2817850	-121.1733830	1,020 m		cocktails, live music, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7290	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 – 9:00 PM	View Photos (4)
ChIJ-20J81LVuFQRz9Y0ZoSExhU	Home Storage Center	1950 SW Badger Ave STE 109, Redmond, OR 97756, USA	44.2381100	-121.1898640	4,042 m		grocery stores	establishment,food,grocery_or_supermarket,point_of_interest,store,supermarket	Page \| Maps \| Website	(541) 548-6868	View Hours Monday: Closed Tuesday: Closed Wednesday: 9:00 – 11:00 AM Thursday: Closed Friday: Closed Saturday: Closed Sunday: Closed	View Photos (1)
ChIJsS__lvMrv1QRA4s8zenoeJ4	Homeslice Pizza	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m	food-trucks (edited)	food trucks (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 306-8314	View Hours Monday: 12:00 – 8:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 8:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 9:30 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJX81aCKorv1QRi-Sdc9Txutc	Homestead Pump Track	767 NW Canal Blvd, Redmond, OR 97756, USA	44.2834450	-121.1686740	1,274 m	outdoors	mountain biking, parks, point-of-interest	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-2000	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)
ChIJeTVVj5Urv1QRqKgR332Q8jU	Homestead Shoppes- Urban Homestead Co	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		boutiques, gift shops, shopping	clothing_store,store,point_of_interest,establishment	Page \| Maps \| Website	(541) 604-1062	View Hours Monday: 10:30 AM – 4:30 PM Tuesday: 10:30 AM – 4:30 PM Wednesday: 10:30 AM – 4:30 PM Thursday: 10:30 AM – 4:30 PM Friday: 10:30 AM – 4:30 PM Saturday: 10:30 AM – 4:00 PM Sunday: Closed	View Photos (1)
ChIJsWQvQ9cqv1QRTFGd9qQ_-s8	Honey & Pine Coffee Company	610 SW 6th St, Redmond, OR 97756, USA	44.2715270	-121.1740400	122 m		bakeries, breakfast, coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 604-0822	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 (4)
ChIJnX2OP0w3v1QRa6S6FFt3zCg	Hoodoo Ski Area	27400 Big Lake Road, Sisters, OR 97759, USA	44.4086440	-121.8714160	57,494 m	outdoors	skiing	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3799	View Hours Monday: Closed Tuesday: Closed 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 – 4:00 PM	View Photos (4)
ChIJTbJyI7orv1QRTz27mBwSv5w	Hope playground for everyone	401 SW 15th St, Redmond, OR 97756, USA	44.2734140	-121.1846650	860 m		playgrounds, rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJfcCSV-kqv1QR6Aju_KN3Fw0	Hub Motel	1128 NW 6th St, 1154 NW 6th St, Redmond, OR 97756, USA	44.2868200	-121.1736330	1,579 m		hotels	establishment,lodging,point_of_interest	Page \| Maps \| Website	(800) 784-3482		View Photos (4)
ChIJ_QttG9sqv1QRlMOKu0qCRnQ	Human Touch Massage Center	341 SW Black Butte Blvd, Redmond, OR 97756, USA	44.2756950	-121.1718830	378 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 923-9708		No photos available
ChIJq6pa8drUuFQRqAQLsKvH_wg	Hunt Long Range	2606 SW 4th St, Redmond, OR 97756, USA	44.2514490	-121.1700190	2,375 m		driving range, shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1820	View Hours Monday: 6:00 AM – 5:00 PM Tuesday: 6:00 AM – 5:00 PM Wednesday: 6:00 AM – 5:00 PM Thursday: 6:00 AM – 5:00 PM Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJeRO2t9cqv1QRbg6I-B-a7bI	Ida’s Cupcake Cafe, Redmond	445 SW 6th St, Redmond, OR 97756, USA	44.2729040	-121.1745710	61 m		bakeries, coffee shops, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-6077	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	View Photos (4)
ChIJbZz3G-87v1QReu-cFiQyh0Q	Indian ford campground	Indian Ford Rd, Sisters, OR 97759, USA	44.3587800	-121.6105130	36,032 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (3)
ChIJ_ysij0grv1QRbvShDgSXegU	Indian tadka	123 SW 5th St, Redmond, OR 97756, USA	44.2759040	-121.1729080	374 m	food-trucks (edited)	food trucks (edited)	meal_takeaway,restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 8:00 PM 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: 11:00 AM – 8:00 PM	View Photos (4)
ChIJQbpvDv0rv1QRNw9JdvxktaU	Initiative Brewing (the Hub)	424 NW 5th St, Redmond, OR 97756, USA	44.2799660	-121.1729920	820 m		bars, brewery, cocktails, food trucks, live music, microbrewery, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4380	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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJHxdYl8grv1QRHvAKRrvBA24	Inner Balance Therapeutic Massage	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727000	-121.1745910	54 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(971) 208-3363	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: Closed Sunday: Closed	View Photos (3)
ChIJOYjHWdAqv1QRrJQoj6YZVDc	J C’s Java & Such	106 SE Evergreen Ave, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m		coffee shops	cafe,food,point_of_interest,store,establishment	Page \| Maps		View Hours Monday: 7:00 AM – 6:00 PM Tuesday: 7:00 AM – 6:00 PM Wednesday: 7:00 AM – 6:00 PM Thursday: 7:00 AM – 6:00 PM Friday: 7:00 AM – 6:00 PM Saturday: 7:00 AM – 6:00 PM Sunday: Closed	No photos available