I'd do this instead:
create table [cpqaAnswers].[cpqa].[tblPZResidential]
(
--id varchar(max) primary key not null 'R00' + identity(1,1),
id [int]identity(1,1) primary key NOT NULL,
idx varchar(max),
categoryid varchar(10),
title varchar(max),
images varchar(max),
pdiscription varchar(max),
contact_no bigint,
city varchar(30),
location varchar(30),
property_type varchar(50),
rate_persquarefit float,
Layout_Plan varchar(max),
Floor_Plan varchar(max),
Unit_Plan varchar(max),
)
Then when it comes time to populate the table with data you perform a VALUES or INSERT of that 'R00' prefixing as "'R00' + CAST([id] As varchar)" in the appropriate place in the SELECT