If you want to create an override for your homepage, just create a file called home.tpl in your design/override/templates/full, put your code in. Then create an override of your override.ini (siteaccess/yoursiteaccessname/override.ini.append.php) and add in the first position this override block:
I tried copying this example since it worked for the front page by simply changing the node it points to and renaming the title on it for another page, and it didnt work. Should the code you gave me work on any other page I may want to override via node # ?
yes, it should work. Just make sure the name of the override block is not repeated, also check that your override template is stored in the right place and points to the correct view that is being loaded.
Just try not to abuse much of the node matching and see if you can make a class match better. Also try to put this override on the top of the file, if you put the new block at bottom it's possible that there is any other previous override block that is being applied and yours ignored.