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: 13
Limit per Page: 25
Offset: 300
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.name, p.name) ASC LIMIT 300, 25

Previous Next

Page 13 of 24

Showing 301 to 325 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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 Beef & Lamb and The Ranch Market	695 SW Helmholtz Way, Redmond, OR 97756, USA	44.2697340	-121.2204420	3,718 m		farmers 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
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)
ChIJIY4A5uUrv1QRrwJL41M8GwA	Little Bug Play Hub	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		playgrounds	establishment,point_of_interest	Page \| Maps \| Website	(541) 699-1828	View Hours Monday: 9:30 AM – 2:00 PM, 3:00 – 5:00 PM Tuesday: 9:30 – 11:30 AM Wednesday: 9:30 AM – 2:00 PM Thursday: 9:30 AM – 2:00 PM Friday: 9:30 AM – 2:00 PM, 3:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ8QthECgrv1QRCEBuWDpd6-U	Loco Place	1106 SW Highland Ave, Redmond, OR 97756, USA	44.2693550	-121.1797660	590 m		desserts, food trucks	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps	(541) 527-1238	View Hours Monday: Closed 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)
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 Ste 103, Redmond, OR 97756, USA	44.2480660	-121.1885990	2,970 m		bars, cocktails, live music	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 (3)
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, 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	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
ChIJk1eVk1Irv1QR_eZlbb-NUCo	M Caffè	235 SW 6th St, Redmond, OR 97756, USA	44.2749870	-121.1745630	268 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: 5:00 AM – 12:00 PM Wednesday: 5:00 AM – 12:00 PM Thursday: 5:00 AM – 12:00 PM Friday: 5:00 AM – 12:00 PM Saturday: 6:00 AM – 12:00 PM Sunday: Closed	View Photos (4)
ChIJ6y3y0nQrv1QRpIFul8xhRhg	M&w Markets	900 SW 23rd St, Redmond, OR 97756, USA	44.2679840	-121.1934960	1,642 m		grocery stores, markets, shopping	establishment,hardware_store,home_goods_store,point_of_interest,store	Page \| Maps	(541) 548-5070	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJkyaul87UuFQREuznlPAyt6Q	Madaline’s Grill & Steak House	2414 S Hwy 97, Redmond, OR 97756, USA	44.2536460	-121.1826990	2,223 m		bars, cocktails, desserts, dining, food trucks, lunch, nightlife, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-9964	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJO4clJtUrv1QReKuj0qaWep8	Maple Moon Home & Gift	307 NW 7th St, Redmond, OR 97756, USA	44.2785020	-121.1756100	668 m		gift shops, grocery stores, shopping	home_goods_store,grocery_or_supermarket,food,point_of_interest,store,establishment	Page \| Maps \| Website	(541) 279-6652	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: Closed	View Photos (4)
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)
ChIJLUCGgVkrv1QROkPLx-KGKfg	Marshalls	367 NW Oak tree Ln, Redmond, OR 97756, USA	44.2947120	-121.1705930	2,471 m		shopping	clothing_store,department_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 407-3483	View Hours Monday: 8:00 AM – 11:00 PM Tuesday: 8:00 AM – 11:00 PM Wednesday: 8:00 AM – 11:00 PM Thursday: 8:00 AM – 11:00 PM Friday: 8:00 AM – 11:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 11:00 PM	View Photos (4)
ChIJq3TOwKXSuFQR52junYwHgYI	Maston Trail System	20275 Newcomb Rd, Bend, OR 97701, USA	44.2116340	-121.3029780	12,316 m	outdoors	point-of-interest	establishment,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)