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

Previous Next

Page 10 of 26

Showing 226 to 250 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ3fE9cB_dvlQRT8uZzKhRRqQ	Fin Reapers Bowfishing	305 E Sage Ln, Culver, OR 97734, USA	44.5220270	-121.2070470	27,857 m		fishing	establishment,point_of_interest	Page \| Maps \| Website	(541) 948-7099	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)
ChIJSfDiLh8pv1QRGaSykdvFp_4	Firefly Fields Northwest	3250 NW Odem Ave, Terrebonne, OR 97760, USA	44.3408040	-121.2059060	7,997 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 604-8330	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)
ChIJ-T0aQk0rv1QRXl5c2xj4dBs	Five Miles Taphouse	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		cocktails	establishment,food,point_of_interest	Page \| Maps	(541) 550-0667	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:30 – 8:00 PM Thursday: 4:30 – 8:00 PM Friday: 3:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJgUThwhnMuFQR6cfTBOP0Ess	Fly Spur Ranch	64460 Research Rd, Tumalo, OR 97703, USA	44.1410890	-121.3366310	19,548 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 389-4995	View Hours Monday: Closed Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ1_-hR9oqv1QRKuTyO-w_f94	Food Fellas	332 SW 5th St, Redmond, OR 97756, USA	44.2737650	-121.1728670	152 m		brewery, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:30 AM – 9:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 9:00 PM Saturday: 11:30 AM – 9:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJRT-PiyUrv1QR6okIejN80Lk	Forever Sunshine	215 SW 6th St, Redmond, OR 97756, USA	44.2752350	-121.1744750	294 m		boutiques, boutiques,shopping, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 233-9450	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: 11:00 AM – 5:00 PM	View Photos (2)
ChIJnzjFzwt1uFQR86h1XRnR7Ow	Fort Rock State Natural Area	Co Road 5-11A, Fort Rock, OR 97735, USA	43.3729120	-121.0661830	100,416 m	outdoors	point of interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJh05fk9nUuFQRtAlE_5RSXdY	Franz Bakery Outlet Store	334 SE Timber Ave, Redmond, OR 97756, USA	44.2530980	-121.1655410	2,271 m		bakeries, bakeries,desserts,grocery stores, grocery stores	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-5541	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 5:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: Closed	View Photos (3)
ChIJn7Yvw9cqv1QRKLP_mTuFt7Q	Fred Meyer Pharmacy	944 SW Veterans Way, Redmond, OR 97756, USA	44.2673050	-121.1765910	628 m		grocery stores	drugstore,establishment,health,pharmacy,point_of_interest,store	Page \| Maps \| Website	(541) 504-5133	View Hours Monday: 9:00 AM – 1:00 PM, 1:30 – 8:00 PM Tuesday: 9:00 AM – 1:00 PM, 1:30 – 8:00 PM Wednesday: 9:00 AM – 1:00 PM, 1:30 – 8:00 PM Thursday: 9:00 AM – 1:00 PM, 1:30 – 8:00 PM Friday: 9:00 AM – 1:00 PM, 1:30 – 8:00 PM Saturday: 9:00 AM – 1:00 PM, 1:30 – 6:00 PM Sunday: 10:00 AM – 1:00 PM, 1:30 – 5:00 PM	View Photos (4)
ChIJPUYKk0Irv1QRtWELCVJwXJk	Front Porch Bakery	1818 NW Ivy Ave, Redmond, OR 97756, USA	44.2852110	-121.1881860	1,803 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJwbPQJa4rv1QR0SUT3XW5BvA	Frozen- homemade rolled ice cream	NE 8th and, SW Glacier Ave, Redmond, OR 97756, USA	44.2710970	-121.1768210	286 m		bakeries, bakeries,desserts, desserts	establishment,food,point_of_interest,store	Page \| Maps	(541) 604-2444	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 5:00 – 9:00 PM Friday: 5:00 – 9:00 PM Saturday: 5:00 – 9:00 PM Sunday: 5:00 – 7:00 PM	View Photos (2)
ChIJYV1_RM7TuFQRYz15OAxCnFU	Fruition Farm Sporthorses	5707 SW Quarry Ave, Redmond, OR 97756, USA	44.2128500	-121.2364400	8,305 m		farms, horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0211	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: Closed Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJS-x57R4zv1QRDPdesf8EMMo	Fryrear Trail Head	Oregon 97703, USA	44.2486270	-121.4300100	20,567 m		trailheads	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:30 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 10:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJ_5C-g-8rv1QRA40ljJVODHI	Fuji Japanese food truck	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		food trucks, food trucks,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 285-6559	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: Closed Thursday: Closed Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJm6mHQ3rVvlQRSDW81P6M7OM	Full Circle Farms	2425 NE Upas Ave, Redmond, OR 97756, USA	44.3060590	-121.1397630	4,606 m		farms	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6340		View Photos (3)
ChIJq5Iqoe0qv1QRFMvVnidFRgw	Full Throttle Java	255 SW 5th St, Redmond, OR 97756, USA	44.2751490	-121.1734190	284 m		bars,coffee shops,family friendly,shopping, coffee shops, juice bars	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 788-0010	View Hours Monday: 5:30 AM – 8:00 PM Tuesday: 5:30 AM – 8:00 PM Wednesday: 5:30 AM – 8:00 PM Thursday: 5:30 AM – 8:00 PM Friday: 5:30 AM – 8:00 PM Saturday: 5:30 AM – 5:00 PM Sunday: 7:00 AM – 5:00 PM	View Photos (4)
ChIJKxby4dkqv1QRgXSRB6Ahtdc	Geek Geek Nerd Nerd	106 SE Evergreen Ave Ste J, Redmond, OR 97756, USA	44.2716900	-121.1679500	487 m		antiques,bookstores,shopping,vintage, 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		massage, spas	beauty_salon,establishment,hair_care,health,point_of_interest,spa	Page \| Maps \| Website	(541) 639-7753	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: 4:00 – 8:00 PM 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)
ChIJxYoUXJUqv1QR2h-mzXNFo5w	Gompers Distillery and Speakeasy	611 NE Jackpine Ct, Redmond, OR 97756, USA	44.2861270	-121.1627710	1,745 m		bars, brewery, cocktails, cocktails,nightlife,cocktails,brewery,distillery, 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)
ChIJ6UIv8QXVuFQRlSKPJUU7BA0	Good Friend	1950 SW Badger Ave Ste 109, Redmond, OR 97756, USA	44.2382480	-121.1897920	4,026 m		coffee shops,markets,breakfast	bakery,cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 224-8847	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: Closed 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
ChIJC-9gU5wrv1QR01Z7XSgAlPc	Grace and Goods	214 NW 6th St, Redmond, OR 97756, USA	44.2777070	-121.1740850	566 m		antiques,thrift stores,vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 239-3064	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 (2)
ChIJh11uyicrv1QRcL_Ry5em8LI	Grace and Hammer	641 SW Cascade Ave, Redmond, OR 97756, USA	44.2747650	-121.1750860	256 m		brewery, cocktails	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 668-6684	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed 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)