Charming Cottage with Peekaboo Views of Devils LakeTucked away in a quiet location, this darling cottage offers peace, privacy, and just the right amount of character. Enjoy glimpses of Devils Lake from your sunny rooftop deck or host summer BBQs on the private, wind-sheltered patio. Inside, you'll find 2 bedrooms plus a den—ideal for guests, hobbies, or a home office. The vaulted living room showcases original hardwood floors and a cozy gas fireplace, creating a warm and inviting atmosphere. A beautiful redwood tree adds natural beauty to the yard, which also offers space to play or garden.Recent updates include a brand-new roof (April 2025) and fresh interior paint. All appliances are included, and furnishings are negotiable, making this home truly move-in ready. Located near Chinook Winds Golf Resort, the casino, and convenient shopping and dining options. Perfectly priced—this gem won't last long!
Hwy 101, Turn on Neotsu Dr, stay on Neotsu, Turn left on K Avenue, house on right side of street
Dwelling Type: Residential
Subdivision: Neotsu Residence
Year Built: 1950, County: US
Hwy 101, Turn on Neotsu Dr, stay on Neotsu, Turn left on K Avenue, house on right side of street
Listing is courtesy of Cascade Hasson Sotheby's International Realty
1 x Application (97.68%) | 453.60ms |
1 x Booting (2.29%) | 10.63ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
select * from `agents` where `id` is null limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `resoapi_properties` where `ListingId` = '147335118' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 518486 and `reso_property_saves`.`ListingId` is not null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "usmetrorealty.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] ]
0 of 0array:71 [▼ "USER" => "rootusmrcom" "HOME" => "/home/rootusmrcom" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/web/single-property/details/147335118" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/147335118" "REMOTE_PORT" => "28162" "SCRIPT_FILENAME" => "/home/rootusmrcom/public_html/index.php" "SERVER_ADMIN" => "webmaster@usmetrorealty.com" "CONTEXT_DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "REMOTE_ADDR" => "216.73.216.63" "SERVER_PORT" => "443" "SERVER_ADDR" => "67.222.9.129" "SERVER_NAME" => "usmetrorealty.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶" "HTTP_X_HTTPS" => "1" "HTTP_HOST" => "usmetrorealty.com" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "3912708-37-7" "H2_STREAM_ID" => "7" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "usmetrorealty.com" "HTTPS" => "on" "SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/147335118" "SCRIPT_URL" => "/web/single-property/details/147335118" "UNIQUE_ID" => "aGgRJyyWyxyj6SHNj1XV5QAAAgw" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "3912708-37-7" "REDIRECT_H2_STREAM_ID" => "7" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "usmetrorealty.com" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/147335118" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/147335118" "REDIRECT_UNIQUE_ID" => "aGgRJyyWyxyj6SHNj1XV5QAAAgw" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1751650600.4287 "REQUEST_TIME" => 1751650600 "argv" => [] "argc" => 0 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 04 Jul 2025 17:36:40 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkM1TDJSbExBQlNSbnRQSkxuVEFEbnc9PSIsInZhbHVlIjoiajlBUnJnRVE5VkdMOHp2ajFBRlZZb3R4TklQL3ZQbTBoOGZzeVczUzhCQms1cUExU2tPb3JCamU5VDlGV3lVMi9kQkV6VGM4cU1LWVZzY1lPMkgvWXQ4QlVoQ3VSN2dmMkdUYnlLQzhKYS9qTlcrK21LblR5aVBJR3grdjl6dTUiLCJtYWMiOiJmZWE0ZWUyNmE5YWIzMDFlNmVhZWNiZWY1MmE2MzZjM2VkNjQxMmE3YjM5MDNjMjI1MjJlNDk1ZTFlNTc3MjU5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 23:26:40 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkM1TDJSbExBQlNSbnRQSkxuVEFEbnc9PSIsInZhbHVlIjoiajlBUnJnRVE5VkdMOHp2ajFBRlZZb3R4TklQL3ZQbTBoOGZzeVczUzhCQms1cUExU2tPb3JCamU5VDlGV3lVMi9kQkV6V ▶" 1 => "us_metro_realty_session=eyJpdiI6ImNabnhBVVNQTFlvZ2lRRHhXd1BEbWc9PSIsInZhbHVlIjoiTjBTdGtrME9pN1pVL2VhTktFVjFIZ1RpUlhFMG9haEVJekh3dEpSWHVtb1hQUC9ibWxSK0FJd0JzbnFKRHg4bTJYYXZzV29TcHM1TDYxaDNPVEFYWjI5TThLdC9nOHlEQ2F5ZCtGS0xvNFg3SDRkZ09uVmJoVytpT2ExQzA1VkEiLCJtYWMiOiI3MmQ1NzkzZmNkNGQ5ZTU2YzliMzhkNDQzYjRmYWNlYjZiOGI4NzA4NWNiN2EyNjdlZmEwMGEwODFlNmQ5ZWI0IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 23:26:40 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6ImNabnhBVVNQTFlvZ2lRRHhXd1BEbWc9PSIsInZhbHVlIjoiTjBTdGtrME9pN1pVL2VhTktFVjFIZ1RpUlhFMG9haEVJekh3dEpSWHVtb1hQUC9ibWxSK0FJd0JzbnFK ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkM1TDJSbExBQlNSbnRQSkxuVEFEbnc9PSIsInZhbHVlIjoiajlBUnJnRVE5VkdMOHp2ajFBRlZZb3R4TklQL3ZQbTBoOGZzeVczUzhCQms1cUExU2tPb3JCamU5VDlGV3lVMi9kQkV6VGM4cU1LWVZzY1lPMkgvWXQ4QlVoQ3VSN2dmMkdUYnlLQzhKYS9qTlcrK21LblR5aVBJR3grdjl6dTUiLCJtYWMiOiJmZWE0ZWUyNmE5YWIzMDFlNmVhZWNiZWY1MmE2MzZjM2VkNjQxMmE3YjM5MDNjMjI1MjJlNDk1ZTFlNTc3MjU5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 23:26:40 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkM1TDJSbExBQlNSbnRQSkxuVEFEbnc9PSIsInZhbHVlIjoiajlBUnJnRVE5VkdMOHp2ajFBRlZZb3R4TklQL3ZQbTBoOGZzeVczUzhCQms1cUExU2tPb3JCamU5VDlGV3lVMi9kQkV6V ▶" 1 => "us_metro_realty_session=eyJpdiI6ImNabnhBVVNQTFlvZ2lRRHhXd1BEbWc9PSIsInZhbHVlIjoiTjBTdGtrME9pN1pVL2VhTktFVjFIZ1RpUlhFMG9haEVJekh3dEpSWHVtb1hQUC9ibWxSK0FJd0JzbnFKRHg4bTJYYXZzV29TcHM1TDYxaDNPVEFYWjI5TThLdC9nOHlEQ2F5ZCtGS0xvNFg3SDRkZ09uVmJoVytpT2ExQzA1VkEiLCJtYWMiOiI3MmQ1NzkzZmNkNGQ5ZTU2YzliMzhkNDQzYjRmYWNlYjZiOGI4NzA4NWNiN2EyNjdlZmEwMGEwODFlNmQ5ZWI0IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 23:26:40 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6ImNabnhBVVNQTFlvZ2lRRHhXd1BEbWc9PSIsInZhbHVlIjoiTjBTdGtrME9pN1pVL2VhTktFVjFIZ1RpUlhFMG9haEVJekh3dEpSWHVtb1hQUC9ibWxSK0FJd0JzbnFK ▶" ] ]
0 of 0array:4 [▼ "_token" => "f7DU3Fnyva7O4z1wjQcnrbUrYg16zvv3LoOI0XOB" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/147335118" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]