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: 12
Limit per Page: 25
Offset: 275
Total Pages: 29

Results:

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

Previous Next

Page 12 of 29

Showing 276 to 300 of 705 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)
ChIJrS8qwKnTuFQRubicNqxnO2E	Green Acres RV Park (edited)	7777 S Hwy 97, Redmond, OR 97756, USA (edited)	44.2042760	-121.2274740	8,715 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps	(541) 678-7733	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: 9:00 AM – 6:00 PM	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 courses,golf lessons,driving range, 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.2400300	-121.1937930	3,954 m		hotels, hotels,resorts, 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,desserts,food trucks,restaurants,lunch, dining, family friendly, food trucks, restaurants	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: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ89YQgygrv1QRvhy96k034Z0	Happy home tranquility massage & spa	222 SW 8th St, Redmond, OR 97756, USA	44.2751320	-121.1761550	331 m		massage	establishment,point_of_interest,spa	Page \| Maps	(501) 462-5953	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	No photos available
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,parks,playgrounds,tourist attraction, 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)
ChIJO6q9InLbvlQRWVYilNWiAO4	Haystack West Shore Campground and Day Use Area	9900 SW Haystack Dr, Culver, OR 97734, USA	44.4938930	-121.1603700	24,628 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 447-2599	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)
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)
ChIJM0dISpwrv1QR8GyDGbKYePQ	HealthCore Chiropractic & Rehab	605 NW 6th St, Redmond, OR 97756, USA	44.2812030	-121.1745900	956 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 548-4086	View Hours Monday: 7:30 AM – 5:30 PM Tuesday: 7:30 AM – 5:30 PM Wednesday: 7:30 AM – 5:30 PM Thursday: 7:30 AM – 5:30 PM Friday: 7:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	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,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,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.2532250	-121.1606130	2,403 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,bars,cocktails,nightlife,pubs, breakfast, cocktails, dining, family friendly, 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)