if there is an intention to flip, then you need to plan out your timeline. landed houses prices will usually go up in the long run. back in late 2000s, an inter-terrace can be bought for 700k+. When the property prices spikes through to 2014, inter-terrace prices were averaging for around 2M. Even though prices came down by about 10% (experts were harping 20% drops) after 2014 till 1st quarter 2017, the prices are still way higher than late 2000s. Today, an inter-terrace starting price is from 2.5M up. My reference is around where I'm currently staying and all based on old inter-terrace houses which are at least 30-40 years old. Also remember that if you sell high, you will also need to buy high if you plan to buy another landed house after you sell your current one. Of cos there's always the option of downgrading to a condo in future if your kids decide not to stay with you and your spouse after they get married.
at this point, tender prices are about 30 percent higher than back in 2019. you can see the cost of raw materials (BCA data) from the table below.
if you are planning to have a house with 2000sqf foot print, potentially you can have about 5000+sqf built up for a 2.5 storey house. assuming 5000sqf at $400 per sqf, you are looking at a construction cost of about $2M.
don't worry too much about what you neighbour might do in future as that is beyond your control. design and build your house to your own personal requirements and preferences. nowadays developers usually max out the entire site to build huge houses and if yours has lots of greenery, it can become a unique selling point also. Do note that if you are intending to convert to a detached house, you are also bound by a site coverage ratio of 50% (40% if within GCB areas). So if you detached your house from your neighbour, your neighbour if he choose to rebuilt will also need to redevelop into a detached house and thus will be bound by this site coverage ratio. As such, you are unlikely to have the huge house and mickey mouse house issue.
I think what Pete is trying to say is that if you are planning to flip in the near future, don't spend too much on doing renovations (A&A) as it doesn't add much value to the existing house. rebuilt is another thing on its own