Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: redmond_search_term
Order: ASC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
Total Pages: 26

Results:

Total Available Records: 642
Total After Limits: 642
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.redmond_search_term, p.redmond_search_term) ASC LIMIT 0, 25

Page 1 of 26

Showing 1 to 25 of 642 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 Ste 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)
ChIJJUmrfdsqv1QRf6qgLozqdNU	Cash Connection Redmond – Pawn Shop	132 NW 6th St, Redmond, OR 97756, USA	44.2770780	-121.1739090	496 m		antiques	establishment,finance,jewelry_store,point_of_interest,store	Page \| Maps \| Website	(541) 923-6501	View Hours Monday: 9:00 AM – 5:30 PM Tuesday: 9:00 AM – 5:30 PM Wednesday: 9:00 AM – 5:30 PM Thursday: 9:00 AM – 5:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 10:00 AM – 5:30 PM Sunday: Closed	View Photos (2)
ChIJA79NDP8rv1QRF0PEgshqtyg	Atomic Bazaar Vintage	617 SW Cascade Ave, Redmond, OR 97756, USA	44.2746450	-121.1747330	234 m		antiques, antiques,boutiques,shopping,thrift stores,vintage, shopping, thrift stores, vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 350-6392	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJU7q3vtgqv1QRx0NS-JiVQKk	The Back Porch & Company	2127 S Hwy 97, Redmond, OR 97756, USA	44.2566580	-121.1821550	1,892 m		antiques, antiques,gift shops,thrift stores,vintage, shopping, vintage	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 526-1161	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJyR2EdNoqv1QRRsZZ3yPCE4s	Beyond the Ranch Antiques	339 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727870	-121.1718870	163 m		antiques, antiques,shopping,thrift stores,vintage, gift shops, shopping, thrift stores, vintage	clothing_store,establishment,home_goods_store,point_of_interest,shoe_store,store	Page \| Maps	(541) 279-4867	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: 12:00 – 5:00 PM	View Photos (4)
ChIJ_THn_9kqv1QRWktUgL14nsg	Redmond Antique Mall	106 SE Evergreen Ave Ste M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, antiques,shopping,thrift stores,vintage, shopping, vintage	establishment,furniture_store,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6208	View Hours Monday: 10:30 AM – 5:30 PM Tuesday: 10:30 AM – 5:30 PM Wednesday: 10:30 AM – 5:30 PM Thursday: 10:30 AM – 5:30 PM Friday: 10:30 AM – 5:30 PM Saturday: 10:30 AM – 5:30 PM Sunday: 11:00 AM – 4: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)
ChIJ3c37x9sqv1QR21Xj3io7Jcg	Welcome Home	229 SW 6th St, Redmond, OR 97756, USA	44.2751220	-121.1745870	283 m		antiques,gift shops,shopping,thrift stores, gift shops, shopping, thrift stores	establishment,home_goods_store,point_of_interest,store	Page \| 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)
ChIJm3h5Lysrv1QRPI5Q-Q6IvmU	St. Vincent De Paul Thrift Store	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		antiques,thrift stores, shopping, thrift stores	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-9840	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 9:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJheZMTdPUuFQRX4JCePotlSk	BrightSide Animal Center Thrift Store	838 NW 5th St, Redmond, OR 97756, USA	44.2842020	-121.1727440	1,291 m		antiques,thrift stores, thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 504-0101	View Hours Monday: Closed Tuesday: 9:00 AM – 5:30 PM Wednesday: 9:00 AM – 5:30 PM Thursday: 9:00 AM – 5:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 9:00 AM – 5:30 PM Sunday: 9:00 AM – 5:30 PM	View Photos (4)
ChIJu7-NM84qv1QR_ncvUM9mTtk	Opportunity Foundation of Central Oregon Thrift Store	3294 S Hwy 97, Redmond, OR 97756, USA	44.2457250	-121.1885150	3,209 m		antiques,thrift stores, thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 3: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: Closed	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)
ChIJJ1BVuNkqv1QRWc322019HaA	Possibilities Thrift Store Redmond	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458090	-121.1885220	3,200 m		antiques,thrift stores,vintage, thrift stores, vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-5288	View Hours Monday: 9:00 AM – 3: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: Closed	View Photos (4)
ChIJOYjHWdAqv1QRs1kl_odTSZo	Farmers Cooperative Antiques (edited)	106 SE Evergreen Ave # A, Redmond, OR 97756, USA (edited)	44.2724420	-121.1685410	429 m	market-farms, shopping (edited)	antiques,vintage (edited)	home_goods_store,store,point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7975	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJBSuElSbGuFQRWAFqyTcfSC4	Be-Bop Biscotti	1950 SW Badger Ave Ste 105, Redmond, OR 97756, USA	44.2379950	-121.1898010	4,053 m		bakeries	establishment,food,point_of_interest	Page \| Maps \| Website	(888) 545-7487		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
ChIJraK7Q0Arv1QR3NI0tMHyIFM	Becky Jeanne’s	2556 SW Reindeer Ave, Redmond, OR 97756, USA	44.2563070	-121.1973270	2,601 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 848-7305	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: Closed Saturday: 9:30 AM – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJeRO2t9cqv1QRbg6I-B-a7bI	Ida’s Cupcake Cafe, Redmond	445 SW 6th St, Redmond, OR 97756, USA	44.2729040	-121.1745710	61 m		bakeries, bakeries,desserts, 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 – 6:00 PM Saturday: 10:00 AM – 6: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, bakeries,desserts, 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)
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)
ChIJR2YSzywrv1QRFMFpi__40e4	Safeway Bakery	1705 S Hwy 97, Redmond, OR 97756, USA	44.2608850	-121.1794290	1,377 m		bakeries, bakeries,desserts, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-4160		View Photos (3)
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)
ChIJsWvgtTorv1QR7nZokyoRTfo	Yo Wild	915 SW Rimrock Way Ste 202, Redmond, OR 97756, USA	44.2681230	-121.1928520	1,588 m		bakeries, bakeries,desserts, desserts, family friendly, juice bars	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 699-1253	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ783ygCUrv1QRRwXQuwX_b8A	The Chocolate Company	895 SW Rimrock Way #102, Redmond, OR 97756, USA	44.2689610	-121.1935080	1,612 m		bakeries, bakeries,desserts,gift shops, desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-8298	View Hours Monday: 11:00 AM – 5:30 PM Tuesday: 11:00 AM – 5:30 PM Wednesday: 11:00 AM – 5:30 PM Thursday: 11:00 AM – 5:30 PM Friday: 11:00 AM – 5:30 PM Saturday: 11:00 AM – 5:30 PM Sunday: Closed	View Photos (4)