× Properties
Featured Property Arizona Property Oregon Property
Neighborhoods Market Activity Downloads OUR TEAM Contact Realtor
  • OTHER
    Our Story About Portland Report
  • INFO
    Portland Metro Phoenix Metro Portland Metro Area
    • Join Us Sign Up Login

    CHARLESTON ESTATES VARIOUS LOTS REPLAT

    Property • Residential
    Web ID # 6843977

    $899,900.00

    4 Beds • 4 Baths
    Property Features
  • High Speed Internet
  • Granite Counters
  • Double Vanity
  • Eat-in Kitchen
  • Breakfast Bar
  • 9+ Flat Ceilings
  • No Interior Steps
  • Kitchen Island
  • Full Bth Master Bdrm
  • Separate Shwr & Tub
  • Biking/Walking Path
  • Stucco
  • Wood Frame
  • Painted
  • Agency Discl Req
  • Seller Discl Avail
  • Block
  • Fire Pit
  • None
  • Built-in Barbecue
  • Natural Gas
  • Ceiling
  • Sprinklers In Rear
  • Sprinklers In Front
  • Gravel/Stone Front
  • Gravel/Stone Back
  • Auto Timer H2O Front
  • Auto Timer H2O Back
  • RV Gate
  • Garage Door Opener
  • Direct Access
  • Tile
  • None
  • City Water
  • Cash
  • Conventional
  • VA Loan
    • Attachment 1
    Attachment 2
    Arizona Regional Multiple Listing Service (ARMLS)

    Welcome to Charleston Estates, an INCREDIBLE single-level home community located near to the NEW Frontier Family Park. Prepare to be impressed by this EXQUISITE ''LIKE NEW'' EXECUTIVE Home w/all the bells & whistles! Upon arrival, you're greeted by spectacular curb appeal, further a sizable courtyard w/stone pavers. The sophisticated interior boasts a split layout w/a total of 4 bedrms. 3.5 bths, 3 car garage, open concept great rm, large eat-in kitchen & formal dining. TRULY AN ENTERTAINER'S DREAM! Add'l features are 3 secondary bedrms & bathrms that are centered on a BONUS/FLEX ROOM. The interior is loaded with EXCEPTIONAL upgrades incl; vinyl plank, shutters, tile, custom entertainment wall in great room w/cabinetry, architectural archways in hallways, large stone accented wall, 2 tone paint. You will LOVE access from formal dining to your very own private courtyard. This is the perfect extension to enjoy indoor/outdoor dining & entertaining year-round. The HIGHLY appointed Pro Kitchen acts as the hub of this BEAUTIFUL Home. Features incl; An oversized island, custom white cabinetry, crown molding, stainless appliances, built-in refrigerator, 6 burner gas cooktop, GORGEOUS granite countertops w/custom stone tile backsplash, and a HUGE walk-in pantry. LARGE laundry room w/cabinets and a massive amount of storage easily accessible from the kitchen, secondary bedrms. flex rm. & great rm. The luxurious master bedrm & ensuite is a showstopper! Features incl; large double sink vanity, soaking tub with tile surround, walk in glass shower, a large walk-in master closet & access to backyard. Owners spared no expense when they designed this SPECTACULAR RESORT STYLE BACKYARD OASIS. Your year-round vacation starts here...1st up w/ a sparkling pool, water feature, travertine decking then on to the multiple ramadas w/custom built-in BBQ, sink, refrigerator, privacy blinds & firepit, large, covered patio w/travertine pavers, and finally the GORGEOUS LUSH MATURE LANDSCAPE that surrounds the ENTIRE yard offering MAXIMUM PRIVACY...Az living at its FINEST, this home is truly PERFECTION!
    From AZ-24 Head South on Signal Butte Rd, Turn right onto E Domingo Rd, Turn right onto S 223rd Pl, Turn left onto E Russet Rd. Property will be on the right.

    Dwelling Type: Residential
    Subdivision: CHARLESTON ESTATES VARIOUS LOTS REPLAT
    Year Built: 2018, County:
    From AZ-24 Head South on Signal Butte Rd, Turn right onto E Domingo Rd, Turn right onto S 223rd Pl, Turn left onto E Russet Rd. Property will be on the right.

    Virtual Tour

    Listing is courtesy of HomeSmart

    Kalim Qamar
    888-313-0001
    Share to your Friends
    Close
    Messages5TimelineExceptionsViews4RouteQueries30Models114Livewire0MailsGateSessionRequest
    8.2.28PHP Version1.28sRequest Duration3MBMemory UsageGET web/single-property/details/{id}Route
    • warninglog[17:16:55] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
    • warninglog[17:16:56] LOG.warning: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecate...
    • warninglog[17:16:56] LOG.warning: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecate...
    • warninglog[17:16:56] LOG.warning: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecate...
    • warninglog[17:16:56] LOG.warning: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecate...
    warning
    • Booting (11.55ms)
    • Application (1.26s)
    • 1 x Application (99.09%)
      1.26s
      1 x Booting (0.91%)
      11.55ms
      4 templates were rendered
      • frontend.reso-property-details (resources/views/frontend/reso-property-details.blade.php)4blade
        Params
        0
        dataInfo
        1
        agentId
        2
        agentData
        3
        userData
      • layouts.frontend.footer (resources/views/layouts/frontend/footer.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        dataInfo
        4
        agentId
        5
        agentData
        6
        userData
        7
        __currentLoopData
        8
        image
        9
        key
        10
        loop
        11
        extension
        12
        feature
        13
        item
        14
        i
        15
        file
        16
        imageExtensions
      • layouts.frontend.app (resources/views/layouts/frontend/app.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        dataInfo
        4
        agentId
        5
        agentData
        6
        userData
        7
        __currentLoopData
        8
        image
        9
        key
        10
        loop
        11
        extension
        12
        feature
        13
        item
        14
        i
        15
        file
        16
        imageExtensions
      • layouts.frontend.navbar (resources/views/layouts/frontend/navbar.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        dataInfo
        4
        agentId
        5
        agentData
        6
        userData
        7
        __currentLoopData
        8
        image
        9
        key
        10
        loop
        11
        extension
        12
        feature
        13
        item
        14
        i
        15
        file
        16
        imageExtensions
      uri
      GET web/single-property/details/{id}
      middleware
      web
      controller
      App\Http\Controllers\Frontend\FrontendController@resoPropertyDetails
      as
      front.resoPropertyDetails
      namespace
      prefix
      /web
      where
      file
      app/Http/Controllers/Frontend/FrontendController.php:973-985
      30 statements were executed, 27 of which were duplicated, 3 unique64.23ms
      rootusmrcom_usmetroprod
      • select * from `agents` where `id` is null limit 1
        790μs/app/Http/Controllers/Frontend/FrontendController.php:976rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 15. /app/Http/Controllers/Frontend/FrontendController.php:976
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `resoapi_properties` where `ListingId` = '6843977' limit 1
        56.09ms/app/Http/Controllers/Frontend/FrontendController.php:983rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 6843977
        Backtrace
        • 15. /app/Http/Controllers/Frontend/FrontendController.php:983
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 650129 and `reso_property_saves`.`ListingId` is not null limit 1
        430μsview::5cec7846f2c883aea1720f3db64a7dc715322933:237rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 650129
        Backtrace
        • 20. view::5cec7846f2c883aea1720f3db64a7dc715322933:237
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        540μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        240μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        200μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        200μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        200μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        200μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        200μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `neighbour_menus`
        250μs/app/Helpers.php:128rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 15. /app/Helpers.php:128
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `neighbour_menus`
        200μs/app/Helpers.php:128rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 15. /app/Helpers.php:128
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 1
        260μs/app/Helpers.php:146rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Helpers.php:146
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        210μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 1
        220μs/app/Helpers.php:146rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Helpers.php:146
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 2
        280μs/app/Helpers.php:152rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 2
        Backtrace
        • 14. /app/Helpers.php:152
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        260μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 2
        320μs/app/Helpers.php:152rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 2
        Backtrace
        • 14. /app/Helpers.php:152
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 1
        410μs/app/Helpers.php:146rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Helpers.php:146
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 1
        290μs/app/Helpers.php:146rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Helpers.php:146
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 2
        280μs/app/Helpers.php:152rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 2
        Backtrace
        • 14. /app/Helpers.php:152
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `page_builders` where `status` = 1 and `main_menu` = 2
        280μs/app/Helpers.php:152rootusmrcom_usmetroprod
        Metadata
        Bindings
        • 0. 1
        • 1. 2
        Backtrace
        • 14. /app/Helpers.php:152
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `website_infos` limit 1
        410μs/app/Helpers.php:15rootusmrcom_usmetroprod
        Metadata
        Backtrace
        • 18. /app/Helpers.php:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      App\Models\PageBuilder
      24
      App\Models\NeighbourMenu
      72
      App\Models\WebsiteInfo
      17
      App\Models\ResoapiProperties
      1
          _token
          aklI2L3Z4RTDzu55CwAOGLLXBJhAkq7DRti3M9zM
          _previous
          array:1 [ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/6843977" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /web/single-property/details/6843977
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array: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"
  ]
]
          request_server
            0 of 0   
          array:59 [▼
  "USER" => "rootusmrcom"
  "HOME" => "/home/rootusmrcom"
  "PATH_TRANSLATED" => "redirect:/index.php/single-property/details/6843977"
  "PATH_INFO" => "/web/single-property/details/6843977"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/index.php/web/single-property/details/6843977"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REMOTE_PORT" => "36401"
  "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.141"
  "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" => "2880203-85-1"
  "H2_STREAM_ID" => "1"
  "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/6843977"
  "SCRIPT_URL" => "/index.php/web/single-property/details/6843977"
  "UNIQUE_ID" => "aG1ShyfuZVI14U7jh3AjlgABEgI"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php/web/single-property/details/6843977"
  "REQUEST_TIME_FLOAT" => 1751995015.6652
  "REQUEST_TIME" => 1751995015
  "argv" => []
  "argc" => 0
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 08 Jul 2025 17:16:55 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdmSkh4KzNyMFJCNUovaHBuZ0JUWmc9PSIsInZhbHVlIjoidnprSnA2TXZaTU4vU200U1A1ZWJTeUhPZ05zekZTWHRyTXRtZWYwYmJ1akhseTVBM2V4cXpsV3o3T0owbkQzcnlzWjNzNFJYWlZwVXlMVFhENHFXQTJuSlBBMWdpcjY0RzVpS2srK0pXQmVmMmh2RnpjRUsrbmdpQkgyaXRZc1kiLCJtYWMiOiIwMjZiNWViM2I2MzczMzE3YzgyZTU0OTJhMGNlMDc5MDQ5YjkzMWRhZTJjOTU1NmFjNzhkNTE5NDM3MmI5MzQ3IiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 23:06:56 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjdmSkh4KzNyMFJCNUovaHBuZ0JUWmc9PSIsInZhbHVlIjoidnprSnA2TXZaTU4vU200U1A1ZWJTeUhPZ05zekZTWHRyTXRtZWYwYmJ1akhseTVBM2V4cXpsV3o3T0owbkQzcnlzWjNzN ▶"
    1 => "us_metro_realty_session=eyJpdiI6IkZNNWcyOEpybkRzNUwyWktadXF2N0E9PSIsInZhbHVlIjoiQmh3NzBHOGNtOGovVXRBSFNwbzZWbHRzemhWS2hkUWtFVmQyQ2xuYVIxNjVCWVBwU0NLM2N0aVh2bjNYb05LcmU5NzN3RUFod21QS1BLVEQ0Vm8wZHZ5SWQrVnlRbHBWVXpXb0JZM295OU9BL0NFNDl3RTF0NWF0cjg2bHJZWkoiLCJtYWMiOiJiMjZjNTQyMDQ1NjA4YTgwNTA4ZWQ0ZDFiNjFkM2ZhZTY1YzdjYmQ3MjAyNzA3NmRjNmIwMmNjYmIyOGVhOGZmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 23:06:56 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IkZNNWcyOEpybkRzNUwyWktadXF2N0E9PSIsInZhbHVlIjoiQmh3NzBHOGNtOGovVXRBSFNwbzZWbHRzemhWS2hkUWtFVmQyQ2xuYVIxNjVCWVBwU0NLM2N0aVh2bjNY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdmSkh4KzNyMFJCNUovaHBuZ0JUWmc9PSIsInZhbHVlIjoidnprSnA2TXZaTU4vU200U1A1ZWJTeUhPZ05zekZTWHRyTXRtZWYwYmJ1akhseTVBM2V4cXpsV3o3T0owbkQzcnlzWjNzNFJYWlZwVXlMVFhENHFXQTJuSlBBMWdpcjY0RzVpS2srK0pXQmVmMmh2RnpjRUsrbmdpQkgyaXRZc1kiLCJtYWMiOiIwMjZiNWViM2I2MzczMzE3YzgyZTU0OTJhMGNlMDc5MDQ5YjkzMWRhZTJjOTU1NmFjNzhkNTE5NDM3MmI5MzQ3IiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 23:06:56 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdmSkh4KzNyMFJCNUovaHBuZ0JUWmc9PSIsInZhbHVlIjoidnprSnA2TXZaTU4vU200U1A1ZWJTeUhPZ05zekZTWHRyTXRtZWYwYmJ1akhseTVBM2V4cXpsV3o3T0owbkQzcnlzWjNzN ▶"
    1 => "us_metro_realty_session=eyJpdiI6IkZNNWcyOEpybkRzNUwyWktadXF2N0E9PSIsInZhbHVlIjoiQmh3NzBHOGNtOGovVXRBSFNwbzZWbHRzemhWS2hkUWtFVmQyQ2xuYVIxNjVCWVBwU0NLM2N0aVh2bjNYb05LcmU5NzN3RUFod21QS1BLVEQ0Vm8wZHZ5SWQrVnlRbHBWVXpXb0JZM295OU9BL0NFNDl3RTF0NWF0cjg2bHJZWkoiLCJtYWMiOiJiMjZjNTQyMDQ1NjA4YTgwNTA4ZWQ0ZDFiNjFkM2ZhZTY1YzdjYmQ3MjAyNzA3NmRjNmIwMmNjYmIyOGVhOGZmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 23:06:56 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IkZNNWcyOEpybkRzNUwyWktadXF2N0E9PSIsInZhbHVlIjoiQmh3NzBHOGNtOGovVXRBSFNwbzZWbHRzemhWS2hkUWtFVmQyQ2xuYVIxNjVCWVBwU0NLM2N0aVh2bjNY ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▼
  "_token" => "aklI2L3Z4RTDzu55CwAOGLLXBJhAkq7DRti3M9zM"
  "_previous" => array:1 [▶
    "url" => "https://usmetrorealty.com/index.php/web/single-property/details/6843977"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]