Lovingly Maintained & Spacious Home with Abundant Storage. Welcome to this beautifully updated 4-bedroom, 2.5-bath home offering both space and versatility. Inside, you'll find a bright living room, a cozy family room, a bonus area, and a fantastic garage conversion—complete with clever storage solutions throughout. Recent updates include fresh interior paint, new flooring and trim on the main level, a fully remodeled primary bathroom with upgraded PEX plumbing, new upstairs toilets, a modern half-bath sink and vanity, updated lighting fixtures in the main living areas and primary bedroom, a refreshed fireplace façade, and a 2-year-old water heater. Enjoy the outdoors year-round with stunning landscaping, a relaxing hot tub under a covered deck, and a welcoming patio perfect for entertaining. Additional storage is available in the tool shed, a small covered area, and a large fenced-in concrete pad—ideal for storing a boat, car, camper/RV, greenhouse, or other toys. This home truly has it all—space, updates, and smart functionality. Come and see it for yourself!
From Adams to West 2nd, right at Cypress, right at 6th, home on the left
Dwelling Type: Residential
Subdivision:
Year Built: 2004, County: US
From Adams to West 2nd, right at Cypress, right at 6th, home on the left
Listing is courtesy of MORE Realty
1 x Application (97.58%) | 400.79ms |
1 x Booting (2.39%) | 9.82ms |
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` = '491416031' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 667195 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/491416031" "PATH_INFO" => "/web/single-property/details/491416031" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/491416031" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "63927" "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.179" "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" => "3361104-792-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/491416031" "SCRIPT_URL" => "/index.php/web/single-property/details/491416031" "UNIQUE_ID" => "aHIGrZp_TkXq7M-LHk0epAAAFAE" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/491416031" "REQUEST_TIME_FLOAT" => 1752303277.7711 "REQUEST_TIME" => 1752303277 "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 => "Sat, 12 Jul 2025 06:54:37 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJ3YzNONVdtdEJoSWN0WldBWGRVOVE9PSIsInZhbHVlIjoiR05aY2hscURKMHRhengxKytVcTJoUVMyYU9YeUt5Y1RjVUJNSUFCNWdpeUlreWlBMGk3Q2wvRGljbkZQd0ZKTW15dlhvMDlKeWpWdytnbGZZNkNZL0w2UnFqMTVOUG1XL0FEelNFZDVwWHI2ZTE1Y1dPUkVSeHRuR1ZGWUV2UjEiLCJtYWMiOiJkNzE4MDkwZWNlMGIwM2RjODlmZDFlZGMzMzFkZDA4NDljNTdlM2E4ZjYzZDEzOGExN2IwZDJiZTVhYWEwYmNmIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 12:44:38 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJ3YzNONVdtdEJoSWN0WldBWGRVOVE9PSIsInZhbHVlIjoiR05aY2hscURKMHRhengxKytVcTJoUVMyYU9YeUt5Y1RjVUJNSUFCNWdpeUlreWlBMGk3Q2wvRGljbkZQd0ZKTW15dlhvM ▶" 1 => "us_metro_realty_session=eyJpdiI6IlhqQnhFNHN4emh5NER0RitiNVZnbkE9PSIsInZhbHVlIjoiMDd1OEVkWFF3eENwSU0wRWg3eUl6cFpnL1JUWE5XNlpjNi83aU5iU2VDb0NIWStYVW40dUVHSDVtSWVrcGxnaDhUNzdPTEcrYS85dFhuZzE0a0RyMXRkc1RicHhiOWp1VjdwVDhWa3oySnU5cXJYM05BYTVZaWszOUhHaG85K0YiLCJtYWMiOiI4MzM1Y2YyNDM1NDJjYTYzN2U5NjllMzZjMDEyNzY0OWI5NDc5YzFiNzQxOWFjMzkwYjU0N2VhMjgwMGJlZmNiIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 12:44:38 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IlhqQnhFNHN4emh5NER0RitiNVZnbkE9PSIsInZhbHVlIjoiMDd1OEVkWFF3eENwSU0wRWg3eUl6cFpnL1JUWE5XNlpjNi83aU5iU2VDb0NIWStYVW40dUVHSDVtSWVr ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJ3YzNONVdtdEJoSWN0WldBWGRVOVE9PSIsInZhbHVlIjoiR05aY2hscURKMHRhengxKytVcTJoUVMyYU9YeUt5Y1RjVUJNSUFCNWdpeUlreWlBMGk3Q2wvRGljbkZQd0ZKTW15dlhvMDlKeWpWdytnbGZZNkNZL0w2UnFqMTVOUG1XL0FEelNFZDVwWHI2ZTE1Y1dPUkVSeHRuR1ZGWUV2UjEiLCJtYWMiOiJkNzE4MDkwZWNlMGIwM2RjODlmZDFlZGMzMzFkZDA4NDljNTdlM2E4ZjYzZDEzOGExN2IwZDJiZTVhYWEwYmNmIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 12:44:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJ3YzNONVdtdEJoSWN0WldBWGRVOVE9PSIsInZhbHVlIjoiR05aY2hscURKMHRhengxKytVcTJoUVMyYU9YeUt5Y1RjVUJNSUFCNWdpeUlreWlBMGk3Q2wvRGljbkZQd0ZKTW15dlhvM ▶" 1 => "us_metro_realty_session=eyJpdiI6IlhqQnhFNHN4emh5NER0RitiNVZnbkE9PSIsInZhbHVlIjoiMDd1OEVkWFF3eENwSU0wRWg3eUl6cFpnL1JUWE5XNlpjNi83aU5iU2VDb0NIWStYVW40dUVHSDVtSWVrcGxnaDhUNzdPTEcrYS85dFhuZzE0a0RyMXRkc1RicHhiOWp1VjdwVDhWa3oySnU5cXJYM05BYTVZaWszOUhHaG85K0YiLCJtYWMiOiI4MzM1Y2YyNDM1NDJjYTYzN2U5NjllMzZjMDEyNzY0OWI5NDc5YzFiNzQxOWFjMzkwYjU0N2VhMjgwMGJlZmNiIiwidGFnIjoiIn0%3D; expires=Sat, 12-Jul-2025 12:44:38 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IlhqQnhFNHN4emh5NER0RitiNVZnbkE9PSIsInZhbHVlIjoiMDd1OEVkWFF3eENwSU0wRWg3eUl6cFpnL1JUWE5XNlpjNi83aU5iU2VDb0NIWStYVW40dUVHSDVtSWVr ▶" ] ]
0 of 0array:4 [▼ "_token" => "TFpIOzzySwxjnclw2damBj2Kc7Zq6qjewXKmZmPK" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/491416031" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]