Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: types
Order: ASC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
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.types, p.types) ASC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types ↑	Links	Phone	Hours	Photos
ChIJI8dU-Nkqv1QRN-Far_-Up8k	Redmond Municipal Airport	2522 Jesse Butler Cir Suite 6, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m	getting-here	airports	airport,establishment,point_of_interest	Page \| Maps \| Website	(541) 504-3499	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: 9:00 AM – 5:00 PM	View Photos (4)
ChIJ-WEQJKfVuFQR7aUmMSzyg0U	Alaska Airlines – Redmond	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m		airports	airport,establishment,point_of_interest	Page \| Maps \| Website	(800) 225-2752		View Photos (4)
ChIJg46ufybVuFQRHqdDNMuhm7Y	DAM Creative-Redbubble	2250 SW 21st St, Redmond, OR 97756, USA	44.2557690	-121.1912850	2,329 m		boutiques, gift shops	art_gallery,clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website		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	No photos available
ChIJxc72pugrv1QRkz_TL0pGE4U	Art & Music	232 SW 5th St, Redmond, OR 97756, USA	44.2749500	-121.1729040	271 m		live music	art_gallery,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4426	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: 11:00 AM – 6:00 PM Wednesday: 11:00 AM – 6:00 PM Thursday: 11:00 AM – 6:00 PM Friday: 11:00 AM – 6:00 PM Saturday: 12:00 – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJVyqBfc3UuFQRyF5VqWVf6Wo	Circle K	2005 S Hwy 97, Redmond, OR 97756, USA	44.2576860	-121.1812990	1,761 m		coffee shops, shopping	atm,cafe,convenience_store,establishment,finance,food,gas_station,point_of_interest,store	Page \| Maps \| Website	(541) 548-6337	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)
ChIJ8QDweigrv1QRwTPXkMJmaak	US Market	1242 SW Highland Ave, Redmond, OR 97756, USA	44.2693280	-121.1815900	712 m		bars, coffee shops, desserts, grocery stores, markets, meat markets, shopping	atm,cafe,convenience_store,establishment,finance,food,grocery_or_supermarket,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-3325	View Hours Monday: 5:00 AM – 9:00 PM Tuesday: 5:00 AM – 9:00 PM Wednesday: 5:00 AM – 9:00 PM Thursday: 5:00 AM – 9:00 PM Friday: 5:00 AM – 9:00 PM Saturday: 5:00 AM – 9:00 PM Sunday: 6:00 AM – 9:00 PM	View Photos (4)
ChIJZwG7UMorv1QR4waKoN6quq8	Big O Bagels	816 SW 17th St, Redmond, OR 97756, USA	44.2691120	-121.1864300	1,070 m		bakeries, breakfast, coffee shops	bakery,cafe,establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website		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)
ChIJi01lkdsqv1QRgRhDS7YoyZI	One Street Down Cafe	124 SW 7th St, Redmond, OR 97756, USA	44.2760830	-121.1751470	397 m		bakeries, breakfast, coffee shops, lunch, restaurants	bakery,cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 647-2341	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)
ChIJq5Iqoe0qv1QRFMvVnidFRgw	Full Throttle Java	255 SW 5th St, Redmond, OR 97756, USA	44.2751400	-121.1734370	283 m		coffee shops, juice bars	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 788-0010	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: 5:30 AM – 1:00 PM Sunday: Closed	View Photos (4)
ChIJU2jFEZArv1QR15K7pxTuIcU	Junction Roastery • Social Club	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734010	-121.1756070	160 m		cocktails, coffee shops	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: 7:00 AM – 4:00 PM Tuesday: 7:00 AM – 4:00 PM Wednesday: 7:00 AM – 4:00 PM Thursday: 7:00 AM – 4:00 PM Friday: 7:00 AM – 4:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4:00 PM	View Photos (4)
ChIJ773SkGjHuFQRYTQjK2CjrQ0	Kooki	235 SW 6th St, Redmond, OR 97756, USA	44.2749580	-121.1745550	265 m		bakeries, coffee shops, desserts	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-4855	View Hours Monday: Closed 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: Closed	View Photos (4)
ChIJUWGjFY0qv1QRQX5P_OxYtaU	Walmart Supercenter	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2922730	-121.1709140	2,198 m		bookstores, coffee shops, desserts, farmers markets, grocery stores, juice bars, pool tables, shopping	bakery,clothing_store,department_store,electronics_store,establishment,food,furniture_store,grocery_or_supermarket,hardware_store,home_goods_store,point_of_interest,store	Page \| 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)
ChIJn7Yvw9cqv1QRXO_Q4mkIpSc	Fred Meyer	944 SW Veterans Way, Redmond, OR 97756, USA	44.2674110	-121.1770610	631 m		coffee shops, desserts, grocery stores, juice bars, pool tables, shopping	bakery,establishment,florist,food,grocery_or_supermarket,health,liquor_store,point_of_interest,store	Page \| Maps \| Website	(541) 504-5100	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)
ChIJSxaI0ywrv1QR4Jkdxy6TfMI	Safeway	1705 S Hwy 97, Redmond, OR 97756, USA	44.2607570	-121.1796260	1,395 m		coffee shops, desserts, grocery stores, juice bars, meat markets, pool tables, shopping	bakery,establishment,florist,food,grocery_or_supermarket,point_of_interest,store,supermarket	Page \| Maps \| Website	(541) 504-4160	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJ50h8Hdoqv1QRcz-tvXRNCf0	2Hearts Flower Shop	307 NW 7th St Suite B, Redmond, OR 97756, USA	44.2785190	-121.1756190	670 m		gift shops	bakery,establishment,florist,food,point_of_interest,store	Page \| Maps \| Website	(541) 280-1298	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: 10:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJ3b8T0ZYrv1QRx88GFPBG6HA	Pink Sprinkled Bakery	858 NW Redwood Ave, Redmond, OR 97756, USA	44.3002400	-121.1773270	3,083 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 350-7954	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM 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)
ChIJ57NAyJIqv1QRBC_xNo-WQ1U	Walmart Bakery	300 NW Oak tree Ln, Redmond, OR 97756, USA	44.2920420	-121.1705900	2,176 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| 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
ChIJeRO2t9cqv1QRbg6I-B-a7bI	Ida’s Cupcake Cafe, Redmond	445 SW 6th St, Redmond, OR 97756, USA	44.2729040	-121.1745710	61 m		bakeries, coffee shops, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-6077	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)
ChIJfRfuN9PUuFQRs1P7QLdg5Kc	La Frontera Bakery	1604 S Hwy 97, Redmond, OR 97756, USA	44.2604060	-121.1779640	1,396 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-8022	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)
ChIJh05fk9nUuFQRtAlE_5RSXdY	Franz Bakery Outlet Store	334 SE Timber Ave, Redmond, OR 97756, USA	44.2530980	-121.1655410	2,271 m		bakeries, 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)
ChIJR2YSzywrv1QRFMFpi__40e4	Safeway Bakery	1705 S Hwy 97, Redmond, OR 97756, USA	44.2608850	-121.1794290	1,377 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-4160		View Photos (4)
ChIJT9sehGgrv1QRLT4Ia-lqDfA	Best Moments Bakery	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 977-6433		View Photos (4)
ChIJw3eUFgIrv1QR1Im-STuPNPk	Sweet and Salty Shoppe	738 SW Highland Ave, Redmond, OR 97756, USA	44.2694640	-121.1762380	397 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 604-1062		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
ChIJlaawUQArv1QRkKMYlaUhOHI	Pangaea Guild Hall – Coffee and Cocktails	652 SW 6th St, Redmond, OR 97756, USA	44.2707520	-121.1739710	208 m		bars, cocktails, coffee shops, nightlife, pubs	bar,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-7641	View Hours Monday: Closed 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 – 11:00 PM Saturday: 9:00 AM – 11:00 PM Sunday: 9:00 AM – 10:00 PM	View Photos (4)