Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: place_id
Order: ASC

Pagination:

Current Page: 2
Limit per Page: 25
Offset: 25
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 p.place_id ASC LIMIT 25, 25

Previous Next

Page 2 of 24

Showing 26 to 50 of 583 results

Place ID ↑	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ07dZScjUuFQRviU0XsHYa6s	Big Country RV – Redmond	2795 S Hwy 97, Redmond, OR 97756, USA	44.2503970	-121.1871270	2,686 m		rv parks	car_dealer,car_repair,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 208-3888	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: 10:00 AM – 5:00 PM	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)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m		bars, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3731	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJ1_-hR9oqv1QRKuTyO-w_f94	Food Fellas	332 SW 5th St, Redmond, OR 97756, USA	44.2737650	-121.1728670	152 m		brewery, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:30 AM – 9:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 9:00 PM Saturday: 11:30 AM – 9:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJ1_gOItcqv1QRtcKfUXcx92I	Glacier Market	SW Glacier Ave, Redmond, OR 97756, USA	44.2702740	-121.1730100	271 m		grocery stores, markets, meat markets	establishment,gas_station,point_of_interest	Page \| Maps	(541) 504-7829	View Hours Monday: 6:00 AM – 9:30 PM Tuesday: 6:00 AM – 9:30 PM Wednesday: 6:00 AM – 9:30 PM Thursday: 6:00 AM – 9:30 PM Friday: 6:00 AM – 9:30 PM Saturday: 6:00 AM – 9:30 PM Sunday: 6:00 AM – 9:30 PM	View Photos (1)
ChIJ1_TWqNAqv1QRr9QTKRGor9Y	Just Cut Organic Juice Bar and Fitness	412 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723180	-121.1724450	122 m		juice bars, pubs	establishment,food,gym,health,point_of_interest,restaurant	Page \| Maps \| Website	(541) 771-2161	View Hours Monday: 7:00 AM – 5:00 PM Tuesday: 7:00 AM – 5:00 PM Wednesday: 7:00 AM – 5:00 PM Thursday: 7:00 AM – 5:00 PM Friday: 7:00 AM – 5:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJ16Klq9Aqv1QRQyXRIHHgqsY	Moe’s Food Mart	516 SW 5th St, Redmond, OR 97756, USA	44.2722970	-121.1728730	91 m		desserts, grocery stores	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps	(541) 548-1225	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 – 9:00 PM	View Photos (3)
ChIJ1bL8qynVuFQR_lqasnGI4IM	KNS Hot Tubs	535 NE Jackpine Ct Unit 101, Redmond, OR 97756, USA	44.2857720	-121.1632730	1,690 m		spas	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-1063	View Hours Monday: Closed Tuesday: 9:00 AM – 4:00 PM Wednesday: 9:00 AM – 4:00 PM Thursday: 9:00 AM – 4:00 PM Friday: 9:00 AM – 4:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJ1VfCqzePuFQRm_qLJANFiLU	Paulina Lake Hot Spring	Little Crater Campground, La Pine, OR 97739, USA	43.7320950	-121.2523330	60,430 m	outdoors	point-of-interest	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJ1Y53bSYrv1QR4KoKnJAFsG8	Changing Tide Massage	641 SW 14th St, Redmond, OR 97756, USA	44.2708820	-121.1831650	761 m		massage	establishment,point_of_interest	Page \| Maps	(541) 480-0066	View Hours Monday: 8:00 AM – 7:00 PM Tuesday: 8:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJ1Y53bSYrv1QRaLsl31PGYBU	Robin E. Meyer, LMT, CA	1655 SW Highland Ave Suite 1, Redmond, OR 97756, USA	44.2698320	-121.1864260	1,043 m		massage	doctor,establishment,health,point_of_interest	Page \| Maps	(541) 923-2019	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:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJ1Y53bSYrv1QROOjkSB0ukyY	Redmond Wellness and Chiropractic	1655 SW Highland Ave Ste. #6, Redmond, OR 97756, USA	44.2698830	-121.1860610	1,013 m		wellness center	establishment,health,point_of_interest	Page \| 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)
ChIJ1YkTCskrv1QRBM7YTyMXzU4	District Day Spa	823 SW 12th St, Redmond, OR 97756, USA	44.2691460	-121.1809830	682 m		spas	beauty_salon,establishment,point_of_interest	Page \| Maps \| Website	(541) 548-5352		No photos available
ChIJ2-5bgcrVuFQRDqqYrr1ihD0	buy2 Stores – Redmond	1846 S Hwy 97, Redmond, OR 97756, USA	44.2585430	-121.1792500	1,622 m		desserts, grocery stores, juice bars	convenience_store,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 228-9352	View Hours Monday: 6:00 AM – 11:00 PM Tuesday: 6:00 AM – 11:00 PM Wednesday: 6:00 AM – 11:00 PM Thursday: 6:00 AM – 11:00 PM Friday: 6:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJ2-PcF58rv1QRcnwAfnTwveY	The Burger Cart	845 SW 17th St, Redmond, OR 97756, USA	44.2690320	-121.1876970	1,167 m		dining, food trucks	restaurant,food,point_of_interest,establishment	Page \| Maps		View Hours Monday: Closed Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 7:00 PM	View Photos (4)
ChIJ216Xg87UuFQRPim-k47dpok	Latrontera Mini Market	Redmond, OR 97756, USA	44.2542310	-121.1820710	2,145 m		juice bars	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps			No photos available
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ2a8tyxArv1QR_ihuMeVRzHc	Coastal Smash Redmond	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 374-2074	View Hours Monday: Closed Tuesday: 11:30 AM – 7:30 PM Wednesday: 11:30 AM – 7:30 PM Thursday: 11:30 AM – 7:30 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ2duG4fEqv1QRuOdOz8cwD8I	Paul Hathaway Memorial Park	1021 NW Rockcrest Ct, Redmond, OR 97756, USA	44.2906730	-121.1800210	2,065 m	outdoors	parks, point-of-interest	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: 7:00 AM – 9:30 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)
ChIJ2fShEsjUuFQReyj2HRJKS4w	Blue Compass RV Redmond	3000 S Hwy 97, Redmond, OR 97756, USA	44.2483600	-121.1867230	2,884 m		rv parks	car_dealer,car_repair,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 516-8831	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: 11:00 AM – 4:00 PM	View Photos (4)
ChIJ2RqEMCUrv1QRvVfpu33Bg4Q	Health Foot Spa	2A, 915 SW Rimrock Way #203, Redmond, OR 97756, USA	44.2681230	-121.1928520	1,588 m		massage, spas	establishment,point_of_interest,spa	Page \| Maps	(541) 504-8868	View Hours Monday: 7:30 AM – 9:30 PM Tuesday: 7:30 AM – 9:30 PM Wednesday: 7:30 AM – 9:30 PM Thursday: 7:30 AM – 9:30 PM Friday: 7:30 AM – 9:30 PM Saturday: 7:30 AM – 9:30 PM Sunday: 7:30 AM – 9:30 PM	View Photos (4)
ChIJ2Z5ETSGvuFQRBJrDIKwKQi4	Mount Bachelor	Mount Bachelor, Oregon 97703, USA	43.9791670	-121.6886110	52,463 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps			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)
ChIJ3-y1duvdvlQRXM_qvoCYJxU	Group Camp	CROOKED RIVER, OR 97760, USA	44.5409870	-121.2706610	30,815 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 546-3412		View Photos (4)
ChIJ31jIkZItv1QR9nMR5Q-6yTI	Aerie Cafe	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2597390	-121.2627970	7,220 m		breakfast, dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 504-3870	View Hours Monday: 7:00 – 10:30 AM Tuesday: 7:00 – 10:30 AM Wednesday: 7:00 – 10:30 AM Thursday: 7:00 – 10:30 AM Friday: 7:00 – 10:30 AM Saturday: 7:00 – 10:30 AM Sunday: 7:00 – 10:30 AM	View Photos (4)