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: 17
Limit per Page: 25
Offset: 400
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 400, 25

Previous Next

Page 17 of 24

Showing 401 to 425 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJzd47LvUqv1QRJqG9EjI_VZM	Quince Park	Redmond, OR 97756, USA	44.2985750	-121.1803660	2,931 m		parks	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)
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, 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 Beauty	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m		spas	establishment,health,point_of_interest,spa	Page \| Maps \| Website	(503) 290-4028		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 Suite M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, shopping, 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	establishment,point_of_interest	Page \| Maps \| Website	(541) 548-7275	View Hours Monday: 5:00 AM – 9:45 PM Tuesday: 5:00 AM – 9:45 PM Wednesday: 5:00 AM – 9:45 PM Thursday: 5:00 AM – 9:45 PM Friday: 5:00 AM – 9:45 PM Saturday: 1:00 – 5:00 PM Sunday: Closed	View Photos (3)
ChIJESUjeIMrv1QRh8YNKlzZ8zA	Redmond Armory Rental Venue	822 SW Highland Ave, Redmond, OR 97756, USA	44.2691660	-121.1769870	455 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJzUapk9wqv1QRZ4BT-v_1j3I	Redmond Burger Company	249 NW 6th St, Redmond, OR 97756, USA	44.2780770	-121.1746090	609 m		bars, brewery, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-5262	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJWdZZnMbUuFQRLf3pypk2hNo	Redmond Caves	SE Airport Way, Redmond, OR 97756, USA	44.2473780	-121.1776960	2,823 m	outdoors	hiking, nature preserve, point-of-interest, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 416-6700	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)
ChIJbaLhTsnUuFQRrd_3e_KIS9I	Redmond Cinemas	1535 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2528390	-121.1845470	2,357 m		theatres	establishment,movie_theater,point_of_interest	Page \| Maps \| Website	(541) 548-8777	View Hours Monday: 1:30 – 10:00 PM Tuesday: 1:30 – 10:00 PM Wednesday: 1:30 – 10:00 PM Thursday: 1:30 – 10:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 11:00 PM	View Photos (4)
ChIJ-xhWMNPVuFQR_rcUrq2xz4M	Redmond Coffee Company	3716 SW 21st Pl, Redmond, OR 97756, USA	44.2414960	-121.1908090	3,713 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 598-4577	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:30 AM – 2:00 PM Sunday: 7:30 AM – 2:00 PM	View Photos (4)
ChIJD7R9Xs3TuFQRw-SxzA-Oe-k	Redmond Community Concert Association	4555 SW Elkhorn Ave, Redmond, OR 97756, USA	44.2350660	-121.2190610	5,510 m		live music	establishment,point_of_interest	Page \| Maps \| Website	(541) 350-7222		No photos available
ChIJA3Fz69kqv1QRhN-93Af4sVg	Redmond Farmers Market	725 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727660	-121.1755600	131 m		farmers markets	establishment,point_of_interest	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 3:00 – 7:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJR2NdRfsrv1QRuFFTGrW9aTo	Redmond Food Park	122 SW 5th St, Redmond, OR 97756, USA	44.2760710	-121.1729900	391 m		breakfast, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 754-0190	View Hours Monday: 12:00 – 8:00 AM, 9:00 AM – 8:00 PM Tuesday: 6:00 AM – 8:30 PM Wednesday: 6:00 AM – 8:30 PM Thursday: 6:00 AM – 8:30 PM Friday: 6:00 AM – 8:30 PM Saturday: 8:00 AM – 8:30 PM Sunday: 8:00 AM – 12:00 AM	View Photos (4)
ChIJPcByItcqv1QRZ9wV8gOfdG0	Redmond Fuel Stop	712 SW 5th St, Redmond, OR 97756, USA	44.2703420	-121.1729160	266 m		desserts	convenience_store,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-7829	View Hours Monday: 6:00 AM – 8:00 PM Tuesday: 6:00 AM – 8:00 PM Wednesday: 6:00 AM – 8:00 PM Thursday: 6:00 AM – 8:00 PM Friday: 6:00 AM – 8:00 PM Saturday: 6:00 AM – 8:00 PM Sunday: 6:00 AM – 8:00 PM	View Photos (3)
ChIJR0zjoiwrv1QRDNlqgxWR_t4	Redmond Inn	1545 S Hwy 97, Redmond, OR 97756, USA	44.2617530	-121.1784840	1,262 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 548-1091	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)
ChIJR0c4XE0NkFQRxiiq5S8cB40	Redmond Library	15990 NE 85th St, Redmond, WA 98052, USA	47.6789090	-122.1280780	385,863 m	family-friendly	library	establishment,library,point_of_interest	Page \| Maps \| Website	(425) 885-1861	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 8:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 11:00 AM – 6:00 PM Sunday: 11:00 AM – 6:00 PM	View Photos (4)
ChIJ2ZV6s2Urv1QRoTuy12E4l8c	Redmond Massage Therapy \| Bodywork Massage Therapist Sharlene Reed	615 SW 5th St, Redmond, OR 97756, USA	44.2712980	-121.1736230	149 m		massage	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 948-5943	View Hours Monday: Closed Tuesday: 12:00 – 7:00 PM Wednesday: Closed Thursday: 12:00 – 7:00 PM Friday: 12:00 – 7:00 PM Saturday: 12:00 – 7:00 PM Sunday: Closed	View Photos (4)
ChIJI8dU-Nkqv1QRN-Far_-Up8k	Redmond Municipal Airport	2522 Jesse Butler Cir Suite 6, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m	getting-here	airports	airport,establishment,point_of_interest	Page \| Maps \| Website	(541) 504-3499	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)
ChIJATEZDrDTuFQR7NvuU7OnSaE	Redmond Rod & Gun Club	65600 S Hwy 97, Redmond, OR 97756, USA	44.1852790	-121.2204990	10,397 m	outdoors (edited)	hunting (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 699-2518	View Hours Monday: Closed Tuesday: 10:00 AM – 2:00 PM Wednesday: 10:00 AM – 2:00 PM Thursday: Closed Friday: 10:00 AM – 2:00 PM Saturday: 10:00 AM – 2:00 PM Sunday: 10:00 AM – 2:00 PM	View Photos (4)
ChIJVXzeSsUqv1QR0kbaK7Q9lRE	Redmond Smokehouse	353 SE Railroad Blvd, Redmond, OR 97756, USA	44.2750270	-121.1679330	547 m		markets, meat markets, smokehouses	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 202-0674	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: 9:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ81NKaMnUuFQRFQ_TzNpMfws	Redmond South Liquor Store	1705 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2532650	-121.1863770	2,370 m		shopping	establishment,liquor_store,point_of_interest,store	Page \| Maps	(541) 548-2722	View Hours Monday: 9:00 AM – 8:00 PM Tuesday: 9:00 AM – 8:00 PM Wednesday: 9:00 AM – 8:00 PM Thursday: 9:00 AM – 8:00 PM Friday: 9:00 AM – 8:00 PM Saturday: 9:00 AM – 8:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJV1nhmdLUuFQRbcP2Ewa-Cdo	Redmond Spa Stove and Sauna	1927 S Hwy 97, Redmond, OR 97756, USA	44.2582650	-121.1807020	1,685 m		spas	establishment,general_contractor,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-0746	View Hours Monday: Closed Tuesday: 9:00 AM – 5:30 PM Wednesday: 9:00 AM – 5:30 PM Thursday: 9:00 AM – 5:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 10:00 AM – 4:00 PM Sunday: Closed	View Photos (4)