@RestResource(urlMapping='/property/*')
global with sharing class PropertyApi {
   
    @RestResource(urlMapping='/property/property')
    @HttpGet
    
    global static List<CustomListing> getProperties() {
       
        List<pba__Listing__c> properties=[SELECT Id,Name,ListingId__c,pba__Property__c,Common_Charges__c,pba__Address_pb__c,pba__City_pb__c,
                                          pba__State_pb__c,pba__PostalCode_pb__c,pba__Country_pb__c,Street_Intersection__c,Display_Address__c,
                                          pba__Status__c,Listing_Status__c,pba__ListingType__c,pba__ListingPrice_pb__c,pba__Listing_Website__c,
                                          Listed_Date__c,Listing_Email__c,Move_in_Date__c,HasGarden__c,HasBalcony__c,HasTerrace__c,
                                          HasPrivateRoofDeck__c,HasPrivateCourtyard__c,HasRoofGarden__c,Building_Type__c,Block__c,                                                                  
                                          Fee_Type__c,pba__Description_pb__c,pba__Bedrooms_pb__c,pba__FullBathrooms_pb__c,Rooms__c,pba__LotSize_pb__c,    
                                          pba__PropertyType__c,Building_Description__c,Condition__c,                                                                                                               
                                          pba__Listing_Agent_Firstname__c,pba__Listing_Agent_Lastname__c,pba__Listing_Agent_Email__c,                                              
                                          pba__Listing_Agent_Photo__c,pba__Listing_Agent_Mobil_Phone__c,pba__Listing_Agent_Phone__c,Listing_Agent_Brokerage_Name__c,                                              
                                          pba__Listing_Agent_Street__c,pba__Listing_Agent_City__c,pba__Listing_Agent_Zip__c,Neighborhood__c,Neighborhood_Description__c,
                                          Appliances__c,Cooling_Systems__c,Exterior_Types__c,of_Floors__c,NewConstruction__c,Listing_Secondary_Agent_Firstname__c,                                          
                                          Listing_Secondary_Agent_Lastname__c,Listing_Secondary_Agent_Email__c,Listing_Secondary_Agent_Photo__c,                                          
                                          Listing_Secondary_Agent_Mobil_Phone__c,Listing_Secondary_Agent_Phone__c,Listing_Secondary_Agent_Brokerage_Name__c,
                                          Listing_Secondary_Agent_Street__c,Listing_Secondary_Agent_City__c,Listing_Secondary_Agent_Zip__c,                                          
                                          Floorplan_URL__c,pba__Listing_Agent_Website__c,Sale_Price__c,Sale_Date__c from pba__Listing__c ];
       
        List<CustomListing> objlistCustomListing=new List<CustomListing>();
      
        for(pba__Listing__c Listing:properties){            
        	//CustomListing objCustomListing=new CustomListing();
       		
        List<pba__PropertyMedia__c> objPropertyMedia=new List<pba__PropertyMedia__c>();
         objPropertyMedia=[select Id,pba__Property__c,pba__URL__c from pba__PropertyMedia__c where pba__Property__c=:Listing.pba__Property__c];
        objlistCustomListing.add(new CustomListing(Listing,objPropertyMedia));
            //objCustomListing.objPropertyMedia=objPropertyMedia;
        //objlistCustomListing.add(objCustomListing);
        }       
        return objlistCustomListing;
}

global class CustomListing  
	{
    	pba__Listing__c objListing{get;set;}
    	List<pba__PropertyMedia__c> objPropertyMedia{get;set;}
        CustomListing(pba__Listing__c listing,List<pba__PropertyMedia__c> media){
            objListing = listing;
            objPropertyMedia = media;
        }
	}
}