观澜湖上东区Ⅲ区

龙华区 · 海南省海口市龙华区羊山大道39号观澜湖新城内

在售
参考均价21000.00元/㎡获取最新报价
主力户型
暂无资料
物业类型
板式
装修情况
豪装,
开盘时间
2022-12-30
交房时间
2024-08-30
开发商
海南骏博旅游发展有限公司
最新优惠与可售房源

我们竭诚为您提供全岛机场24小时接送服务,永久免费登岛服务,团购报名,需提前2天报名!

电话咨询

专业置业顾问一对一服务 · 不收取咨询费用

楼盘信息

信息更新时间:2026-08-11
楼盘名称
观澜湖上东区Ⅲ区
所属区域
龙华区
参考均价
21000.00 元/㎡
产权年限
70年
容积率
1.5
绿化率
25%
物业公司
深圳骏高物业服务有限公司海口分公司
物业费
5元/m²/月
停车位
668 (地上:169 个 地下:499个)
售楼地址
海南省海口市龙华区羊山大道39号观澜湖地产营销中心

项目介绍

待定

PROPERTY VIDEOS

楼盘视频

共 1 个
观澜湖上东区Ⅲ区楼盘视频

PROPERTY ALBUM

楼盘相册

共 20 张
实景图
实景图实景图
效果图2
效果图2效果图
效果图
效果图效果图
样板间5
样板间5样板间图
样板间4
样板间4样板间图
样板间3
样板间3样板间图
样板间2
样板间2样板间图
样板间
样板间样板间图
效果图4
效果图4效果图
效果图3
效果图3效果图
效果图2
效果图2效果图
效果图1
效果图1效果图
实景图3
实景图3实景图
实景图2
实景图2实景图
实景图1
实景图1实景图
配套图3
配套图3配套图
配套图2
配套图2配套图
配套图1
配套图1配套图
交通图
交通图交通图
鸟瞰图
鸟瞰图效果图

FLOOR PLANS

户型图

共 4 个户型

PROPERTY SANDBOX

楼盘沙盘

共 19 栋
观澜湖上东区Ⅲ区沙盘图
在售待售售罄点击楼栋查看基本信息
楼栋状态单元层数户数梯户比开盘 / 交房
18#在售1816-2022-12-01 / 2024-08
19#在售1816-2022-12-01 / 2024-08
20#在售2832-2022-12-01 / 2024-08
21#在售1816-2022-12-01 / 2024-08
1#待售0---待定 / 待定
2#待售0---待定 / 待定
3#待售0---待定 / 待定
4#待售0---待定 / 待定
5#待售0---待定 / 待定
6#待售0---待定 / 待定
7#待售0---待定 / 待定
8#在售0---待定 / 待定
33#在售28321梯2户待定 / 待定
32#在售28321梯2户待定 / 待定
31#在售28321梯2户待定 / 待定
30#在售18161梯2户待定 / 待定
29#在售18321梯2户待定 / 待定
28#在售18161梯2户待定 / 待定
27#在售18161梯2户待定 / 待定

PROPERTY NEWS

楼盘动态

海南观澜湖上东Ⅲ区住宅现房在售
海南观澜湖上东Ⅲ区住宅现房在售

观澜湖上东Ⅲ区 住宅在售建面约97-143㎡,在售均价约21000元/㎡,在售总价约230万元/套起,现房在售。

2025-01-03
海口
观澜湖上东Ⅲ区在售建面约100-143㎡的低密度洋房
观澜湖上东Ⅲ区在售建面约100-143㎡的低密度洋房

观澜湖上东Ⅲ区 低密低容的建筑排布、宽境宽景的通透采光、更优的梯户比配置、较高的空间得房率,也让更多的人为洋房产品所倾心。

2024-12-06
海口
观澜湖上东Ⅲ区商铺在售建面约36-136㎡
观澜湖上东Ⅲ区商铺在售建面约36-136㎡

观澜湖上东Ⅲ区 社区交通设计采用人车分流,创造一个恬静、悠闲的休闲居住场所。园林景观以亲近自然为目的,充分利用水景与绿化,创造丰富舒适的绿化空间。

