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: 11
Limit per Page: 25
Offset: 250
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 250, 25

Previous Next

Page 11 of 26

Showing 251 to 275 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJF3pfGF7QvlQR_Beogm5wpVg	Gray Butte Trailhead	NF-1395, Culver, OR 97734, USA	44.4288160	-121.0902300	18,599 m		hiking, trailheads	establishment,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJ-fN-F3A9v1QRlBWPmxKrojE	Green Ridge Trailhead	NF-1120, Camp Sherman, OR 97730, USA	44.4277770	-121.6091030	38,665 m		trailheads	establishment,point_of_interest	Page \| Maps			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)
ChIJCQ0gSYorv1QRGmZ7q0xSv4I	Habitat for Humanity ReStore	2744 NW 7th St, Redmond, OR 97756, USA	44.3012560	-121.1743230	3,184 m		thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-1406	View Hours Monday: Closed 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: Closed	View Photos (1)
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, desserts,food trucks,restaurants,dining,family friendly, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website		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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJv55JZ5jUuFQRO0G0ra30Fx0	Hardenbrook Hardwoods	2122 SW Deerhound Ave #7, Redmond, OR 97756, USA	44.2352050	-121.1921520	4,406 m		gift shops	establishment,furniture_store,general_contractor,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 526-1664	View Hours Monday: 8:00 AM – 3:00 PM Tuesday: 8:00 AM – 3:00 PM Wednesday: 8:00 AM – 3:00 PM Thursday: 8:00 AM – 3:00 PM Friday: 8:00 AM – 12:00 PM Saturday: Closed Sunday: Closed	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, parks,playgrounds, 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	fishing, hiking, point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJBaACR2vbvlQRupCcZdEW6M8	Haystack Reservoir	SW Haystack Reservoir Rd, Culver, OR 97734, USA	44.4932580	-121.1505180	24,604 m		fishing	establishment,park,point_of_interest	Page \| Maps \| Website	(541) 416-6500		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)
ChIJeTxLmGkrv1QRdtBfquK5zgM	Helmholtz Depot	2087 SW Helmholtz Way, Redmond, OR 97756, USA	44.2564310	-121.2209760	4,157 m		farmers markets, farmers markets,grocery stores, grocery stores, juice bars	establishment,point_of_interest	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)
ChIJwYUqt4Arv1QRCWGsJRL38Uw	Helmholtz Farm Stand	2087 SW Helmholtz Way, Redmond, OR 97756, USA	44.2564260	-121.2209910	4,158 m		farmers markets, farmers markets,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)
ChIJmamRNQDZvlQRh-k2PjmDd9w	Heritage House Old Mine & Water Works	6710 S W Ranch House Pl, Crooked River Ranch, OR 97760, USA	44.4477330	-121.2635920	20,736 m		historic landmarks	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJbeu6H9oqv1QRIi46_pG0Z0o	Herringbone Books	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores, shopping	book_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1491	View Hours Monday: 9:30 AM – 6:00 PM Tuesday: 9:30 AM – 6:00 PM Wednesday: 9:30 AM – 6:00 PM Thursday: 9:30 AM – 6:00 PM Friday: 9:30 AM – 6:00 PM Saturday: 9:30 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJgyqVAaPUuFQRra4maJjrBu8	Hershey Cattle Company & Super Top Soil	4098 S Hwy 97, Redmond, OR 97756, USA	44.2378990	-121.1953480	4,221 m		farms	establishment,general_contractor,point_of_interest	Page \| Maps \| Website	(541) 548-3949	View Hours Monday: 8:00 AM – 4:00 PM Tuesday: 8:00 AM – 4:00 PM Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: Closed	No photos available
ChIJI8dU-Nkqv1QRH2auKTBRV3w	Hertz Car Rental – Roberts Field Airport Hle	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2539050	-121.1598220	2,365 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-1411	View Hours Monday: 8:00 AM – 1:00 AM Tuesday: 8:00 AM – 1:00 AM Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 AM Friday: 8:00 AM – 1:00 AM Saturday: 8:00 AM – 1:00 AM Sunday: 8:00 AM – 1:00 AM	View Photos (4)
ChIJo4ai9hgrv1QRgtz5-j3Dcuk	Hideaway Redmond	507 SW 8th St, Redmond, OR 97756, USA	44.2723770	-121.1766400	218 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,restaurants,breakfast,lunch,dining,family friendly, breakfast, cocktails, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-5989	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 – 11:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJBetWAa_VuFQRujCxDWTBj90	High Desert Activity Center	6RP7+2F, 3800 SW Airport Way, Redmond, OR 97756, USA	44.2350800	-121.1863640	4,290 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
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)
ChIJQQhiJ6pf-G4R_tCH3gYL1Ws	High Desert Florals	249 NW 6th St Suite 2, Redmond, OR 97756, USA	44.2780460	-121.1745320	605 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 923-3977	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJR6HFJWIrv1QRx9S5g05rphU	High Desert Geckos Exotic Pets & Supplies	905 SW Rimrock Way Ste 101, Redmond, OR 97756, USA	44.2683770	-121.1924250	1,547 m		gift shops	establishment,pet_store,point_of_interest,store	Page \| Maps \| Website	(541) 527-5082	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: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)