I'd think that it would be done with stucco or concrete.

I will give this a bump for you ! Hopefully someone in the supply industry will see it !! :-)

Thanks a lot for your valuable suggestions and comments Rusty Empire,decoenthusiaste,emmarene & Chikka BangBang. My home is located in a small village in India. We initially planned to renovate our old home. But during the middle of renovation work, we changed our mindset to build a new one. Hence we made a house design by ourselves(3BHK) with the help of our local builder and to save the cost we tried to reuse all possible materials that were extracted while demolishing our old home((i.e.., like red tiles placed on the top of left side of porch). The project is in last phase, now I feel that still we could do something to enhance the beauty of exterior of home by getting some ideas from experts. I like to thank everyone once again for sharing your thoughts! @Rusty Empire : The entire building shown in pic is a single building, because of our inexperienced design it looks like disjointed:(:(. We just finished the painting of primer coating, yet to paint the final color. The pic you posted with color looks awesome, planning to paint the same color. I believe it would change the entire view of building @decoenthusiaste : The entire building shown in pic is a single building. Will post more pics in coming days, pls review it and share your thoughts. @emmarene : Right now I'm at my work place, so I don't have a main entrance pic with me. Will post it by this weekend. Please review it and share your valuable thoughts. @Chikka BangBang: That's gr8 idea, will think abt it. Thanks!

It would be better if you can consult Admixtures company like ., Myk laticrete, Bostik ., etc It's a kind of plaster STUCCO...