Home » Coldwell Banker Costa Rica Property Search

Coldwell Banker Costa Rica Property Search

      • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 2' at line 34 query: SELECT count(*) FROM dc6_node n LEFT JOIN dc6_node_revisions r ON r.vid = n.vid LEFT JOIN dc6_cw_property p ON p.vid = n.vid LEFT JOIN dc6_cw_cbinfo c ON c.nid = n.nid LEFT JOIN dc6_node nb ON nb.nid = p.bath_nid LEFT JOIN dc6_cw_bath b ON b.nid = nb.vid LEFT JOIN dc6_term_node tl ON tl.vid = n.vid AND tl.tid IN (377, 345, 359, 319, 390, 343, 402, 387, 339, 395, 374, 139, 325, 142, 411, 330, 191, 356, 417, 376, 124, 375, 320, 382, 432, 430, 364, 361, 137, 351, 336, 350, 391, 118, 335, 355, 408, 331, 160, 341, 360, 185, 418, 167, 369, 323, 406, 324, 140, 317, 419, 381, 194, 280, 386, 193, 380, 155, 416, 353, 165, 371, 322, 367, 405, 282, 414, 428, 370, 348, 357, 340, 347, 379, 413, 396, 372, 389, 399, 358, 397, 407, 434, 383, 362, 426, 352, 190, 195, 189, 285, 435, 196, 188, 192, 120, 123, 133, 398, 363, 412, 354, 162, 321, 337, 415, 427, 429, 436, 400, 153, 329, 187, 334, 318, 171, 393, 409, 149, 424, 332, 431, 138, 423, 420, 422, 421, 328, 157, 392, 136, 342, 327, 122, 373, 438, 433, 147, 326, 333, 410, 366, 368, 186, 284, 338, 437, 346, 378, 388, 349, 403, 439, 404, 344, 425) LEFT JOIN dc6_term_node ty ON ty.vid = n.vid AND ty.tid IN (1, 208, 2, 5, 209, 6, 8, 65) /* no terms (beaches etc..) features join */ /* no terms (beaches etc..) additions join */ LEFT JOIN dc6_term_data d ON d.tid = tl.tid WHERE n.type = 'cw_property' AND n.status = 1 AND ( p.bidtype = 'both' OR p.bidtype = 'sale' ) /* no price range restrictions */ AND b.total >= notag AND p.beds >= beach-living AND ( tl.tid = price-asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 65, 197, 198, 199, 200, 201, 202, 203, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 248, 249, 257, 258, 259, 260, 261, 262, 263, 264, 265, 273, 274, 275, 278, 288, 289, 290, 291, 292, 316, 317, 318, 319, 320, 321, 322, 323) OR tl.tid IN (155, 160, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 386, 387, 388, 389, 390, 391, 392, 393, 395, 396, 397, 398, 399, 400, 402, 403, 404, 405, 406, 418) ) AND ty.tid = no-code /* no tags (hot or new) restrictions */ /* no terms (beaches etc..) restrictions */ /* no super search restrictions */ in /usr/www/users/reacrsa/sites/mls/sites/all/modules/coldwell_cw_search/coldwell_cw_search_form.inc on line 182.
      • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 2' at line 34 query: SELECT count(*) FROM dc6_node n LEFT JOIN dc6_node_revisions r ON r.vid = n.vid LEFT JOIN dc6_cw_property p ON p.vid = n.vid LEFT JOIN dc6_cw_cbinfo c ON c.nid = n.nid LEFT JOIN dc6_node nb ON nb.nid = p.bath_nid LEFT JOIN dc6_cw_bath b ON b.nid = nb.vid LEFT JOIN dc6_term_node tl ON tl.vid = n.vid AND tl.tid IN (377, 345, 359, 319, 390, 343, 402, 387, 339, 395, 374, 139, 325, 142, 411, 330, 191, 356, 417, 376, 124, 375, 320, 382, 432, 430, 364, 361, 137, 351, 336, 350, 391, 118, 335, 355, 408, 331, 160, 341, 360, 185, 418, 167, 369, 323, 406, 324, 140, 317, 419, 381, 194, 280, 386, 193, 380, 155, 416, 353, 165, 371, 322, 367, 405, 282, 414, 428, 370, 348, 357, 340, 347, 379, 413, 396, 372, 389, 399, 358, 397, 407, 434, 383, 362, 426, 352, 190, 195, 189, 285, 435, 196, 188, 192, 120, 123, 133, 398, 363, 412, 354, 162, 321, 337, 415, 427, 429, 436, 400, 153, 329, 187, 334, 318, 171, 393, 409, 149, 424, 332, 431, 138, 423, 420, 422, 421, 328, 157, 392, 136, 342, 327, 122, 373, 438, 433, 147, 326, 333, 410, 366, 368, 186, 284, 338, 437, 346, 378, 388, 349, 403, 439, 404, 344, 425) LEFT JOIN dc6_term_node ty ON ty.vid = n.vid AND ty.tid IN (1, 208, 2, 5, 209, 6, 8, 65) /* no terms (beaches etc..) features join */ /* no terms (beaches etc..) additions join */ LEFT JOIN dc6_term_data d ON d.tid = tl.tid WHERE n.type = 'cw_property' AND n.status = 1 AND ( p.bidtype = 'both' OR p.bidtype = 'sale' ) /* no price range restrictions */ AND b.total >= notag AND p.beds >= beach-living AND ( tl.tid = price-asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 65, 197, 198, 199, 200, 201, 202, 203, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 248, 249, 257, 258, 259, 260, 261, 262, 263, 264, 265, 273, 274, 275, 278, 288, 289, 290, 291, 292, 316, 317, 318, 319, 320, 321, 322, 323) OR tl.tid IN (155, 160, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 386, 387, 388, 389, 390, 391, 392, 393, 395, 396, 397, 398, 399, 400, 402, 403, 404, 405, 406, 418) ) AND ty.tid = no-code /* no tags (hot or new) restrictions */ /* no terms (beaches etc..) restrictions */ /* no super search restrictions */ in /usr/www/users/reacrsa/sites/mls/sites/all/modules/coldwell_cw_search/coldwell_cw_search_form.inc on line 202.
      • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 2' at line 48 query: SELECT n.nid , p.prop_id , p.price , p.beds , b.total /* Bath total count */ , la.value /* Living area count */ , la.unit , lz.value /* Lot Size area count */ , lz.unit , d.name AS location FROM dc6_node n LEFT JOIN dc6_node_revisions r ON r.vid = n.vid LEFT JOIN dc6_cw_property p ON p.vid = n.vid LEFT JOIN dc6_cw_cbinfo c ON c.nid = n.nid LEFT JOIN dc6_node nb ON nb.nid = p.bath_nid LEFT JOIN dc6_cw_bath b ON b.vid = nb.vid LEFT JOIN dc6_node nla ON nla.nid = p.living_area_nid LEFT JOIN dc6_cw_area la ON la.vid = nla.vid LEFT JOIN dc6_node nlz ON nlz.nid = p.lotsize_nid LEFT JOIN dc6_cw_area lz ON lz.vid = nlz.vid LEFT JOIN dc6_term_node tl ON tl.vid = n.vid AND tl.tid IN (377, 345, 359, 319, 390, 343, 402, 387, 339, 395, 374, 139, 325, 142, 411, 330, 191, 356, 417, 376, 124, 375, 320, 382, 432, 430, 364, 361, 137, 351, 336, 350, 391, 118, 335, 355, 408, 331, 160, 341, 360, 185, 418, 167, 369, 323, 406, 324, 140, 317, 419, 381, 194, 280, 386, 193, 380, 155, 416, 353, 165, 371, 322, 367, 405, 282, 414, 428, 370, 348, 357, 340, 347, 379, 413, 396, 372, 389, 399, 358, 397, 407, 434, 383, 362, 426, 352, 190, 195, 189, 285, 435, 196, 188, 192, 120, 123, 133, 398, 363, 412, 354, 162, 321, 337, 415, 427, 429, 436, 400, 153, 329, 187, 334, 318, 171, 393, 409, 149, 424, 332, 431, 138, 423, 420, 422, 421, 328, 157, 392, 136, 342, 327, 122, 373, 438, 433, 147, 326, 333, 410, 366, 368, 186, 284, 338, 437, 346, 378, 388, 349, 403, 439, 404, 344, 425) LEFT JOIN dc6_term_node ty ON ty.vid = n.vid AND ty.tid IN (1, 208, 2, 5, 209, 6, 8, 65) /* no terms (beaches etc..) features join */ /* no terms (beaches etc..) additions join */ LEFT JOIN dc6_term_data d ON d.tid = tl.tid WHERE n.type = 'cw_property' AND n.status = 1 AND ( p.bidtype = 'both' OR p.bidtype = 'sale' ) /* no price range restrictions */ AND b.total >= notag AND p.beds >= beach-living AND ( tl.tid = price-asc OR tl.tid IN (1, 2, 5, 6, 8, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 65, 197, 198, 199, 200, 201, 202, 203, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 248, 249, 257, 258, 259, 260, 261, 262, 263, 264, 265, 273, 274, 275, 278, 288, 289, 290, 291, 292, 316, 317, 318, 319, 320, 321, 322, 323) OR tl.tid IN (155, 160, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 386, 387, 388, 389, 390, 391, 392, 393, 395, 396, 397, 398, 399, 400, 402, 403, 404, 405, 406, 418) ) AND ty.tid = no-code /* no tags (hot or new) restrictions */ /* no terms (beaches etc..) restrictions */ /* no super search restrictions */ LIMIT 0, 5 in /usr/www/users/reacrsa/sites/mls/sites/all/modules/coldwell_cw_search/coldwell_cw_search_form.inc on line 202.
      Sort by:PriceBedsBathsBuilding SizeLots/Acreage Size
      No Properties found.