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: 14
Limit per Page: 25
Offset: 325
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 325, 25

Previous Next

Page 14 of 26

Showing 326 to 350 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJJbfAg87UuFQR-bGTUcYnIB4	La Frontera	2330 S Hwy 97 #8873, Redmond, OR 97756, USA	44.2544620	-121.1821500	2,123 m		breakfast, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 275-6389	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: Closed	View Photos (4)
ChIJfRfuN9PUuFQRs1P7QLdg5Kc	La Frontera Bakery	1604 S Hwy 97, Redmond, OR 97756, USA	44.2604060	-121.1779640	1,396 m		bakeries, bakeries,desserts, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-8022	View Hours Monday: 8:00 AM – 8:00 PM 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 – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJeQv5HCgrv1QRkw7opOoGuuo	La Posada Mexican Grill	1029 SW Highland Ave, Redmond, OR 97756, USA	44.2697460	-121.1789850	515 m		breakfast, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7448	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 1:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJZ9UPn7DGuFQRJyuNFsdlgnA	Ladies Of Lead Group Therapy, LLC	905 SW Rimrock Way Suite 101A, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 788-5858	View Hours Monday: Closed 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: Closed Sunday: Closed	View Photos (4)
ChIJwx-908Iqv1QRGe04rDL_pt8	Lady Bug Flowers & Gifts	209 SW 5th St, Redmond, OR 97756, USA	44.2754220	-121.1735350	313 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 548-6188	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: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJOWuwNGorv1QRV_JZNgjJpvg	Larkin Valley Ranch	695 SW Helmholtz Way, Redmond, OR 97756, USA	44.2697340	-121.2204420	3,718 m		farmers markets, farmers markets,markets,farms,meat markets, farms, markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 420-0879	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ216Xg87UuFQRPim-k47dpok	Latrontera Mini Market	Redmond, OR 97756, USA	44.2542310	-121.1820710	2,145 m		juice bars	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps			No photos available
ChIJK4AEqoTHuFQR8miVL66lOW8	Lattanzi Spa	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m		massage	establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 350-5912	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: Closed Sunday: Closed	View Photos (4)
ChIJiQq70Scrv1QRHz6zY0wbg-s	Lavender Thrift & Gift	724 SW 14th St, Redmond, OR 97756, USA	44.2701030	-121.1826330	748 m		gift shops, shopping, thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 390-1594	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 12:00 – 4:30 PM Saturday: 12:00 – 4:30 PM Sunday: Closed	View Photos (1)
ChIJg-XAvMIqv1QRteJgcoy2g7Y	Lee Petmecky Massage	636 NW 6th St c, Redmond, OR 97756, USA	44.2815050	-121.1739190	988 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 815-4011		No photos available
ChIJGS2rrl3N-oYRIMtQgBP0rRw	Liberation Firearms Training	430 SE Evergreen Ave, Redmond, OR 97756, USA	44.2722920	-121.1656100	663 m	outdoors (edited)	hunting (edited)	establishment,point_of_interest,store	Page \| Maps \| Website	(458) 899-5215	View Hours Monday: Closed 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 – 7:00 PM Saturday: 10:00 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJE6w2StQqv1QR_nLbWKXA5og	Lions Lake	Lions Lake, Redmond, OR 97756, USA	44.2666850	-121.1704860	714 m		fishing	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJL1E4k88rv1QRBOuVBDNeEHM	Little & Luxe	239 SW 6th St, Redmond, OR 97756, USA	44.2749280	-121.1745480	261 m		gift shops,shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 316-3783	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 – 5:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJIY4A5uUrv1QRrwJL41M8GwA	Little Bug Play Hub	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		family fun,parks, playgrounds	establishment,point_of_interest	Page \| Maps \| Website	(541) 238-6701	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: 9:00 AM – 5:00 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJ8QthECgrv1QRCEBuWDpd6-U	Loco Place	1106 SW Highland Ave, Redmond, OR 97756, USA	44.2693550	-121.1797660	590 m		desserts, food trucks, food trucks,restaurants,lunch,family friendly	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps	(541) 527-1238	View Hours Monday: Closed 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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ79Inuosrv1QRgVCck7bm4cI	Lombardy’s Tavern (This is NOT Bangers & Brews)	lunch (edited)	44.2690550	-121.1756600	420 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: Closed 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 – 7:00 PM	View Photos (4)
ChIJQb3g8rcmuVQRYSJ9Dv2rX-Q	Lone Pine Campground	OR-27, Prineville, OR 97754, USA	44.1296040	-120.8369880	31,214 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700	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)
ChIJ-84vWdcqv1QRvW4ya-5O9RE	Los Brothers Taco Shop	542 SW 6th St, Redmond, OR 97756, USA	44.2719440	-121.1738890	75 m		lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 504-7178	View Hours Monday: 9:00 AM – 8:30 PM Tuesday: 9:00 AM – 8:30 PM Wednesday: 9:00 AM – 8:30 PM Thursday: 9:00 AM – 8:30 PM Friday: 9:00 AM – 8:30 PM Saturday: 9:00 AM – 8:30 PM Sunday: Closed	View Photos (4)
ChIJgTOYyknVuFQRWSMhLTLHqyE	Los Langostinos Restaurant	3113 S Hwy 97 #103, Redmond, OR 97756, USA	44.2480660	-121.1885990	2,970 m		bars, cocktails, live music, live music,restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 604-7580	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)
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	establishment,point_of_interest	Page \| Maps			No photos available
ChIJAQAUQGosv1QRzH9ldH-i9jg	Lucid Farms	640 NW 103rd St, Redmond, OR 97756, USA	44.2824300	-121.2946810	9,676 m		farms	establishment,point_of_interest	Page \| Maps	(503) 407-5293		No photos available
ChIJkfbA9UzSuFQRsoE2vhas2kY	Lucky 7	2392 S Hwy 97, Redmond, OR 97756, USA	44.2541200	-121.1823950	2,165 m		bars, bars,nightlife,pool tables,bars,nightlife,pool tables,pubs, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4377	View Hours Monday: 10:00 AM – 9:00 PM Tuesday: 10:00 AM – 12:00 AM Wednesday: 10:00 AM – 12:00 AM Thursday: 10:00 AM – 12:00 AM Friday: 10:00 AM – 12:00 AM Saturday: 10:00 AM – 12:00 AM Sunday: 10:00 AM – 9:00 PM	View Photos (4)
ChIJBctTKD_VuFQRjPPbpggeKXQ	Luna View Park	3660 SW Reservoir Dr, Redmond, OR 97756, USA	44.2499970	-121.2107270	3,863 m		parks, parks,playgrounds	establishment,park,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJP0mlmRvXvlQRuMOtOI2wDCM	Luna’s Taqueria	1350 NW Canal Blvd, Redmond, OR 97756, USA	44.2880580	-121.1679440	1,781 m		breakfast, restaurants	restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(541) 279-3356	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJESpW8d8rv1QRCvdItyDWcPM	Lunar massage	418 SW 6th St, Redmond, OR 97756, USA	44.2732420	-121.1739770	69 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0513	View Hours Monday: 10:30 AM – 8:00 PM Tuesday: 12:00 – 5:00 PM Wednesday: 10:30 AM – 8:00 PM Thursday: 10:30 AM – 5:00 PM Friday: 10:30 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available