Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: website
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 COALESCE(e.website, p.website) 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
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)
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)
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)
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
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)
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
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)
ChIJ3xhwJgDVuFQRUcpWy9qWeaI	Chavez Market	2498 S Hwy 97 St B, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		desserts, grocery stores, juice bars, markets, meat markets, shopping	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps	(458) 899-5953	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJ57m4d3wrv1QR2OOtqOYrRWk	Playground	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2674800	-121.1908150	1,461 m		playgrounds	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ6_6oTHvNuFQRJww5KCkV_d8	Khalsa Hands Massage	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734120	-121.1756510	163 m		massage	establishment,point_of_interest	Page \| Maps	(541) 548-6556	View Hours Monday: 8:00 AM – 6:30 PM Tuesday: 8:00 AM – 6:30 PM Wednesday: 8:00 AM – 6:30 PM Thursday: 8:00 AM – 6:30 PM Friday: 8:00 AM – 6:30 PM Saturday: 8:00 AM – 6:30 PM Sunday: Closed	No photos available
ChIJ69QfC5Esv1QR833VW7H6Fus	Silver Leaf Market	7535 Falcon Crest Dr # 200, Redmond, OR 97756, USA	44.2628170	-121.2624180	7,130 m		grocery stores, markets, shopping	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps	(541) 526-5009	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9:00 PM Thursday: 8:00 AM – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJ6y3y0nQrv1QRpIFul8xhRhg	M&w Markets	900 SW 23rd St, Redmond, OR 97756, USA	44.2679840	-121.1934960	1,642 m		grocery stores, markets, shopping	establishment,hardware_store,home_goods_store,point_of_interest,store	Page \| Maps	(541) 548-5070	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJ6YJIBI0rv1QRZzHEIwbumwA	Parking Lot for Playground	401 SW 15th St, Redmond, OR 97756, USA	44.2730740	-121.1844370	839 m		parks, playgrounds	establishment,park,point_of_interest	Page \| Maps			View Photos (2)
ChIJ7bibtKHXvlQR3oWFs0yk6Q0	Canyon Trail Trailhead	9930 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3668140	-121.1362950	10,893 m		hiking	establishment,park,point_of_interest	Page \| Maps			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)
ChIJ7yQIS9Qqv1QRUn8Lz5jV6gk	1100 SE Lake Rd	1100 SE Lake Rd, Redmond, OR 97756, USA	44.2670920	-121.1707110	666 m	outdoors (edited)	fishing (edited)	premise,street_address	Page \| Maps			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)
ChIJ86CATOwqv1QRxPcOUjaNJGI	Bottoms Up Bar & Grill	1421 NW 6th St, Redmond, OR 97756, USA	44.2895840	-121.1743040	1,887 m		bars, breakfast, brewery, cocktails, live music, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 548-5663	View Hours Monday: 11:30 AM – 10:00 PM Tuesday: 11:30 AM – 10:00 PM Wednesday: 11:30 AM – 10:00 PM Thursday: 11:30 AM – 10:00 PM Friday: 7:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJ8fz7agDRvlQRW-nEAPJBwuk	Parking for The Zoo	9WX2+WQ, Terrebonne, OR 97760, USA	44.3997850	-121.0980350	15,374 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (2)
ChIJ8QthECgrv1QRCEBuWDpd6-U	Loco Place	1106 SW Highland Ave, Redmond, OR 97756, USA	44.2693550	-121.1797660	590 m		desserts, food trucks	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps	(541) 527-1238	View Hours Monday: Closed Tuesday: 10:00 AM – 8:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 10:00 AM – 8:00 PM	View Photos (4)
ChIJ8w_4c3ksv1QR_O0U6SKjJi8	Cline Falls Mobile Home Park office	7915 OR-126 office, Redmond, OR 97756, USA	44.2792000	-121.2665290	7,409 m		rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps	(541) 420-5578		View Photos (4)
ChIJ8xhuChArv1QRJ6Vpj3LAG_o	Transcendence Therapeutic Massage	813 SW Highland Ave Suite 203, Redmond, OR 97756, USA	44.2698140	-121.1767460	385 m		massage	establishment,point_of_interest	Page \| Maps	(541) 815-3897	View Hours Monday: Closed 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 – 1:00 PM Sunday: Closed	View Photos (4)
ChIJ92Npl9sqv1QRt6F8lqOpNHg	Venetian Esthetique Day Spa	135 SW 6th St, Redmond, OR 97756, USA	44.2759520	-121.1745820	374 m		spas	establishment,point_of_interest,spa	Page \| Maps	(541) 504-0260		No photos available