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: 19
Limit per Page: 25
Offset: 450
Total Pages: 27

Results:

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

Previous Next

Page 19 of 27

Showing 451 to 475 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ7wDCYTrTuFQRf_C6jwTzPZg	Precise Rifle Solutions	5637 SW Harvest Ave, Redmond, OR 97756, USA	44.2285230	-121.2360230	6,965 m		shooting ranges	store,point_of_interest,establishment	Maps \| Website	(541) 728-1952	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	No photos available
ChIJVVWxKksrv1QRks360QBDPPg	Prescott Honey	2668 SW Salmon Ave, Redmond, OR 97756, USA	44.2544860	-121.1988540	2,830 m		farms	point_of_interest,establishment	Maps \| Website	(541) 977-8848		No photos available
ChIJY7x3pWcrv1QRH7zW0Ps6WwM	Provisions Market at SCP Redmond	521 SW 6th St, Redmond, OR 97756, USA	44.2722780	-121.1745490	63 m		breakfast, coffee shops, grocery stores	cafe,restaurant,point_of_interest,food,store,establishment	Maps \| Website	(541) 508-7600	View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJ_-zwLdBQv1QRYNW5J1HOkrk	Proxy Falls	Proxy Falls, Oregon 97413, USA	44.1617860	-121.9278260	61,332 m	outdoors	point-of-interest	natural_feature,establishment	Maps			View Photos (4)
ChIJp3WRIwAtuVQRqq2plUKH1Lk	Quadruple Bypass Trailhead – 66 Trail System	Crook County, OR 97754, USA	44.3039340	-120.8873490	23,075 m		mountain biking	park,point_of_interest,establishment	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)
ChIJvVgVBYkrv1QRTWxDHj7vyRY	Quartz Park	2027 SW Quartz Ave, Redmond, OR 97756, USA	44.2588760	-121.1902130	2,005 m		parks, playgrounds	point_of_interest,establishment	Maps			View Photos (4)
ChIJzd47LvUqv1QRJqG9EjI_VZM	Quince Park	Redmond, OR 97756, USA	44.2985750	-121.1803660	2,931 m		parks, playgrounds	park,tourist_attraction,point_of_interest,establishment	Maps \| Website	(541) 504-2000	View Hours Monday: 6:00 AM – 9:00 PM Tuesday: 6:00 AM – 9:00 PM Wednesday: 6:00 AM – 9:00 PM Thursday: 6:00 AM – 9:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 9:00 PM	View Photos (4)
ChIJAdJCsmzXvlQRCQW_zStDTCg	Rainbow Trailhead	NW Rainbow Dr, Terrebonne, OR 97760, USA	44.3892410	-121.2391540	13,967 m		trailheads	park,point_of_interest,establishment	Maps			View Photos (1)
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)	point_of_interest,establishment	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)
ChIJcRSJ_xsrv1QRMSEW7IGnoNI	Red Beard Barbecue	652 NW 7th St, Redmond, OR 97756, USA	44.2818600	-121.1750010	1,031 m		food trucks, lunch, restaurants	restaurant,point_of_interest,food,establishment	Maps \| Website	(541) 480-8348	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJfVNbQNoqv1QRqiP6Sq4zUCU	Red Road Pizza Cart	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		family friendly, food trucks	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 639-5366	View Hours Monday: Closed 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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: Closed	View Photos (4)
ChIJPysfqIUrv1QRq6ZOE9Lje2I	Redefined Beauty	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m		spas	spa,health,point_of_interest,establishment	Maps \| Website	(503) 290-4028		View Photos (4)
ChIJhQraAQorv1QRC_hA9dZ1dW0	Redmond Aesthetics and Botox.	905 SW Rimrock Way B100, Redmond, OR 97756, USA	44.2683970	-121.1924100	1,545 m		spas	spa,health,point_of_interest,establishment	Maps \| Website	(541) 419-7737		View Photos (4)
ChIJmQ339SLVuFQR8BblLnQMm7o	Redmond Air Center (edited)	1740 SE Ochoco Way, Redmond, OR 97756, USA (edited)	44.2606240	-121.1476130	2,483 m	recreation (edited)	tours,tourist attraction, point of interest (edited)	point_of_interest,establishment (edited)	Maps \| Website (edited)	(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_THn_9kqv1QRWktUgL14nsg	Redmond Antique Mall	106 SE Evergreen Ave Suite M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, shopping, thrift stores, vintage	furniture_store,home_goods_store,store,point_of_interest,establishment	Maps \| Website	(541) 548-6208	View Hours Monday: 10:30 AM – 5:30 PM Tuesday: 10:30 AM – 5:30 PM Wednesday: 10:30 AM – 5:30 PM Thursday: 10:30 AM – 5:30 PM Friday: 10:30 AM – 5:30 PM Saturday: 10:30 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJqcIV0cvUuFQRET-QkeZuwpY	Redmond Area Park and Recreation District	465 SW Rimrock Way, Redmond, OR 97756, USA	44.2732850	-121.1905440	1,326 m		parks	point_of_interest,establishment	Maps \| Website	(541) 548-7275	View Hours Monday: 5:00 AM – 9:45 PM Tuesday: 5:00 AM – 9:45 PM Wednesday: 5:00 AM – 9:45 PM Thursday: 5:00 AM – 9:45 PM Friday: 5:00 AM – 9:45 PM Saturday: 1:00 – 5:00 PM Sunday: Closed	View Photos (3)
ChIJESUjeIMrv1QRh8YNKlzZ8zA	Redmond Armory Rental Venue	822 SW Highland Ave, Redmond, OR 97756, USA	44.2691660	-121.1769870	455 m		event venues	point_of_interest,establishment	Maps			No photos available
ChIJzUapk9wqv1QRZ4BT-v_1j3I	Redmond Burger Company	249 NW 6th St, Redmond, OR 97756, USA	44.2780770	-121.1746090	609 m		bars, breakfast, dining, family friendly, food trucks, lunch, pubs, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 316-5262	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJWdZZnMbUuFQRLf3pypk2hNo	Redmond Caves	SE Airport Way, Redmond, OR 97756, USA	44.2473780	-121.1776960	2,823 m	outdoors	hiking, nature preserve, parks, playgrounds, point of interest, point-of-interest, state parks, tourist attraction, tours	tourist_attraction,park,point_of_interest,establishment	Maps \| Website	(541) 416-6700	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJbaLhTsnUuFQRrd_3e_KIS9I	Redmond Cinemas	1535 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2528390	-121.1845470	2,357 m		theatres	movie_theater,point_of_interest,establishment	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)
ChIJbzCfc98qv1QRdt7BObrk4og	Redmond city skatepark	1604 W Antler Ave, Redmond, OR 97756, USA	44.2762370	-121.1844800	932 m		parks	point_of_interest,establishment	Maps		View Hours Monday: 8:00 AM – 12:00 AM Tuesday: 8:00 AM – 12:00 AM Wednesday: 8:00 AM – 12:00 AM Thursday: 8:00 AM – 12:00 AM Friday: 8:00 AM – 12:00 AM Saturday: 8:00 AM – 12:00 AM Sunday: 8:00 AM – 12:00 AM	View Photos (4)
ChIJ-xhWMNPVuFQR_rcUrq2xz4M	Redmond Coffee Company	3716 SW 21st Pl, Redmond, OR 97756, USA	44.2414960	-121.1908090	3,713 m		coffee shops	cafe,store,food,point_of_interest,establishment	Maps \| Website	(541) 598-4577	View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:30 AM – 2:00 PM Sunday: 7:30 AM – 2:00 PM	View Photos (4)
ChIJD7R9Xs3TuFQRw-SxzA-Oe-k	Redmond Community Concert Association	4555 SW Elkhorn Ave, Redmond, OR 97756, USA	44.2350660	-121.2190610	5,510 m		live music	point_of_interest,establishment	Maps \| Website	(541) 350-7222		No photos available
ChIJI3KHdN8qv1QR38-Ji4es9pk	Redmond Community Skate Park (edited)	1600 W Antler Ave, Redmond, OR 97756 (edited)	44.2762540	-121.1846100	942 m	recreation (edited)	parks, point of interest (edited)	park,point_of_interest,establishment (edited)	Maps \| Website			No photos available
ChIJA3Fz69kqv1QRhN-93Af4sVg	Redmond Farmers Market	725 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727660	-121.1755600	131 m		farmers markets	point_of_interest,establishment	Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 3:00 – 7:00 PM Saturday: Closed Sunday: Closed	View Photos (4)