2024-11-04
海口
观澜湖上东三区 充分利用水景与绿化,创造丰富舒适的绿化空间
观澜湖上东三区 充分利用水景与绿化,创造丰富舒适的绿化空间

观澜湖上东Ⅲ区 项目产品为建筑面积97-143㎡现代简约风格板式洋房(现房在售),南北双阳台,一梯两户,楼间距可达150米。

2024-09-24
海口
观澜湖上东Ⅲ区住宅在售总价约230万元/套
观澜湖上东Ⅲ区住宅在售总价约230万元/套

观澜湖上东Ⅲ区 项目住宅在售,建面约97-143㎡,在售均价约21000元/㎡,在售总价约230万元/套起。活动截止于2024年8月15日

2024-08-30
海口
观澜湖上东Ⅲ区推出2套优惠房源,建面约103.13-118.46㎡
观澜湖上东Ⅲ区推出2套优惠房源,建面约103.13-118.46㎡

观澜湖上东Ⅲ区 项目推出2套优惠房源,建面约103.13-118.46㎡,优惠后一口价约1855755-2131608元。

2024-08-06
海口

PROPERTY ADVISORS

专业置业顾问

一对一提供楼盘对比、价格和看房服务
王伟
王伟服务达人 · 海口

安徽蚌埠人,毕业西安交通大学,房地产从业10年,主修别墅、商业地产,对于资产配置有自己独特的见解。熟悉海南90

电话咨询
杨滨
杨滨服务达人 · 海口

河北承德人,毕业于河海大学,从事房地产10年,熟悉房地产交易各个环节,过户、贷款、按揭、抵押、公证、特别对项目

