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: 19
Limit per Page: 25
Offset: 450
Total Pages: 26

Results:

Total Available Records: 645
Total After Limits: 645
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 450, 25

Previous Next

Page 19 of 26

Showing 451 to 475 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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 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 Ste M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, antiques,shopping,thrift stores,vintage, 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, 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)
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, bars,nightlife,bars,nightlife,pubs,brewery,restaurants,lunch,dining,family friendly, brewery, food trucks, lunch, pubs, restaurants	bar,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, parks,nature preserve,state parks,hiking, 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)
ChIJbzCfc98qv1QRdt7BObrk4og	Redmond city skatepark	1604 W Antler Ave, Redmond, OR 97756, USA	44.2762370	-121.1844800	932 m		parks	establishment,point_of_interest	Page \| Maps		View Hours Monday: 8:00 AM – 12:00 AM Tuesday: 8:00 AM – 12:00 AM Wednesday: 8:00 AM – 12:00 AM Thursday: 8:00 AM – 12:00 AM Friday: 8:00 AM – 12:00 AM Saturday: 8:00 AM – 12:00 AM Sunday: 8:00 AM – 12:00 AM	View Photos (4)
ChIJ-xhWMNPVuFQR_rcUrq2xz4M	Redmond Coffee Company	3716 SW 21st Pl A, Redmond, OR 97756, USA	44.2414960	-121.1908090	3,713 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 640-2512	View Hours Monday: 7:00 AM – 3:00 PM Tuesday: 7:00 AM – 3:00 PM Wednesday: 7:00 AM – 3:00 PM Thursday: 7:00 AM – 3:00 PM Friday: 7:00 AM – 3:00 PM Saturday: 7:30 AM – 3:00 PM Sunday: 7:30 AM – 3: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, farmers markets,markets,farms	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, food trucks,breakfast,lunch,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 754-0190	View Hours Monday: 12:00 – 8:00 AM, 10: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, shopping	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)
ChIJMzisFCQrv1QRDSVe0SI9Qmc	Redmond Grange #812	707 SW Kalama Ave, Redmond, OR 97756, USA	44.2666610	-121.1758740	681 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 480-4495		View Photos (4)
ChIJh0op4tkqv1QRlpdzHRZoAwE	Redmond Historical Commission	521 SW 6th St #303, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		point of interest	establishment,park,point_of_interest	Page \| Maps	(541) 526-0554		No photos available
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 Ste 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)
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)
ChIJjxhSGAArv1QRkdSMLRO0_S4	Redmond Travel center	401 NW Quince Ave, Redmond, OR 97756, USA	44.2986680	-121.1728760	2,898 m		shopping	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps	(541) 923-0669	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)