Which fence wood and paint/stain is this?
"Is it paint or stain?"- neither, that fence is made of plastic. It is manufactured that color.

"Can cedar be prepared to look like it?" - the grain uniformity and absence of knots and defects is unrealistic, natural cedar will have natural imperfections. If you choose your lumber carefully you can select pieces that look nicest to you. A high quality semi-transparent exterior stain will give you some sheen with a bit of tint, along with a lot of sanding to make it smooth, is probably the closest you will get to the unnatural look of PVC fencing.