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

Results:

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

Previous Next

Page 20 of 27

Showing 476 to 500 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJR2NdRfsrv1QRuFFTGrW9aTo	Redmond Food Park	122 SW 5th St, Redmond, OR 97756, USA	44.2760710	-121.1729900	391 m		breakfast, family friendly, food trucks, lunch, restaurants	restaurant,food,point_of_interest,establishment	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)
ChIJu6r60JIsv1QRqbNUkZd6_5A	Redmond Golf Getaway – Near Smith Rock State Park!	1621 Eagle Springs Ct, Redmond, OR 97756, USA	44.2611280	-121.2701600	7,769 m		hotels	lodging,point_of_interest,establishment	Maps	(877) 818-1014		No photos available
ChIJR0zjoiwrv1QRDNlqgxWR_t4	Redmond Inn (edited)	1545 S Hwy 97, Redmond, OR 97756, USA (edited)	44.2617530	-121.1784840	1,262 m		hotels (edited)	lodging,point_of_interest,establishment (edited)	Maps \| Website (edited)	(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	library,point_of_interest,establishment	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.2713510	-121.1735930	143 m		massage	spa,point_of_interest,establishment	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, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m	getting-here	airports	airport,point_of_interest,establishment	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)
ChIJa_WWBSzVuFQRbKhm56dBn3g	Redmond Public Works Rv Dump	875 SE Veterans Way, Redmond, OR 97756, USA	44.2612330	-121.1588750	1,743 m		rv parks	point_of_interest,establishment	Maps			View Photos (2)
ChIJATEZDrDTuFQR7NvuU7OnSaE	Redmond Rod & Gun Club	9020 S Hwy 97, Redmond, OR 97756, USA	44.1848300	-121.2216240	10,476 m	outdoors (edited)	hunting (edited)	point_of_interest,establishment	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		grocery stores, meat markets, smokehouses	food,point_of_interest,store,establishment	Maps \| Website	(458) 202-0674	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: 9:00 AM – 1: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		cocktails, shopping	liquor_store,store,point_of_interest,establishment	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	home_goods_store,general_contractor,store,point_of_interest,establishment	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	gas_station,convenience_store,food,store,point_of_interest,establishment	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)
ChIJ1Y53bSYrv1QROOjkSB0ukyY	Redmond Wellness & Chiropractic	1655 SW Highland Ave Ste. #6, Redmond, OR 97756, USA	44.2698830	-121.1860610	1,013 m		massage, wellness center	health,point_of_interest,establishment	Maps \| Website	(541) 923-2019	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 – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJb8ixGkHSuFQRgPr4q_vF-yM	Redmond–Bend Juniper State Scenic Corridor	Redmond School District 02j, Redmond, OR 97756, USA	44.1842200	-121.2407080	11,178 m		nature preserve	park,point_of_interest,establishment	Maps			No photos available
ChIJZ3cFVukqv1QRd74wbqRltLQ	Regios Cafe	1154 NW 6th St, Redmond, OR 97756, USA	44.2871880	-121.1735910	1,620 m		breakfast, coffee shops	cafe,restaurant,food,point_of_interest,establishment	Maps	(541) 504-1374	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)
ChIJjeBtyuYqv1QRgTDH_-DDLHY	Remington Arms	1515 NW Fir Ave UNIT 55, Redmond, OR 97756, USA	44.2818540	-121.1851970	1,364 m		rv parks	rv_park,lodging,point_of_interest,establishment	Maps \| Website	(541) 548-3601	View Hours Monday: 10:00 AM – 4:30 PM Tuesday: 10:00 AM – 4:30 PM Wednesday: 10:00 AM – 4:30 PM Thursday: 10:00 AM – 4:30 PM Friday: 10:00 AM – 4:30 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJfxr-X9Qqv1QR_Tu1SzmVBMU	Renew Esthetics & Med Spa	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2666660	-121.1682430	802 m		spas	spa,health,point_of_interest,establishment	Maps \| Website	(541) 548-4720	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)
ChIJAQBcwe0qv1QR1L36KxJB07k	Renew Repair Relax	1508 NW 8th St, Redmond, OR 97756, USA	44.2901810	-121.1761640	1,961 m		massage	point_of_interest,establishment	Maps \| Website	(541) 280-6461		No photos available
ChIJi28aOAArv1QRsxR_CuEdacw	Rent A Car Redmond	8R23+4C7, Redmond, OR 97756, USA	44.3002880	-121.1964530	3,561 m		car rentals	car_rental,point_of_interest,establishment	Maps			No photos available
ChIJYzJh_4Arv1QRqyATOkn2_pE	Rental Center at The Home Depot	300 NW Quince Ave, Redmond, OR 97756, USA	44.2980340	-121.1705030	2,839 m		car rentals	point_of_interest,establishment	Maps \| Website	(541) 516-3990	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: 7:00 AM – 8:00 PM	No photos available
ChIJG50nHADduFQRTetFqK4w8IM	Reynolds Pond Recreation Site	3X5M+MG, Alfalfa, OR 97701, USA	44.0592460	-121.0161470	26,857 m		fishing	park,point_of_interest,establishment	Maps \| Website	(541) 416-6700		No photos available
ChIJ_YHZxDIrv1QR3EdIKd9JPxI	Richard’s Sliders	245 SW 6th St, Redmond, OR 97756, USA	44.2748580	-121.1746800	256 m		breakfast, dining, family friendly, food trucks, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 419-8933	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)
ChIJuza1fI0sv1QRtzNp83g0k0A	Ridge Sports Center	8100 Coopers Hawk Dr, Redmond, OR 97756, USA	44.2634030	-121.2705330	7,761 m		spas	point_of_interest,establishment	Maps	(541) 923-9647	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: 8:00 AM – 9:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJg6w6b9sqv1QR2VUYpIPX3Uc	Rigoberto’s Taco Shop	433 W Antler Ave, Redmond, OR 97756, USA	44.2767630	-121.1728610	468 m		breakfast, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps	(541) 923-1305	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 2:00 AM Saturday: 6:00 AM – 1:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJD1NwB_PXuFQR7gyhXzIZx3A	Rim Rock Riders	17037 Alfalfa Rd, Powell Butte, OR 97753, USA	44.1518100	-121.0450210	16,912 m		horseback rides	point_of_interest,establishment	Maps \| Website	(541) 238-8866	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)