You're probably wondering why this home is still on the market - we'll tell you! See that beautiful tree in the backyard? It provides amazing shade from the summer heat but it also has roots extending under the house which have made for some elevation variation you can feel in the flooring. The sellers have said with their furniture in the house it was hardly noticeable. The sellers have paid for a structural engineer's evaluation and a tree evaluation from a certified arborist in order to provide you with a full and complete outlook, request a copy! This home is now priced with this information in mind and is a steal of a deal at 375k. With 3 spacious bedrooms, 2 full bathrooms, a 2 car garage and RV or boat parking with a fully fenced yard this home is a great value! With a brand new roof, garage door, gutters, and fresh exterior paint, this house is move in ready. Save yourself the cost of a home inspection, ask your Realtor for a copy of the clean pre-listing inspection. The primary bedroom includes an ensuite bathroom and a walk-in closet, providing a private retreat with great separation from the other two bedrooms. Additional features include a central vac system, gas cooking range, a spacious kitchen pantry and a new backyard shed. Located in a quiet neighborhood near a beautiful and convenient walking trail, yet still conveniently close to River Road's amenities and conveniences, this home offers the perfect balance of tranquility and access to everything you need.
River Rd to Ferndale Dr
Dwelling Type: Residential
Subdivision:
Year Built: 1999, County: US
River Rd to Ferndale Dr
Listing is courtesy of Colter Home Co.
1 x Application (97.22%) | 429.53ms |
1 x Booting (2.74%) | 12.12ms |
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` = '793294116' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 818734 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:59 [▼ "USER" => "rootusmrcom" "HOME" => "/home/rootusmrcom" "PATH_TRANSLATED" => "redirect:/index.php/single-property/details/793294116" "PATH_INFO" => "/web/single-property/details/793294116" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/793294116" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "14116" "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.125" "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" => "1993690-2766-5" "H2_STREAM_ID" => "5" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "usmetrorealty.com" "HTTPS" => "on" "SCRIPT_URI" => "https://usmetrorealty.com/index.php/web/single-property/details/793294116" "SCRIPT_URL" => "/index.php/web/single-property/details/793294116" "UNIQUE_ID" => "aHdRPFolDxxJmTK5ViDDiAAAVwk" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/793294116" "REQUEST_TIME_FLOAT" => 1752650044.6318 "REQUEST_TIME" => 1752650044 "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 => "Wed, 16 Jul 2025 07:14:04 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkEzUXVuZXlWNlFZVkJicHlXWDYxWnc9PSIsInZhbHVlIjoiL1I0cURZbzIyeWJSRlBFaStFbHU2dmd3MHdnSElEcEx5SlFIS0xmSzBpb3pWRTZGYWNnVlEzWFJQYUg5Zm4wMllvTGZKZlBlWW12cHFCS0huTkFTcUNIbHlwbDcwdkZrTGYrVkpYRGxSVExBL3BNZytMVFlrUk9xSDBwelV4Yk4iLCJtYWMiOiJiZjk0NTA0ZDBhNmE0MTc5NTVjNzE3ZTEzMmQ1ZjRkOGIwODNlMTljZWUxNGJiNTMwZmJlNDgwMGQ2ODU1YThhIiwidGFnIjoiIn0%3D; expires=Wed, 16-Jul-2025 13:04:05 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkEzUXVuZXlWNlFZVkJicHlXWDYxWnc9PSIsInZhbHVlIjoiL1I0cURZbzIyeWJSRlBFaStFbHU2dmd3MHdnSElEcEx5SlFIS0xmSzBpb3pWRTZGYWNnVlEzWFJQYUg5Zm4wMllvTGZKZ ▶" 1 => "us_metro_realty_session=eyJpdiI6InBNa1RmbFFreUl1ZTl5RHVRYW9pd3c9PSIsInZhbHVlIjoiTjd0TjJyQlJjMGd4YnBlZTUrQm1GQURpU0ZOWjJzM3ZrTzFuNDFSQjN1VmYyMnptUUFkLzgwc1NiMDVvczRhR3gxbGhORFhheEd0RVI2TjNpZXlZaEhXTU43MWxVVHJZa2dYV1ovWnBLKy9GdUhWS3psd2hPaWkyZUNNMURhNVQiLCJtYWMiOiJhNDBjMmE3ODU1NTNjMjU4YWQ5MTQ4OTYwOGRmNGIyYmFiNDI1YWVmYTQ3ZDBlODNkNzYyYmE1ZTc1OGZiMjllIiwidGFnIjoiIn0%3D; expires=Wed, 16-Jul-2025 13:04:05 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6InBNa1RmbFFreUl1ZTl5RHVRYW9pd3c9PSIsInZhbHVlIjoiTjd0TjJyQlJjMGd4YnBlZTUrQm1GQURpU0ZOWjJzM3ZrTzFuNDFSQjN1VmYyMnptUUFkLzgwc1NiMDVv ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkEzUXVuZXlWNlFZVkJicHlXWDYxWnc9PSIsInZhbHVlIjoiL1I0cURZbzIyeWJSRlBFaStFbHU2dmd3MHdnSElEcEx5SlFIS0xmSzBpb3pWRTZGYWNnVlEzWFJQYUg5Zm4wMllvTGZKZlBlWW12cHFCS0huTkFTcUNIbHlwbDcwdkZrTGYrVkpYRGxSVExBL3BNZytMVFlrUk9xSDBwelV4Yk4iLCJtYWMiOiJiZjk0NTA0ZDBhNmE0MTc5NTVjNzE3ZTEzMmQ1ZjRkOGIwODNlMTljZWUxNGJiNTMwZmJlNDgwMGQ2ODU1YThhIiwidGFnIjoiIn0%3D; expires=Wed, 16-Jul-2025 13:04:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkEzUXVuZXlWNlFZVkJicHlXWDYxWnc9PSIsInZhbHVlIjoiL1I0cURZbzIyeWJSRlBFaStFbHU2dmd3MHdnSElEcEx5SlFIS0xmSzBpb3pWRTZGYWNnVlEzWFJQYUg5Zm4wMllvTGZKZ ▶" 1 => "us_metro_realty_session=eyJpdiI6InBNa1RmbFFreUl1ZTl5RHVRYW9pd3c9PSIsInZhbHVlIjoiTjd0TjJyQlJjMGd4YnBlZTUrQm1GQURpU0ZOWjJzM3ZrTzFuNDFSQjN1VmYyMnptUUFkLzgwc1NiMDVvczRhR3gxbGhORFhheEd0RVI2TjNpZXlZaEhXTU43MWxVVHJZa2dYV1ovWnBLKy9GdUhWS3psd2hPaWkyZUNNMURhNVQiLCJtYWMiOiJhNDBjMmE3ODU1NTNjMjU4YWQ5MTQ4OTYwOGRmNGIyYmFiNDI1YWVmYTQ3ZDBlODNkNzYyYmE1ZTc1OGZiMjllIiwidGFnIjoiIn0%3D; expires=Wed, 16-Jul-2025 13:04:05 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6InBNa1RmbFFreUl1ZTl5RHVRYW9pd3c9PSIsInZhbHVlIjoiTjd0TjJyQlJjMGd4YnBlZTUrQm1GQURpU0ZOWjJzM3ZrTzFuNDFSQjN1VmYyMnptUUFkLzgwc1NiMDVv ▶" ] ]
0 of 0array:4 [▼ "_token" => "ZzGZVA2F2T8r0bSojDP7Dsg8WRmdjreauD0yXOCf" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/793294116" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]