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: 10
Limit per Page: 25
Offset: 225
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 225, 25

Previous Next

Page 10 of 24

Showing 226 to 250 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJq5Iqoe0qv1QRFMvVnidFRgw	Full Throttle Java	255 SW 5th St, Redmond, OR 97756, USA	44.2751400	-121.1734370	283 m		coffee shops, juice bars	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 788-0010	View Hours Monday: 5:30 AM – 5:00 PM Tuesday: 5:30 AM – 5:00 PM Wednesday: 5:30 AM – 5:00 PM Thursday: 5:30 AM – 5:00 PM Friday: 5:30 AM – 5:00 PM Saturday: 5:30 AM – 1:00 PM Sunday: Closed	View Photos (4)
ChIJKxby4dkqv1QRgXSRB6Ahtdc	Geek Geek Nerd Nerd	106 SE Evergreen Ave Suite J, Redmond, OR 97756, USA	44.2716900	-121.1679500	487 m		shopping	book_store,establishment,point_of_interest,store	Page \| Maps	(541) 527-4987	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJh7hCwe0qv1QR8HhdyVUHpE8	Gemini Beauty Co.	1508 NW 8th St, Redmond, OR 97756, USA	44.2901810	-121.1761640	1,961 m		spas	beauty_salon,establishment,hair_care,point_of_interest,spa	Page \| Maps \| Website	(541) 777-7961	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: 9:00 AM – 7:00 PM Friday: 9:00 AM – 7:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJC18JtDArv1QRQs9GRj7LBCw	General Duffy’s Waterhole	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714000	-121.1723500	185 m	food trucks (edited)	food trucks (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4345	View Hours Monday: Closed 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)
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)
ChIJxYoUXJUqv1QR2h-mzXNFo5w	Gompers Distillery and Speakeasy	611 NE Jackpine Ct #8, Redmond, OR 97756, USA	44.2861270	-121.1627710	1,745 m		bars, brewery, cocktails, distillery, farmers markets, nightlife	bar,establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 588-2825	View Hours Monday: Closed Tuesday: Closed Wednesday: 3:00 – 8:00 PM Thursday: 3:00 – 8:00 PM Friday: 3:00 – 8:00 PM Saturday: 3:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJvy5z6owqv1QR8yWLL-_rgow	Goodwill Industries of the Columbia Willamette	2067 NW 6th St, Redmond, OR 97756, USA	44.2959570	-121.1750400	2,596 m		shopping, thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 316-2090	View Hours Monday: 10:00 AM – 8:00 PM 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)
ChIJMfJSB_0rv1QR2XGtF_6DoLs	Goody’s Ice Cream Food Cart	@ General Duffy’s Waterhole, 404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 385-7085	View Hours Monday: 3:30 – 8:00 PM Tuesday: 3:30 – 8:00 PM Wednesday: 3:30 – 8:00 PM Thursday: 3:30 – 8:00 PM Friday: 3:30 – 8:00 PM Saturday: 12:30 – 8:00 PM Sunday: 12:30 – 8:00 PM	No photos available
ChIJh11uyicrv1QRcL_Ry5em8LI	Grace and Hammer	641 SW Cascade Ave, Redmond, OR 97756, USA	44.2747650	-121.1750860	256 m		brewery	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 668-6684	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:00 – 8:00 PM Thursday: 4:00 – 8:00 PM Friday: 4:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: 12:00 – 8:00 PM	View Photos (4)
ChIJF3pfGF7QvlQR_Beogm5wpVg	Gray Butte Trailhead	NF-1395, Culver, OR 97734, USA	44.4288160	-121.0902300	18,599 m		hiking	establishment,park,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJU2LfJKXUuFQRWQmGtTe8jHs	Greens At Redmond	2575 SW Greens Blvd, Redmond, OR 97756, USA	44.2425690	-121.1978480	3,847 m		driving range, golf courses, golf lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-0694	View Hours Monday: 7:00 AM – 6:00 PM Tuesday: 7:00 AM – 6:00 PM Wednesday: 7:00 AM – 6:00 PM Thursday: 7:00 AM – 6:00 PM Friday: 7:00 AM – 6:00 PM Saturday: 7:00 AM – 6:00 PM Sunday: 7:00 AM – 6:00 PM	View Photos (4)
ChIJ36qhj_0tv1QR_vLAjoMyLeY	Greenside Cafe	8300 Coopers Hawk Dr, Redmond, OR 97756, USA	44.2642920	-121.2717270	7,843 m		dining, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-9591	View Hours Monday: 10:30 AM – 4:00 PM Tuesday: 10:30 AM – 4:00 PM Wednesday: 10:30 AM – 4:00 PM Thursday: 10:30 AM – 4:00 PM Friday: 10:30 AM – 4:00 PM Saturday: 10:30 AM – 4:00 PM Sunday: 10:30 AM – 4:00 PM	View Photos (3)
ChIJqTu2xekqv1QRInmG_eaaoQE	Grocery Outlet	1619 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2535150	-121.1862090	2,339 m		desserts, grocery stores, juice bars, markets, shopping	establishment,food,grocery_or_supermarket,point_of_interest,store,supermarket	Page \| Maps \| Website	(541) 548-1662	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: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 8:00 PM	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)
ChIJpX9PsrzUuFQRrITa_n-AsuI	Hampton Inn Redmond Bend Airport	3901 SW 21st St, Redmond, OR 97756, USA	44.2399820	-121.1940800	3,968 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 527-1948		View Photos (4)
ChIJ9WLX94crv1QRzGzQ94mjp2c	Hapa at Otto’s Landing	652 NW 7th St, Redmond, OR 97756, USA	44.2819070	-121.1749470	1,036 m		desserts, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website		View Hours Monday: Closed 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 – 10:00 PM Saturday: 9:00 AM – 10:00 PM Sunday: 9:00 AM – 9:00 PM	View Photos (4)
ChIJOzYaGxQqv1QRtM33_TD-cgs	Hastings Family Ranch	2675 NW Coyner Ave, Redmond, OR 97756, USA	44.3208810	-121.1977940	5,693 m		farms	establishment,point_of_interest	Page \| Maps	(541) 678-2319		View Photos (2)
ChIJ_zC1uE4rv1QRLARm4GqAxnU	Hayden Park	SW 35th St @, SW Quartz Ave, Redmond, OR 97756, USA	44.2577570	-121.2087230	3,227 m		parks, playgrounds, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	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)
ChIJOdxKoGzbvlQRFakpdx8wuMU	Haystack Reservoir	Haystack Reservoir, Oregon 97734, USA	44.4943170	-121.1481090	24,737 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJGdwamhTbvlQRVFEQso-g-3w	Haystack Reservoir Campground	Prineville, OR 97754, USA	44.4891930	-121.1507060	24,152 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(208) 270-0094		View Photos (4)
ChIJIdGV7BXbvlQR-VQcTRZYdhI	Haystack Reservoir Campground and Day Use Area	NF-1275, Culver, OR 97734, USA	44.4944580	-121.1416900	24,800 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJHwnt-5Mrv1QRxkdXRegI6HQ	Heal Grow Thrive Medicine	635 NW 5th St, Redmond, OR 97756, USA	44.2816740	-121.1735560	1,007 m		massage	beauty_salon,establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 639-8911	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	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)
ChIJwYUqt4Arv1QRCWGsJRL38Uw	Helmholtz Farm Stand	2087 SW Helmholtz Way, Redmond, OR 97756, USA	44.2564260	-121.2209910	4,158 m		farmers markets, markets	establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJeTxLmGkrv1QRdtBfquK5zgM	Helmholtz Marketplace	2087 SW Helmholtz Way, Redmond, OR 97756, USA	44.2564310	-121.2209760	4,157 m		farmers markets, grocery stores, juice bars	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 639-2720	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: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 7:00 PM	View Photos (4)