import frappe

@frappe.whitelist()
def check_property_types(property_type = None): 
    return frappe.db.sql(f""" SELECT name, property_type FROM `tabProperty` where property_type = '{property_type}' """, as_dict=True)
import frappe

@frappe.whitelist()
def check_property_types(property_type = None): 
    return frappe.db.sql(f""" SELECT name, property_type FROM `tabProperty` where property_type = '{property_type}' """, as_dict=True)
SELECT name, property_type FROM `tabProperty` where property_type = '{property_type}'