Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: redmond_search_term
Order: DESC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
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.redmond_search_term, p.redmond_search_term) DESC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term ↓	Types	Links	Phone	Hours	Photos
ChIJHXICnnzXvlQRRtxLRomdp7g	Maragas Winery	15523 US-97, Culver, OR 97734, USA	44.4116450	-121.1966530	15,564 m	beer-wine-spirits (edited)	wine bar (edited)	establishment,food,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 546-5464	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:30 AM – 5:00 PM Thursday: 11:30 AM – 5:00 PM Friday: 11:30 AM – 5:00 PM Saturday: 11:30 AM – 5:00 PM Sunday: 11:30 AM – 5:00 PM	View Photos (4)
ChIJrXpiFPDWvlQRG-3o3C_xDZc	Ranch at the Canyons	11050 Vineyard Way, Terrebonne, OR 97760, USA	44.3671610	-121.1576830	10,592 m	beer-wine-spirits (edited)	wine bar (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-6020	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: Closed Sunday: Closed	View Photos (4)
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)
ChIJcW-Sam0rv1QR9ECnVg5Zqlo	Sunshine Wellness	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2663330	-121.1681220	838 m		wellness center	establishment,health,point_of_interest,spa	Page \| Maps	(541) 678-2826		No photos available
ChIJCWSgmJQrv1QRvGaKKlPLFzU	Optimal Medicine	753 SW 11th St A, Redmond, OR 97756, USA	44.2697820	-121.1799000	571 m		wellness center	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 728-0700	View Hours Monday: 8:00 AM – 4:30 PM Tuesday: 8:00 AM – 4:30 PM Wednesday: 8:00 AM – 4:30 PM Thursday: 8:00 AM – 4:30 PM Friday: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJFXDUCfFslVQRdF6uv_osPDI	Vertical Wall Headache and Migraine Specialist	4361 SW 36th St, Redmond, OR 97756, USA	44.2358470	-121.2100490	5,000 m		wellness center	establishment,health,physiotherapist,point_of_interest	Page \| Maps \| Website	(541) 515-7208	View Hours Monday: 5:00 AM – 5:00 PM Tuesday: 5:00 AM – 5:00 PM Wednesday: 5:00 AM – 5:00 PM Thursday: 5:00 AM – 5:00 PM Friday: 5:00 AM – 5:00 PM Saturday: 12:00 – 3:30 PM Sunday: Closed	View Photos (4)
ChIJgXHubysrv1QRcyfruHw7F38	McFarland Chiropractic	1421 S Hwy 97, Redmond, OR 97756, USA	44.2629760	-121.1773340	1,106 m		wellness center	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 516-8300	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 12:00 PM Thursday: 10:00 AM – 6:00 PM Friday: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4645	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJbcRszS0vv1QRPJ0woaqPeFw	Faith Hope & Charity Vineyards	70450 NW Lower Valley Dr, Terrebonne, OR 97760, USA	44.3447630	-121.3328980	14,979 m	beer-wine-spirits (edited)	vineyards (edited)	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 526-5075	View Hours Monday: 12:00 – 5:00 PM Tuesday: 12:00 – 5:00 PM Wednesday: 12:00 – 5:00 PM Thursday: 12:00 – 5:00 PM Friday: 12:00 – 5:00 PM Saturday: 12:00 – 5:00 PM Sunday: 12:00 – 5:00 PM	View Photos (4)
ChIJmQ339SLVuFQR8BblLnQMm7o	Redmond Air Center	1740 SE Ochoco Way, Redmond, OR 97756, USA	44.2606240	-121.1476130	2,483 m	family-friendly (edited)	tours (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-7200	View Hours Monday: 7:45 AM – 4:30 PM Tuesday: 7:45 AM – 4:30 PM Wednesday: 7:45 AM – 4:30 PM Thursday: 7:45 AM – 4:30 PM Friday: 7:45 AM – 4:30 PM Saturday: Closed Sunday: Closed	No photos available
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps			View Photos (1)
ChIJb52RXr3nvlQRRhegjVpoyGw	アキラクリフ AKIRA CLIFF	SW Pearl Rd, Culver, OR 97734, USA	44.5797330	-121.2612690	34,847 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps		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)
ChIJF5aY71vXvlQREFMtragTlMk	Asterisk Observatory @ The Spot	10136 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3680890	-121.1327250	11,110 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)
ChIJH87OW_ndvlQRFwvcFQzhXG8	SW Jordan Bridge	SW Jordan Rd, Terrebonne, OR 97760, USA	44.5288570	-121.2646800	29,390 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps		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)
ChIJj5QTJGopv1QRvjAqvzGZE2s	Eagle Rock	8825 NW 93rd Ln, Terrebonne, OR 97760, USA	44.3602440	-121.2859710	13,206 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJsX15N_LSuFQRyKuyO3eC6NY	Petersen Rock Garden & Museum	7930 SW 77th St, Redmond, OR 97756, USA	44.2033160	-121.2622450	10,435 m		tourist attraction	establishment,museum,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 904-0557	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: Closed Wednesday: Closed Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJWW_oVLfdvlQRui_hg2lwa6E	Jericho Lane Farmhouse	3999-3301 SW Jericho Ln, Culver, OR 97734, USA	44.5020890	-121.1969430	25,581 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJJ1BVuNkqv1QRWc322019HaA	Possibilities Thrift Store Redmond	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458090	-121.1885220	3,200 m		thrift stores, vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 3: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: Closed	View Photos (4)
ChIJ4a5qy88qv1QROtr91A-aVVg	Opportunity Foundation	835 OR-126, Redmond, OR 97756, USA	44.2716820	-121.1615910	987 m		thrift stores	establishment,point_of_interest	Page \| Maps \| Website	(541) 548-2611	View Hours Monday: 6:30 AM – 6:00 PM Tuesday: 6:30 AM – 5:30 PM Wednesday: 6:30 AM – 6:00 PM Thursday: 6:30 AM – 6:00 PM Friday: 6:30 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJheZMTdPUuFQRX4JCePotlSk	BrightSide Animal Center Thrift Store	838 NW 5th St, Redmond, OR 97756, USA	44.2842020	-121.1727440	1,291 m		thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 504-0101	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 – 5:30 PM Saturday: 9:00 AM – 5:30 PM Sunday: 9:00 AM – 5:30 PM	View Photos (4)
ChIJS3vg0HMrv1QR_mp-qOBFnnw	Trendy Tots	344 SW 7th St, Redmond, OR 97756, USA	44.2738500	-121.1750820	165 m		thrift stores	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 279-4704	View Hours Monday: 11:00 AM – 4:00 PM Tuesday: 11:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 11:00 AM – 4:00 PM Friday: 11:00 AM – 4:00 PM Saturday: 11:00 AM – 4:00 PM Sunday: Closed	No photos available
ChIJu7-NM84qv1QR_ncvUM9mTtk	Opportunity Foundation of Central Oregon Thrift Store	3294 S Hwy 97, Redmond, OR 97756, USA	44.2457250	-121.1885150	3,209 m		thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 3: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: Closed	No photos available
ChIJbaLhTsnUuFQRrd_3e_KIS9I	Redmond Cinemas	1535 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2528390	-121.1845470	2,357 m		theatres	establishment,movie_theater,point_of_interest	Page \| Maps \| Website	(541) 548-8777	View Hours Monday: 1:30 – 10:00 PM Tuesday: 1:30 – 10:00 PM Wednesday: 1:30 – 10:00 PM Thursday: 1:30 – 10:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 11:00 PM	View Photos (4)
ChIJKdLcu4Qsv1QROnJXkSKnQPw	Cline Falls State Scenic Viewpoint	7100 OR-126, Redmond, OR 97756, USA	44.2706410	-121.2562830	6,561 m		state parks	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949		View Photos (4)