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: 26
Limit per Page: 25
Offset: 625
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 625, 25

Previous Next

Page 26 of 27

Showing 626 to 650 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ40Diq0Mrv1QRyRIT0oTBa4U	Urban Homestead Company	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		gift shops, shopping	store,home_goods_store,point_of_interest,establishment	Maps \| Website	(541) 604-1062	View Hours Monday: 10:30 AM – 4:30 PM Tuesday: 10:30 AM – 4:30 PM Wednesday: 10:30 AM – 4:30 PM Thursday: 10:30 AM – 4:30 PM Friday: 10:30 AM – 4:30 PM Saturday: 10:30 AM – 4:30 PM Sunday: Closed	View Photos (4)
ChIJ8QDweigrv1QRwTPXkMJmaak	US Market	1242 SW Highland Ave, Redmond, OR 97756, USA	44.2692800	-121.1815430	711 m		bars, coffee shops, desserts, grocery stores, markets, meat markets, shopping	convenience_store,atm,meal_takeaway,grocery_or_supermarket,cafe,finance,restaurant,food,point_of_interest,store,establishment	Maps \| Website	(541) 548-3325	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:00 PM Friday: 5:00 AM – 10:00 PM Saturday: 5:00 AM – 10:00 PM Sunday: 6:00 AM – 9:00 PM	View Photos (4)
ChIJNc8VHKDIuFQRgw1Abi3Obss	USDA Forest Service	3160 NE 3rd St, Prineville, OR 97754, USA	44.3025670	-120.8092430	29,218 m		campgrounds	campground,lodging,park,point_of_interest,establishment	Maps \| Website	(541) 416-6500		View Photos (4)
ChIJ92Npl9sqv1QRt6F8lqOpNHg	Venetian Esthetique Day Spa	135 SW 6th St, Redmond, OR 97756, USA	44.2759520	-121.1745820	374 m		massage, spas	spa,point_of_interest,establishment	Maps	(541) 504-0260		No photos available
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	physiotherapist,health,point_of_interest,establishment	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)
ChIJNzFa8Nkqv1QRfwa83G_nxKM	Victoria Johnson LMT	BodyWise Chiropractic, 707 SW 9th St, Redmond, OR 97756, USA	44.2704140	-121.1777060	389 m		massage	point_of_interest,establishment	Maps \| Website	(541) 390-2999	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 9:30 AM – 6:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 3:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJF84mCAApv1QRuXbXrHpvjx8	View Point (edited)	9698-9098 Terrebonne-Lower Bridge Rd, Redmond, OR 97756, USA (edited)	44.3621310	-121.2874890	13,442 m		historic landmarks (edited)	establishment (edited)	Maps			No photos available
ChIJ50QvP3orv1QRougFqgGJJFE	VJ’s Meatball Subs	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		dining, family friendly, food trucks, live music, lunch	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 408-3102	View Hours Monday: Closed Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 8:00 PM Thursday: 12:00 – 8:00 PM Friday: 12:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJN3E_U_8rv1QRhG7eIP5Lf9U	Walgreens	1450 S Hwy 97, Redmond, OR 97756, USA	44.2624520	-121.1765580	1,150 m		coffee shops, juice bars, shopping	drugstore,convenience_store,clothing_store,health,store,food,point_of_interest,establishment	Maps \| Website	(541) 548-1731	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJ57NAyJIqv1QRBC_xNo-WQ1U	Walmart Bakery	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2920420	-121.1705900	2,176 m		bakeries	bakery,food,point_of_interest,store,establishment	Maps \| Website	(541) 923-1718	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	No photos available
ChIJUWGjFY0qv1QRQX5P_OxYtaU	Walmart Supercenter	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2922730	-121.1709140	2,198 m		bookstores, coffee shops, farmers markets, grocery stores, juice bars, pool tables, shopping	department_store,hardware_store,clothing_store,electronics_store,bakery,furniture_store,grocery_or_supermarket,home_goods_store,store,food,point_of_interest,establishment	Maps \| Website	(541) 923-5972	View Hours Monday: 6:00 AM – 11:00 PM Tuesday: 6:00 AM – 11:00 PM Wednesday: 6:00 AM – 11:00 PM Thursday: 6:00 AM – 11:00 PM Friday: 6:00 AM – 11:00 PM Saturday: 6:00 AM – 11:00 PM Sunday: 6:00 AM – 11:00 PM	View Photos (4)
ChIJvwn-JeLVuFQRwKZwm9v3Qn8	Warehouse Cognitive Surplus Fulfillment & Corporate Offices	725 SW Umatilla Ave, Redmond, OR 97756, USA	44.2516110	-121.1756260	2,340 m		gift shops	storage,point_of_interest,establishment	Maps \| Website	(971) 901-7521		View Photos (4)
ChIJ-Q-cWxErv1QR-aYDNGjdTPE	Wayfarer Club	525 SW 6th St, Redmond, OR 97756, USA	44.2721900	-121.1745760	71 m	bars-nightlife (edited)	bars (edited)	bar,night_club,restaurant,point_of_interest,food,establishment	Maps \| Website	(541) 508-7600	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 10:00 PM Wednesday: 3:00 – 10:00 PM Thursday: 3:00 – 10:00 PM Friday: 3:00 – 11:00 PM Saturday: 3:00 – 11:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)
ChIJpZ4LYCfGuFQRqT4vByXVdl0	We’re The Wurst	1810 SE 1st St Unit K, Redmond, OR 97756, USA	44.2591720	-121.1680080	1,568 m		food trucks, meat markets	store,food,point_of_interest,establishment	Maps \| Website	(541) 633-9800	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 3:00 PM Thursday: 9:00 AM – 3:00 PM Friday: 9:00 AM – 3:00 PM Saturday: 11:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJzRpnPRsrv1QRUcPZ6aKlO6s	Wealty Massage	635 SW Highland Ave, Redmond, OR 97756, USA	44.2698440	-121.1750110	321 m		massage	spa,point_of_interest,establishment	Maps	(458) 250-0522	View Hours Monday: 9:00 AM – 9:30 PM Tuesday: 9:00 AM – 9:30 PM Wednesday: 9:00 AM – 9:30 PM Thursday: 9:00 AM – 9:30 PM Friday: 9:00 AM – 9:30 PM Saturday: 9:00 AM – 9:30 PM Sunday: 9:00 AM – 9:30 PM	View Photos (4)
ChIJET4Crd8qv1QRq2rE6gc6Cnk	Weigand Family Dog Park (edited)	1429 W Antler Ave, Redmond, OR 97756 (edited)	44.2785010	-121.1837200	1,018 m	recreation (edited)	local parks (edited)	local_parks (edited)	Maps \| Website			No photos available
ChIJ3c37x9sqv1QR21Xj3io7Jcg	Welcome Home	229 SW 6th St, Redmond, OR 97756, USA	44.2751220	-121.1745870	283 m		antiques, gift shops, shopping, thrift stores, vintage	home_goods_store,point_of_interest,store,establishment	Maps \| Website	(541) 231-7349	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)
ChIJh3fAPiYrv1QRgGDwfzWKMWE	Westside One Stop	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2698810	-121.1853490	960 m		desserts, grocery stores, juice bars	convenience_store,gas_station,food,store,point_of_interest,establishment	Maps	(541) 923-8881	View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 11:00 PM Saturday: 6:00 AM – 11:00 PM Sunday: 6:00 AM – 10:00 PM	No photos available
ChIJV8BC0oMrv1QRvGJ7HlLoWQA	Whis Card Shop	1424 NW Canyon Dr, Redmond, OR 97756, USA	44.2895760	-121.1788580	1,926 m		gift shops	store,point_of_interest,establishment	Maps \| Website	(541) 316-0404		No photos available
ChIJkXL-w08rv1QRtsSMN5bYNpM	Whiskey Girls Coffee Co	722 NW 6th St, Redmond, OR 97756, USA	44.2823350	-121.1734520	1,081 m		cocktails, coffee shops	point_of_interest,establishment	Maps	(541) 279-3800	View Hours Monday: 5:30 AM – 5:00 PM Tuesday: 5:30 AM – 5:00 PM Wednesday: 5:30 AM – 5:00 PM Thursday: 5:30 AM – 5:00 PM Friday: 5:30 AM – 5:00 PM Saturday: 6:00 AM – 5:00 PM Sunday: 6:00 AM – 5:00 PM	View Photos (4)
ChIJlyhXsl9MuVQRw4aTaK_aW3E	White Fir Spring	White Fir Spring, Oregon 97754, USA	44.4045760	-120.5533500	51,488 m	outdoors	point-of-interest	natural_feature,establishment	Maps			View Photos (1)
ChIJPTADXAArv1QRLlpN6y3fSEM	Wholesale Outlet	798 NW 5th St #2, Redmond, OR 97756, USA	44.2834580	-121.1728760	1,208 m		thrift stores	clothing_store,point_of_interest,store,establishment	Maps \| Website	(541) 527-4377	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: 9:00 AM – 7:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJDeuVoh_VuFQR0aCLF4IQGNM	Wilco Farm Store	1649 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2541240	-121.1854630	2,253 m		grocery stores, pool tables, shopping, thrift stores	hardware_store,clothing_store,home_goods_store,shoe_store,food,point_of_interest,store,establishment	Maps \| Website	(541) 548-8345	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: 9:00 AM – 6:00 PM	View Photos (4)
ChIJxbIW-HIrv1QRKOA4ppkNBSg	Wild catch foodtruck	332 SW 5th St, Redmond, OR 97756, USA	44.2740610	-121.1729140	179 m		food trucks, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps	(541) 480-1677	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)
ChIJqR8ul88rv1QR79ZX9G_P44k	Wild Grown Farm	4255 NW Coyner Ave, Redmond, OR 97756, USA	44.3218940	-121.2170760	6,466 m		farms	point_of_interest,establishment	Maps \| Website	(503) 209-9873		View Photos (3)