电话咨询
在线问顾问专业顾问 · 快速响应 免费电话咨询获取底价与最新优惠
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-20 20:36:35 HTTP/2.0 GET : https://www.doofang.com/loupan/1659
  2. 运行时间 : 0.071522s [ 吞吐率:13.98req/s ] 内存消耗:5,237.41kb 文件加载:150
  3. 缓存信息 : 0 reads,0 writes
  1. /www/wwwroot/www.doofang.com/public/index.php ( 0.79 KB )
  2. /www/wwwroot/www.doofang.com/vendor/autoload.php ( 0.17 KB )
  3. /www/wwwroot/www.doofang.com/vendor/composer/autoload_real.php ( 2.49 KB )
  4. /www/wwwroot/www.doofang.com/vendor/composer/platform_check.php ( 0.90 KB )
  5. /www/wwwroot/www.doofang.com/vendor/composer/ClassLoader.php ( 14.03 KB )
  6. /www/wwwroot/www.doofang.com/vendor/composer/autoload_static.php ( 183.26 KB )
  7. /www/wwwroot/www.doofang.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 0.35 KB )
  8. /www/wwwroot/www.doofang.com/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.81 KB )
  9. /www/wwwroot/www.doofang.com/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  10. /www/wwwroot/www.doofang.com/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.60 KB )
  11. /www/wwwroot/www.doofang.com/vendor/phpunit/phpunit/src/Framework/Assert/Functions.php ( 111.59 KB )
  12. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  13. /www/wwwroot/www.doofang.com/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  14. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  15. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  16. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  17. /www/wwwroot/www.doofang.com/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  18. /www/wwwroot/www.doofang.com/vendor/myclabs/deep-copy/src/DeepCopy/deep_copy.php ( 0.39 KB )
  19. /www/wwwroot/www.doofang.com/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  20. /www/wwwroot/www.doofang.com/vendor/symfony/var-dumper/VarDumper.php ( 4.23 KB )
  21. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  22. /www/wwwroot/www.doofang.com/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  23. /www/wwwroot/www.doofang.com/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  24. /www/wwwroot/www.doofang.com/app/provider.php ( 0.19 KB )
  25. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Http.php ( 6.22 KB )
  26. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  27. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  28. /www/wwwroot/www.doofang.com/app/common.php ( 0.03 KB )
  29. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  30. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  31. /www/wwwroot/www.doofang.com/config/app.php ( 0.95 KB )
  32. /www/wwwroot/www.doofang.com/config/assets.php ( 0.31 KB )
  33. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  34. /www/wwwroot/www.doofang.com/config/auth.php ( 0.58 KB )
  35. /www/wwwroot/www.doofang.com/config/cache.php ( 0.78 KB )
  36. /www/wwwroot/www.doofang.com/config/console.php ( 0.29 KB )
  37. /www/wwwroot/www.doofang.com/config/cookie.php ( 0.56 KB )
  38. /www/wwwroot/www.doofang.com/config/database.php ( 2.83 KB )
  39. /www/wwwroot/www.doofang.com/config/filesystem.php ( 0.61 KB )
  40. /www/wwwroot/www.doofang.com/config/integrations.php ( 0.08 KB )
  41. /www/wwwroot/www.doofang.com/config/lang.php ( 0.91 KB )
  42. /www/wwwroot/www.doofang.com/config/log.php ( 1.35 KB )
  43. /www/wwwroot/www.doofang.com/config/middleware.php ( 0.19 KB )
  44. /www/wwwroot/www.doofang.com/config/route.php ( 1.89 KB )
  45. /www/wwwroot/www.doofang.com/config/session.php ( 0.57 KB )
  46. /www/wwwroot/www.doofang.com/config/trace.php ( 0.34 KB )
  47. /www/wwwroot/www.doofang.com/config/view.php ( 0.82 KB )
  48. /www/wwwroot/www.doofang.com/config/wechat.php ( 0.18 KB )
  49. /www/wwwroot/www.doofang.com/app/event.php ( 0.25 KB )
  50. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  51. /www/wwwroot/www.doofang.com/app/service.php ( 0.13 KB )
  52. /www/wwwroot/www.doofang.com/app/AppService.php ( 0.26 KB )
  53. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  54. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  55. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  56. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  57. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  58. /www/wwwroot/www.doofang.com/vendor/services.php ( 0.18 KB )
  59. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  60. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  61. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  62. /www/wwwroot/www.doofang.com/vendor/topthink/think-migration/src/Service.php ( 1.94 KB )
  63. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  64. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  65. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  66. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  67. /www/wwwroot/www.doofang.com/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  68. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  69. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  70. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  71. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  72. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  73. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  74. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  75. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  76. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  77. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  78. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  79. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  80. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  81. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  82. /www/wwwroot/www.doofang.com/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  83. /www/wwwroot/www.doofang.com/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  84. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  85. /www/wwwroot/www.doofang.com/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  86. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  87. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  88. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  89. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  90. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Console.php ( 22.98 KB )
  91. /www/wwwroot/www.doofang.com/app/Request.php ( 0.09 KB )
  92. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  93. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  94. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  95. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  96. /www/wwwroot/www.doofang.com/app/middleware.php ( 0.06 KB )
  97. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  98. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  99. /www/wwwroot/www.doofang.com/app/middleware/CorsMiddleware.php ( 1.19 KB )
  100. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  101. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  102. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  103. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  104. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  105. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  106. /www/wwwroot/www.doofang.com/route/app.php ( 12.00 KB )
  107. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  108. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  109. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  110. /www/wwwroot/www.doofang.com/app/controller/Home.php ( 39.72 KB )
  111. /www/wwwroot/www.doofang.com/app/BaseController.php ( 2.05 KB )
  112. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  113. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  114. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  115. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  116. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  117. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  118. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  119. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  120. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  121. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  122. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  123. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  124. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  125. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  126. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  127. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  128. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  129. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  130. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  131. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  132. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  133. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  134. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  135. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  136. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  137. /www/wwwroot/www.doofang.com/app/controller/Visitor.php ( 16.68 KB )
  138. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
  139. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  140. /www/wwwroot/www.doofang.com/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  141. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  142. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  143. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  144. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  145. /www/wwwroot/www.doofang.com/runtime/temp/61485e35ac1b46ab3c183a39c6d2527d.php ( 47.67 KB )
  146. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  147. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  148. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
  149. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  150. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000338s ] mysql:host=127.0.0.1;port=3306;dbname=www.doofang.com;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000901s ]
  3. SELECT p.*,r.name region_name,CASE WHEN COALESCE(p.video_url,'')<>'' OR EXISTS (SELECT 1 FROM property_videos pv_badge WHERE pv_badge.property_id=p.id AND pv_badge.status=1 AND COALESCE(pv_badge.video_url,'')<>'') THEN 1 ELSE 0 END has_video,CASE WHEN COALESCE(p.panorama_url,'')<>'' OR EXISTS (SELECT 1 FROM property_panoramas pp_badge WHERE pp_badge.property_id=p.id AND pp_badge.status=1 AND COALESCE(pp_badge.panorama_url,'')<>'') THEN 1 ELSE 0 END has_panorama FROM `properties` `p` LEFT JOIN `regions` `r` ON `r`.`id`=`p`.`region_id` WHERE `p`.`status` = '1' AND ( `p`.`legacy_id` = '1659' OR `p`.`id` = '1659' ) LIMIT 1 [ RunTime:0.000962s ]
  4. SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000577s ]
  5. SELECT * FROM `property_photos` WHERE `property_id` = '1026' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000523s ]
  6. SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000679s ]
  7. SELECT * FROM `property_floor_plans` WHERE `property_id` = '1026' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000450s ]
  8. SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000586s ]
  9. SELECT * FROM `property_panoramas` WHERE `property_id` = '1026' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000386s ]
  10. SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000575s ]
  11. SELECT * FROM `property_reviews` WHERE `property_id` = '1026' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000457s ]
  12. SHOW FULL COLUMNS FROM `property_review_replies` [ RunTime:0.000519s ]
  13. SELECT * FROM `property_review_replies` WHERE `review_id` IN ('1359','1358','1357') AND `status` = 'published' ORDER BY `created_at` ASC,`id` ASC [ RunTime:0.000341s ]
  14. SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000560s ]
  15. SELECT * FROM `property_questions` WHERE `property_id` = '1026' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000409s ]
  16. SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000607s ]
  17. SELECT * FROM `property_promotions` WHERE `property_id` = '1026' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000286s ]
  18. SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000405s ]
  19. SELECT * FROM `property_milestones` WHERE `property_id` = '1026' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000270s ]
  20. SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000389s ]
  21. SELECT * FROM `property_price_histories` WHERE `property_id` = '1026' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000241s ]
  22. SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000416s ]
  23. SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '1026' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000366s ]
  24. SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000387s ]
  25. SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '1026' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000233s ]
  26. SELECT * FROM `property_videos` WHERE `property_id` = '1026' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000249s ]
  27. SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000436s ]
  28. SELECT `a`.`id`,`a`.`legacy_id`,`a`.`property_id`,`a`.`legacy_property_id`,`a`.`region_id`,`a`.`title`,`a`.`summary`,`a`.`cover_image`,`a`.`author`,`a`.`source_name`,`a`.`keywords`,`a`.`view_count`,`a`.`is_recommended`,`a`.`is_pinned`,`a`.`status`,`a`.`published_at`,`a`.`created_at`,`a`.`updated_at`,r.name region_name,p.name property_name,p.cover_image property_cover FROM `property_articles` `a` LEFT JOIN `regions` `r` ON `r`.`id`=`a`.`region_id` LEFT JOIN `properties` `p` ON `p`.`id`=`a`.`property_id` WHERE `a`.`status` = 'published' AND `a`.`property_id` = '1026' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000616s ]
  29. SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000397s ]
  30. SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000219s ]
  31. SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000400s ]
  32. SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000288s ]
  33. SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000380s ]
  34. SELECT COUNT(*) AS think_count FROM `visitor_blacklist` WHERE ( `ip_address` = '216.73.216.164' ) AND ( `expires_at` IS NULL OR `expires_at` > '2026-08-20 20:36:35' ) [ RunTime:0.000228s ]
  35. SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000344s ]
  36. SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000219s ]
  37. SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000358s ]
  38. SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000198s ]
  39. SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000367s ]
  40. SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000365s ]
  41. SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000225s ]
  42. SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000359s ]
  43. SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000249s ]
0.072106s