search

Battler45 / SierraMigrationToGitHub

Migration from unfuddle to GitHub
0 stars 0 forks source link

Update Horizon template (KYSelectProperties.com) to new Pro Site for Remax-Mammoth.com #230

Closed Battler45 closed 4 years ago

Battler45 commented 4 years ago

Vihang,

For our next Pro Site, we will be converting an existing design (http://www.kyselectproperties.com) to a new Pro Site for http://www.remax-mammoth.com.

I've set up a new website here:

Which is accessible via FTP at:

67.199.110.220 remax-mammoth_dev

using the normal password. Once you FTP into the site, you'll see that I have already copied over the site files from the KYSelectProperties.com version of the site. If you go to the default page for this site:

You'll see that there are still some formatting issues in the HTML / CSS of this and the other site pages. Arthur (new programmer) has FTP access to this site and is curently working on fixing those (should be done by tomorrow or Friday).

In the meantime, can you get started updating the constants_client.asp and constants_client_specific.asp files for this site, and then also create the default pages (Home, Contact, About RE/MAX of Mammoth, Meet Our Team, About Mammoth, Careers, Privacy Policy) and a blog with default blog post?

We don't need a "Community Info" page for this site.

For the neighborhood / community pages, the site will have the following sections:

  • Mammoth Lakes Subdivisions (/mammoth-homes/)
  • Mammoth Lakes Condos (/mammoth-condos/)
  • Mammoth Lakes Project Areas (/mammoth-lakes-real-estate/)
  • Mono County Communities (/)
  • Inyo County Communities (/)

Then, for the Condos and Subdivisions sections, the client has prepared a content template for each type (attached). In this document, there are two templates -- one for the Subdivisions pages, and one for the Condos pages. Upon reviewing this document, I believe you'll be able to make sense of what the client is looking for, and it requires a bit more flexibility than our current tools allow for. Do you think there would be a way to automate this type of content creation? If so, it would be good to somehow build that added flexibility into our system for future use in situations such as this.

In creating the condos and subdivisions pages, please use the attached spreadsheet (also prepared by client) as a point of reference. The subdivisions will be those listed in the "Mammoth Lakes Subdivisions" column, and the condos will be those listed in the "Mammoth Condo Complexes" column. I believe the Saved Searches for all of these should already be created. Any Saved Searches which are not already created can be dis-regarded for the time being, because I don't believe there are active MLS listings for those areas at the moment.

Last, one issue for this site is that this site is an upgrade for an existing customer who is currently using IDX Search Tools only. The URL of their search tools is: http://mammothmls.sierrainteractivemls.com/

One problem we may encounter in developing this site is that the Site Domain for the existing site is different from what it will be for the new site. I'm not sure what the best way would be to get around this, other than to hard code a temporary change into the /res/includes/session_mgr.asp file that would recognize the remax-mammoth.sierrainteractivedev.com domain and automatically change it to mammothmls.sierrainteractivemls.com before passing it into the Session functions. (Basically, a hack to get it to work until the site goes live.)

Please let me know if you have any questions.

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have added community sections and content pages per your suggestions. I have also updated the constants_client.asp and constants_client_specific.asp files for this site.

I am now working on creating community pages for the saved-searches and looking into further automating this process. I will update you more on this tomorrow.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

I've made a few changes to this site today, mainly to replace instance of previous client (Kentucky Select Properties) with new client name (RE/MAX of Mammoth), and also to correct some display issues on the home page. I've committed and pushed all related changes to Unfuddle, and I've also FTP'd those changes up to the server.

Getting this site up and running is currently our priority, and so would take precedence at this point over the task of automating the copying of template pages into existing sites. Main priorities would be:

1 - Getting scrollers working properly on the home page. For the main scroller, the saved search would include both Short Sales and Foreclosures (which I believe is an option on the search form for Region 1). One thing I'm seeing currently on the home page is that the auto-rotating scrollers are disappearing and reappearing at certain intervals. This may be related to the fact that the main scroller is not displaying on the site (the scrollers do display correctly in all browsers on the KY Select Properties site).

2 - Getting the links for the main navigation menu corrected and updated

3 - Updating home page and interior page quick searches

4 - Creating community pages from saved searches

The main "Mammoth Communities" page will be similar to the "Orange County Communities" page on the WeirProperties.com site (http://www.weirproperties.com/orange-county-real-estate/) in that it will be a standard content page with content label widgets, rather than using the communities_full.asp page.

5 - Updating the Contact page with contact info / content for the client and adding the correct CSS styles for the display of that form

Thanks for your help with this. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have spent some time looking into further automating the community pages creation process. I believe most of the times we would be creating community pages for the saved-searches created on the geographic locations like Condo Projects, Subdivision, City and Area. We can add an option to select geographic type on the Community Pages Wizard. When the geographic type is changed (by default Area would be selected), the template for that geographic type (stored in the database or in a file) would be loaded in the text-editor.

For example when the Condo Project is selected the following content would be loaded in the text-editor:

"Included below are condos for sale at ##SAVED_SEARCH_NAME## Condos. The ##SAVED_SEARCH_NAME## condominium complex is located in the ##SUBDIVISION## area in ##AREA##, ##STATE##. These property listings are updated daily from the ##MLS_BOARD_FULL_NAME## MLS.

If you would like more information on any of these ##SAVED_SEARCH_NAME## Condos for sale in ##AREA##, just click the "Request More Information" button when viewing the details of that property. We can provide you with current market data, disclosures, past sales history, dates and prices of condos recently sold in the ##SUBDIVISION## area, and more.

And, if you haven't already, be sure to register for a free account so that you can receive email alerts whenever new ##SAVED_SEARCH_NAME## Condos and other ##CITY## Real Estate for sale come on the market."

The location specific config variables (like ##SUBDIVISION##, ##AREA##, ##SUBAREA## and ##COUNTY##) would map with the corresponding fields of the MLS tables. For example when creating community page for the "1849 I" condo, the ##SUBDIVISION## and ##AREA## would be replaced with "Canyon Lodge" and "Mammoth Lakes" respectively. The only point to consider would be that the name of the saved-search would have to match the corresponding location name in the MLS tables. For example, if the saved-search name is "1849 I" the programming will check for an MLS record with the same condo name. On the other hand if the saved-search name is "1849 I Condos" it will not match any records.

Please let me know your thoughts on this.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have made changes in the site per comment-3. I have also updated footer links and added/updated styles for the SIST and blog pages.

I have created community pages for about 50 condos saved-searches. I will add community pages for other condo and subdivision saved-searches tomorrow.

Could you please let me know if I should create community pages for the Mammoth Lakes Project Areas, Mono County Communities and Inyo County Communities sections?

Also, I believe on the community page of this site we would display Featured Searches for the Mammoth Lakes, Crowley Lake, June Lake, North Mono County and South Mono County as we are doing in the MammothRealty.com?

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Yes, I think that's a good suggestion and will work. You are correct that most of the time we will be building community pages for saved searches created on the geographic locations like Condo Projects, Subdivision, City and Area. One thing that I think would help would be that, rather than storing the content template based solely on geographic type, we would have the ability to create multiple content templates, save them by name, load them, edit them and re-save them.

So, for example, on the Community Pages Wizard, there would be an option to load in content from a previously created template, which would populate in the way you've described. Section 1 on the form would become, "Content Template". Within that fieldset would be a drop-down select box labeled "Load Content from Template" and showing all currently available content templates. When an existing content template is selected, the remaining form elements on the page would be pre-populated with content as expected.

In cases where the user does load in content from a pre-existing template, in the Page Overview box on the left there would be a blue "Save New Template" button and another blue "Update Existing Template" button above the green "Create Pages" button.

In cases where the user does not load in content from a pre-existing template, in the Page Oveview box on the left there would only be one blue button, "Save New Template."

When the "Save New Template" button is clicked, an overlay would appear prompting the user to give the template a name, with Save and Cancel buttons. (It would also validate that another template of the same name does not already exist.)

To address your point about the need to associate the ##SAVED_SEARCH_NAME## variable with a particular field in the MLS table, to the right of the "Load Content From Template" select box, there would be another select box, this one labeled, "Associate ##SAVED_SEARCH_NAME## with:" and the select box would contain the options: Area, City, Condo Project, County, Schools, Subarea, Subdivision, Township. This would allow the user to associate the saved search name with any geographic field from the MLS table that they wanted. (And this variable would also be saved along with the rest of the template info for future use.)

I do see your point about the ##SAVED_SEARCH_NAME## variable needing to exactly match the corresponding field value in the MLS table, and I think that's fine, as we will be doing most of this type of thing before the client has any access to the site, and so we should be able to make this work in all cases.

Please let me know if you have any questions.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I forgot to mention this yesterday but I have updated the property-search/res/includes/session_mgr.asp to change the domain name to "mammothmls.sierrainteractivemls.com" when request is made from "remax-mammoth.com" (line 27).

Also, I noticed that in the Featured Listings saved-search the Office MLS ID is set to 102. Whereas on the Site Contact Information page it is same as Agent MLS ID (36). Please let me know if I should update the Office MLS ID to 102 in the Contact Information page and the constants_client.asp file.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Great, thank you. I heard back from Arthur this morning that he was able to finish customizing the site HTML / CSS to the updated RE/MAX Mammoth design. I will work today on some further necessary changes to the site, and will update you on my progress by the end of my day today.

Thanks for your help with this. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Excellent work, thank you. When you have time, can you please make a few more changes to the site?

1 - Convert the property listing detail page to the new detail page

2 - Add two new Scrollers to the home page, below the current "Foreclosures & Short Sales" scroller. The first should be called Mammoth Luxury Homes, and the second should be called Mammoth Crash Pads. The client has not given us criteria for these yet, so if you could please just create a new saved search for each one, using the names above, and the criteria "Residential - Mammoth Lakes", that would be great.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Okay, it should not be a problem. If I remember correctly in looking at these pages, the meta tags that the client created seemed to conform to a similar pattern across all pages. Perhaps you could look at some of the pages you had not yet completed to get a sense of this pattern, and then use that to help you restore the previous content?

Also, at the outset, the client did provide the attached spreadsheet with URL structure and meta tags (primary keywords, secondary keywords) and so this may be helpful as well.

Please let me know if you run into any issues.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Great, thanks for fixing this. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have fixed the quick search issue reported in #56. The issue was due to the default Area option value was set to "0" as a result no matching listings were found when list-type or any other criteria was selected first.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

The changes look good, thank you. Can you just make one small adjustment to the new property listing detail page for this site? Currently, there is quite a bit more padding on the left side of the page than the right side (between the contents of the page and the border of the page). Can you try to even that out, so that it's equal on both sides?

Also, for this site, can you create a new section on this site called "Mammoth Sales Data" with the section filename "/mammoth-sales-data/" ? Within that, then please create three new pages:

And can you then import the content for these pages from the existing site, here:

The formatting is not great on the existing pages, so please just do the best you can in importing them. The Page Titles of the pages should just be "Homes," "Condos," and "Lots"

The H1 tag of each page should be "Mammoth Homes Sales Data 2000-2011," "Mammoth Lots Sales Data 2000-2011," etc. Then, below the H1 tag and the data, please add a Content Label Widget containing links to all three of these pages, so that people can easily navigate between them.

Once that's done, if you could add a "Mammoth Sales Data" menu item as the bottom item in the drop-down menu under "Mammoth Communities," and linking to the "Homes" page, that would be great.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Thanks for your updates. The site is looking good. I have made a number of additional updates to the site today, and have created some additional pages.

For today, we actually have another site that we need to turn our attention to -- IndysBestHomes.com -- and we can come back to the Remax-Mammoth.com site on Monday. I have committed and pushed all my changes for the Remax-Mammoth.com site -- can you please be sure to fetch the latest changes?

Thanks -- I am going to add the IndysBestHomes.com ticket now. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Great, thank you. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Also, not sure how difficult this would be, but would it be possible to add a dynamic listing count to the home page quick search box, aligned to the right edge of the box in the same line with the Search Now button? Similar in style to what we have on MLSHomesKY.com or MLSKY.net (but matching colors, and fonts sized appropriately to make it fit comfortably in the box).

This would be for the home page only, and not for the interior pages.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have made changes in the per comment-18 and 19. Please check the same and let me know your feedback.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have updated the site-map page to display Featured Searches by content labels. I have also applied the "Mammoth Lakes Featured Searches" label to saved-searched on the "What Are You Looking For?" box. So, these saved (like Luxury Homes, Mammoth Crash Pads etc) would be displayed under the "Mammoth Featured Searches" label on the site-map and community pages.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Great, thank you. I believe this site is now complete and ready to launch.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have made changes per comment #45. Please check the same.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

The site is looking great, thank you.

As final steps for this site, can you please add:

As with the MammothRealty.com site map, please make the /site-map/ page on this site include all available pages on the site. I don't see a good place to link these sitemaps in the footer, so, for now, please leave them un-linked, and I will look into this tomorrow.

Also, in checking the PanamaCityHomesOnline.com site, I noticed that the /site-map/ page does not seem to be available there (broken link). When I click on the Site Map link (http://www.panamacityhomesonline.com/site-map/) the site seems to hang, and the page takes a very long time to load. Can you look into that when you have a chance?

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Launched live site on DEDN173 Inetpub-LIVE (via Cloudflare) Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have added the site-map, site-map XML and Property Listings site-map pages in the Remax-mammoth.com site. Please check the same.

Regarding the PanamaCityHomesOnline.com site-map page, the rewrite rules for the site-map and site-map XML were commented so these two pages were not available. I have fixed the same.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

We have only a small remaining changes for Remax-Mammoth.com:

Can you please make this change when you have a moment?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang

RE: #44

1 - Yes, please do hard-code the links in the Home community box. Also, please change the label from "Ski-In / Ski-Out Condos and Homes" to just "Ski-In / Ski-Out"

2 - Yes, that looks good

3 - These also look good

4 - Good question. I do think we need to add a new section, "/mammoth-lakes-commercial-real-estate/" and then place both of the pages you mentioned within that section.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

The client on this site is, unfortunately, being very demanding, and has requested some additional changes to the content & saved searches on this site.

Is there a way for you to programmatically make the following changes:

1 - In the Saved Search names (and, so, also in the names of the corresponding Content Pages, and in the Title, Description, Keywords and Content of those pages), some of the names are abbreviated, due to their having been included that way in the IDX data.

For example, the Saved Search "Mmth Vista I" actually represents "Mammoth Vista I", and "Mmth VIew Vlls" actually represents "Mammoth View Villas".

Is there a way for you to iterate through the names of the Saved Searches and make the following replacements?

Then, the same updates would need to be made in all fields of the content pages, as well.

Also, the client has requested that the Roman numerals be replaced with normal numbers in all Saved Searches and content pages, meaning:

The only exception to this last request (Roman numerals) is the Snowcreek pages -- these should remain Snowcreek I, Snowcreek II, etc., and so should the corresponding Saved Searches.

If it's not possible to get this done in an automated way, please let me know, and I will find another way to go about it.

If it is possible, can you save the programming you create to do this, as I am sure we will have further use for it in the future?

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

RE #41:

1-- I have added pages highlighted in the yellow and verified that other pages are added or their URL is optimized.

2-- I have added new pages for the Featured Listings, Newest Listings and Foreclosures and Short Sales scrollers. The "Mammoth Luxury Homes" and "Mammoth Crash Pads" scrollers would point to the same "Luxury Homes" and "Mammoth Crash Pads" pages as in the "What Are You Looking For?" box.

3-- I have verified that all pages marked DELETE have been deleted.

4-- I have double checked that pages have been created for all the condos and most of the subdivisions listed in the spreadsheet. We have created saved-searches for the following subdivisions, but the corresponding community pages haven't been added as we don't have details of the related Project Areas.

Also, please note that the saved-search for the "Mammoth Lakes Other" subdivision is not added as I could not find appropriate criteria for the same.

5-- I have also verified that the abbreviated words and roman numerals have been replaced per our earlier discussion. And the saved-searches and community pages of the condo projects/subdivisions listed in the comment-26 have been merged into single saved-search and community page.

Also, please note that,

1-- I have updated the "Meet Our Team" page file-name to "meet-the-team" as suggested in the "URL_Structure_For_SEO_Remax-Mammoth_REV_2012-02-18.xls" file. However, I haven't update the page name as the corresponding Link in the main site navigation is also named "Meet Our Team"

2-- We haven't yet added content into the "About", "Meet Our Team" and "About Mammoth" pages.

3-- I have removed the "Mammoth Lakes CA Real Estate News" title on the default blog page as the original blog title/category name was pushed down to the gray content area.

4-- I have also verified/updated main navigation links, footer navigation links and links on the Market Statistic page.

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

The Remax-Mammoth.com client has also requested that we create some 301 redirects for him. I've attached a spreadsheet which contains a full list of the redirects from the old site URLs to the new site URLs. A few points on this:

1 - Since all of the old site URLs end in .html, it will be easy to identify them, and so I think we should use an external text file to the .htaccess file in the same way that we are doing on HomeToIndy.com for the .php files. According to ISAPI Rewrite, using an external text file in this way is much faster.

2 - In the spreadsheet, there are a few URLs highlighted in green, which indicate new pages still to be created (and a few of which, such as the sales data pages, have already been created). We don't need to worry about creating these new pages just yet but, in certain places, the URLs the client has specified for these new pages are not correct.

For example, he has specified a URL of "http://remax-mammoth.com/property-search/list/new-real-estate-listings/" for the New Listings page (which he would like to have created instead of linking to a Saved Search). In all cases, he has included "/property-search/list/" in the URL, and I believe we just need to strip that out. So, the correct URL of the page would be, "http://remax-mammoth.com/new-real-estate-listings/"

Please let me know if you have any questions.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have added the content pages and links for Terms of Use, Disclaimer and Privacy Policy per comment-35.

I have also updated the Home page community box per comment-36. Please note the following points:

1-- The saved-searches and community pages for few of the new pages had already been created. However, the criteria and page names were different than suggested in PDF file. So, I have created new saved-searches and community pages (in the Communities section).

2-- I have created individual saved-searches for the Mammoth Luxury Homes and Mammoth Luxury Condos as we need to set different price criteria for condo and home. I have included both these saved-searches in the Luxury Homes community page. Similarly, the Mammoth Crashpads page has two saved-searches included, one for condos and another for residential properties. Also, please note that I have set the min/max price of these saved-searches in the database as suggested in the PDF. So, when these saved-searches would be updated via CAA the min/max price would be replaced by nearest price option.

3-- I have added separate saved-searches for the Recent Price Reductions and Price Reductions but both these saved searches have same criteria except the sort order. I am not sure if the search-tools allows to find properties for which price has changed in X days.

4-- For the Longest on Market saved-search I have set the DaysOnMarket to 350 in database. However this returns properties that are on market for 350 or less days. Again I am not sure if search-tools allows to find properties that are on market for more than X days.

5-- There are total 17 pages listed in the PDF to show in the home page community box so, I have included the "Single Family Homes" page to show in this box.

Please check these saved-searches and community pages and let me know your feedback.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Nice job, thanks for doing this.

Regarding your query, actually, we need to combine all of the different searches such as the one you mentioned into a single search, and then also combine the separate pages into a single page.

So, for example, 1849 1 and 1849 2 need to become a single page, 1849, referencing both the 1849 I and 1849 II condo projects.

The same is true for all condo projects & subdivisions which are broken into individual phases / developments except for Snowcreek. The Snowcreek 1 through 5 searches and pages should remain separate. The others need to be combined:

Regarding the redirects, they should then be redirected to the combined page for the appropriate subdivision or condo project. In the example you gave, they would all be redirected to the combined 1849 page.

Please let me know if you have any questions.

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

The Remax-Mammoth.com client has requested that we create a number of additional condo project and subdivision pages for this site. The tricky part for us is that these condo projects and subdivisions represent areas for which there are not currently MLS listings (which is why these searches and their associated pages were not created in the original page creation process).

I've attached a spreadsheet provided by the client for this purpose (Mammoth MLS Codes for Property Searches.xls). Unfortunately, it appears that the client provided codes for all condo projects and subdivisions, rather than only for those which still need to be created. So, I have also attached a sheet, Mammoth Subdivisions and Condos_NEW_PAGES.xls, which outlines just the new pages to be created, along with which of the Project Areas the new pages are associated with.

I'm not sure what would be the best way for us to go about this. I think there are a couple of steps:

1 - First, create the needed saved searches for both condos and subdivisions. To do this, the value from the "Description" column will be used in the appropriate field in the SavedSearches table (either CondoProject or Subdivision), while the same value, but with the abbreviations replaced, would be used for the SearchName field. So, for example, in creating a new search for the Mammoth Gateway Village condo project, the CondoProject field would contain the value "Mam Gateway Vil" and the SearchName field would contain the value "Mammoth Gateway Village".

In some cases in the Mammoth MLS Codes spreadsheet, you'll notice that several values have been combined into one line in the Description field. In such cases, please store all indicated values in the "CondoProject" or "Subdivision" field, as we are going to be pulling listings from multiple CondoProjects or Subdivisions into the results of a single search. In such cases, please use the first value as the basis for creating the associated SearchName.

2 - Once that's done, create pages for the new searches using the same templates that you used previously, and using the NEW_PAGES spreadsheet to determine which Project Areas the new pages are associated with. There are several condo projects and one subdivision for which there are not currently Project Areas listed, and it's fine to ignore these for now (please create saved searches for them, but not pages).

Please let me know if you have any questions.

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

This looks great, thanks. Just to double-check, can you verify that the searches for 1849, Grayeagle, etc., contain all of the condo projects for that area, even for those where there are currently no listings on the market (meaning, 1849 containts 1849 I and 1849 II)? I realized that I will need to inform the client that modifying or saving these searches would cause all condo complexes for which there are not current active listings to be removed from the search -- that is the case, is it not?

One more content-related change we need to make to this site is regarding the Mono County Communities pages. I apologize for not providing a full template for the content on these pages. Could you please modify these pages to the following (using Lee Vining as an example)?

1 - Meta Title: Lee Vining CA Real Estate | Homes for Sale Lee Vining CA | Remax-Mammoth.com

2 - Meta Description: Search homes for sale in Lee Vining, CA, updated every day from the Mammoth Lakes MLS. Listings included detailed property information, big photos, virtual tours, maps and more.

3 - Meta Keywords: lee vining ca real estate, homes for sale lee vining california, mammoth lakes ca mls

4 - Content Area:

Lee Vining CA Real Estate

Included below are homes for sale in Lee Vining, California. Lee Vining, CA is located in Mono County, north of Mammoth Lakes and Mammoth Mountain. These property listings are updated daily from the Mammoth Lakes, MLS.

If you would like more information on any of these Lee Vining, CA homes for sale, just click the "Request More Information" button when viewing the details of that property. We can provide you with current market data, disclosures, past sales history, dates and prices of homes recently sold in the Mono County area, and more.

And, if you haven't already, be sure to register for a free account so that you can receive email alerts whenever new Lee Vining, CA real estate listings come on the market in Mono County, California.

Next, the client has also requested that some of the featured searches pages we created be deleted, as they are not applicable to certain areas. So, can you please reference the attached spreadsheet, and remove the requested pages (the ones in gray are the ones that need to be deleted).

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Ah, I should have warned you -- I believe the client had gone through and made changes to the meta tags for a number of those pages, per his own intentions for those pages. I had hoped only to focus on the mono counties community pages for the content updates, and then to remove the pages indicated. I apologize for not being more clear.

I will check with the client regarding your updates -- if the client does prefer that these pages be changed back to their previous versions (for meta tags, etc.) would it be possible to roll them back?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Thanks for doing this.

2 - Yes, I had not realized that it would be a problem for us that Residential and Condos are separate List Types in this region. Rather than creating separate pages and searches for Residential and Condos, can you alter these so that the "All Types" list type is selected, and then select the following List Type Descrips: Single Family, Condominium, Townhouse, Duplex, Triplex?

That will enable us to get all listings for each topic into a single page and a single search.

3 - You're correct that we don't currently have a way to denote "Recent Price Reductions" -- the only way to come close to this at present is to do a Price Reduction saved search, and then sort by Days on Market. Even though that would not always be most accurate in terms of recent price reduction, it's the best we can do for now.

4 - You are also correct that we don't currently have a way to do Longest On Market. I will inform client that we need an alternative search for this item.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have verified that the saved-searches for the CondoProject/Subdivisions listed in comment-26 contain all of the CondoProjects/Subdivisions for that area. And yes, when updating these saved-searches a CondoProject would be removed if there are no active listings available for that CondoProject.

I have updated Mono County Communities pages per comment-28. Please note that there were about 100 having same text set as MetaTitle, MetaKeywords and MetaDescription. I do remember adding distinct values for these three fields when creating community pages. I have double checked the Create Community pages and Add/Update content page script/code and there doesn't seem to be any problem with that. I may have accidentally updated meta-tags in the "Mammoth Lakes Condos" and "Mammoth lakes Subdivision" sections pages when updating content in the database but I am sure I didn't update content pages in other sections. I have also checked the Pages Versions tables but I could not find records for most of these pages. So, I am not quite sure about the cause of this. I have updated the meta-tags for most of these pages based on the-meta tags of similar pages in other sections.

I have also deleted the pages listed in the spreadsheet.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Can you please also make the following updates to the Remax-Mammoth.com site?

1 - In the attached spreadsheet URL Structure for SEO Remax-Mammoth_REV_2012-02-18.xls, I've highlighted in yellow the pages that still need to be created on the site and / or whose URLs need to be edited as outlined in the spreadsheet. (For example, "/mammoth-new-listings/" needs to be updated to "/new-real-estate-listings/", etc.)

2 - Also, the client would like the "View All" links on the home page scrollers to point to pages as outlined in this spreadsheet, rather than to saved searches in the property-search section. So, once the pages above have been created, can you update these links accordingly? The "Foreclosures & Short Sales" scroller should point to the "/mammoth-foreclosures-and-short-sales/" link (which consists of all REO properties), etc.

3 - Can you then please verify that all pages the client marked as "DELETE" in this spreadsheet have been deleted?

4 - Next, can you double-check one more time that pages have been created for all condos and subdivisions listed in the attached, Mammoth Subdivisions and Condos.xls?

5 - Last, can you double-check one more time that abbreviations have been replaced / updated as requested, and that multi-part condo projects and subdivisions have all been combined to a single page as requested?

I know you have already completed the last couple of items, but if you could go through one more time just to be sure, I would appreciate it. This client is giving us a hard time, and I hope to turn the site back to him tomorrow as complete, and it would be best if he did not see any items to find fault with.

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Then, the client has one more change request for the remax-mammoth.com site. The would like the options in the home page browse communities box to be changed as follows. Can you create pages for the items listed in the attached, and then use them to populate the home page browse communities box? The title of the home page browse communities box should be changed to, "What Are You Looking For?" instead of "Mammoth Condos and Communities" but the "View All" link should remain.

With the page titles indicated, you may have trouble getting three columns of links without some of them wrapping to second lines. If that's the case, please remove "Lakes" from some of the titles -- i.e. "Mammoth Foreclosures" instead of "Mammoth Lakes Foreclosures," etc. Also, just use "Longest on Market" for that page and leave off the "DOM."

Some of these pages are referenced in the attached "URL Structure" spreadsheet -- please use the URLs indicated in creating these new pages (although ignore the "/property-search/list" portion of these URLs, as that is not correct.)

Please let me know if you have any questions.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I have made changes per comment-51 and 52.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

Please note that, the pages I updated had same text set as all three meta-tags. For example, the 1849 page had "1849 Condos for Sale | RE/MAX Mammoth" set as MetaTitle, MetaDescription and MetaKeywords. Also, I did not find any records for these pages in the versions table so I guess these pages might not have been updated by client using CAA.

Please let me know if I should update the MetaKeywords per the spreadsheet. For example, the MetaKeyrds of the 1849 page would be updated to "1849 condos,1849 mammoth" from existing "1849 condos for sale, Mammoth Lakes California real estate, 1849 Mammoth Lakes condos for sale".

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have adjusted the padding on the left side of the new details page for this site and added Mammoth Sales Data sections and pages. I have added styling for these pages in the global.css of the front-end site and in the content manager stylesheet.

Please check these pages and let me know your feedback.

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Ah, I see. That's strange -- I'm not sure what could have happened there, as I did not make any programmatic updates which could have caused such changes. In that case, please leave them as they are for now, and I will inquire with the client -- meaning, leave Meta Keywords as they are rather than updating per the spreadsheet.

If there are no records of changes in the PagesVersions table, then perhaps the client was not the one who made these updates? I'm just not sure what could have happened there...

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

When you have time, can you please add three new pages to the Main section of the Remax-Mammoth.com site?

The content for each is attached.

Then, the client would like links for these placed into the footer of all pages on the site. I'm not sure the best place for this, but I think centered and directly under the white "page" content area / drop-shadow, in the same text color as the "325 old mammoth road..." text. Can you give this a try?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

Regarding Subdivisions pages I am not sure which subdivision belongs to which project/neighborhood area. Could you please guide me how find project/neighborhood area of a subdivision?

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have added saved-searches and community pages for the new condo projects and subdivisions listed in the spreadsheet. I have also added rewrite rules per comment-24.

Regarding creating single saved-search and community page for the CondoProject/Subdivision for which combined value is specified in the Description field, please note that we have already created individual saved-searches and community pages for one or more CondoProject/Subdivision. So, I have created individual saved-searches and community pages for such new CondoProjects/Subdivisions.

For example, we have already created saved-search and community page for Grayeagle I so I have added separate saved-search and community page for Grayeagle II.

Please let me know if I should merge saved-searches and community pages for such CondoProject/Subdivision. Or would it be fine to redirect the old page to one of the individual page of such CondoProject/Subdivision.

For example, following old pages would be redirected to http://remax-mammoth.com/mammoth-condos/1849-i/,

http://www.remax-mammoth.com/html/1849.html

http://www.remax-mammoth.com/html/1849.html

http://www.remax-mammoth.com/html/1849__unit_102.html

http://www.remax-mammoth.com/html/1849__unit_304.html

http://www.remax-mammoth.com/html/1849__unit_611.html

http://www.remax-mammoth.com/html/1849_ii__unit_562.html

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have updated the names of the saved-searches and pages content per comment-16. Please check the same.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

The client has some additional feedback for the Remax-Mammoth.com site. Can you help with these as you have time? These would be lower priority that page-associations programming.

Comments and suggestions about the links in the “What are you looking for box?” The box is good and outlines exactly what Paul is looking for but some of the new links/pages you created pose a problem with duplicate content and SEO linking strategy. The links need to be linked to the already created pages to optimally SEO the site structure. As an example for the Mammoth Condos link, it doesn’t make sense to have two different pages to build back links to, to target the same keywords and/or show the same listings.

1) At the Lifts – I changed this to Ski Resort Condos. I also changed the URL to /ski-resort-condos/

2) June Lake - Good

3) Mammoth Condos – Please delete the page you created /mammoth-lakes-condos/ and link to /mammoth-condos/

4) Mammoth Foreclosures – Please delete the page you created /mammoth-lakes-foreclosures-properties/ and link to /mammoth-lakes-foreclosures/

5) Mammoth Short Sales – Please delete the page you created /mammoth-lakes-shortsales-properties/ and link to /mammoth-lakes-short-sales/

6) Recent Price Reductions – This link goes to the same page as “Price Reductions”. Please remove link and replace with Golf Course Properties and link to /mammoth-lakes-golf-course-properties/

7) Crowley Lake - Good

9) Mammoth Crash Pads – Good

10) Mammoth Homes – Please delete the page you created /mammoth-lakes-homes/ and link to /mammoth-homes/

11) Newest REO’s - Good

12) Single Family Homes – This link goes to the same page as “Mammoth Homes”. Please remove link and replace with Ski In Ski Out and link to /ski-in-ski-out-condos-and-homes/

13) In The Meadow – Please delete the page you created /in-the-meadow/ and link to /mammoth-lakes-real-estate/mammoth-meadow/

14) Luxury Homes - Good

15) Mammoth Dirt – Please delete the page you created /mammoth-dirt/ and link to /mammoth-lakes-lots-and-land/

16) Mammoth New Listings – I changed the URL to /new-listings-mammoth-lakes/

17) Price Reductions - Good

18) Snowcreek Condos - Good but can you change the URL from /snowcreek-condos/ to /mammoth-condos/snowcreek/. I have a plan for this page to add additional content with links to all the Snowcreek Phases.

The client also has the following comments about the foreclosures / REOs searches & pages. In general, I believe that our "REO" designation currently includes both Short Sales and Foreclosures. I believe we need to change the search criteria for both pages to be only Foreclosure properties. So, the searches for the REO pages should use only Foreclosures as the criteria, not REOs and / or Short Sales. Here are the client's comments:

There is still a discrepancy between the data for “foreclosures” and “reo properties.” These should be exactly the same listings. It would be ok to leave as two separate pages as some people may relate to the terms differently.

1) Mammoth Lakes: The data in REO Properties and Short Sales is similar, because 445 Fir Street is the first listing on both pages. Foreclosures is showing 3 listings REO Properties is showing 67 listings

2) Crowley Lake: Foreclosures is showing 2 listings REO Properties is showing 6 listings

3) June Lake: Foreclosures is showing 1 listing REO Properties is showing 2 listings

4) North Mono County: Seems OK, both Foreclosures and REO Properties are showing 3 listings

5) South Mono County: Foreclosures is showing 0 listings REO Properties is showing 1 listing

Then, here are one additional set of feedback / comments from client:

On the home page in the main content area can you change the link for “Mammoth Lakes homes for sale” to link to /mammoth-homes/.

On the Mammoth Lakes Communities Page can you add a link for Ski In Ski Out under Mammoth Featured Properties and link to /ski-in-ski-out-condos-and-homes/.

Mammoth Condos Projects page looks good! Thanks for adding the pages, combining the multiple phase projects, and fixing all the abbreviations.

Mammoth Subdivisions page looks good as well. Only thing I noticed is that Mammoth Heights A & B should be combined into 1 page /mammoth-homes/mammoth-heights/. Again thanks for adding all the pages and fixing the abbreviations.

For the links above the info bar for Home and Blog, can we change the font to better match the font and color in the info bar? Also we need to add a link to Paul’s blog for his newsletter sign up. The anchor text for the link should be “Newsletter Sign Up” and the link would be http://www.mammothrealestateblog.com/2011/06/whats-this-bi-weekly-newsletter-about.html. Please open link in a new tab.

Below highlights the subdivisions to be added from your list below:

1) North Village – Subdivision, project area Village

2) Old Mammoth – Subdivision, project area Old Mammoth. There already appears to be a link to Old Mammoth Road. I went ahead and changed the page title to Old Mammoth and the URL to /old-mammoth/. Can you just verify that the search listings are accurate?

3) Pine Cliff Manor – Subdivision, project area Old Mammoth

4) Shady Rest Tract – Subdivision, project area Town

5) Webb Subdivision – Subdivision, project area Village

6) White Pine – Subdivision, project area Village

(Vihang, for creating the above pages, please use existing pages within the corresponding project areas as templates.)

Mammoth Industrial Park and Mammoth Lakes Airport are commercial areas, and currently there is not really a commercial category for the website except the listings page /mammoth-lakes-commercial-real-estate/. At first Paul was not too interested in displaying Commercial, but he would like to add these to the website. What about a subpage to the URL above i.e. /mammoth-lakes-commercial-real-estate/mammoth-industrial-park/ and /mammoth-lakes-commercial-real-estate/mammoth-lakes-airport-hangers/ and just add the links under Mammoth Featured Properties?

Mammoth Lakes Other is not important, all the condo projects and subdivisions are already accounted for.

For the 301 redirects for the old site to new site I just want to confirm that all the links are pointed to the correct URL. I noticed that there were some changes from the draft I put together for you:

http://www.remax-mammoth.com/html/featuted_listings.html points to http://remax-mammoth.com/mammoth-lakes-featured-listings/ not http://remax-mammoth.com/property-search/list/mammoth-lakes-featured-listings/

http://www.remax-mammoth.com/html/new_listings.html points to http://remax-mammoth.com/new-real-estate-listings/ not http://remax-mammoth.com/property-search/list/new-real-estate-listings/

http://www.remax-mammoth.com/html/new_listings_week_ended_novemb.html points to http://remax-mammoth.com/new-real-estate-listings/ not http://remax-mammoth.com/property-search/list/new-real-estate-listings/

http://www.remax-mammoth.com/html/new_listings_week_ended_novemb1.html points to http://remax-mammoth.com/new-real-estate-listings/ not http://remax-mammoth.com/property-search/list/new-real-estate-listings/

http://www.remax-mammoth.com/html/new_listings_week_ended_novemb2.html points to http://remax-mammoth.com/new-real-estate-listings/ not http://remax-mammoth.com/property-search/list/new-real-estate-listings/

http://www.remax-mammoth.com/html/new_listings_week_ended_octobe.html points to http://remax-mammoth.com/new-real-estate-listings/ not http://remax-mammoth.com/property-search/list/new-real-estate-listings/

http://www.remax-mammoth.com/html/top_of_the_market.html points to http://remax-mammoth.com/mammoth-luxury-homes/ not http://remax-mammoth.com/property-search/list/mammoth-luxury-homes/

Please let me know if you have any questions about this.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

Today, with the IndysBestHomes.com site (essentially) completed, we will need to turn our attention back to the Remax-Mammoth.com site. For this site:

1 - Yes, please do create community pages for Mammoth Lakes Project Areas, Mono County Communities and Inyo County Communities sections. Doing this for the Project Areas, however, may be slightly complicated, as those areas are not directly represented in the MLS data. Meaning, for example, that I don't believe there is an easy way to draw in all of the "Canyon Lodge" or "Eagle Lodge" listings into a single page. The only way I see to do that would be by creating a saved search for the Subdivisions and Condo Projects that are referenced as belonging to the Project Area on the individual workbook sheets (Canyon, Eagle, Meadow, etc.) However, because we can't include listings by both Subdivision and Project Area in a single set of results, we would not be able to pull all listings into a single page.

So, for now, please create the individual pages, and then, on each page, bring in two content label widgets, one for "[Project Area] Condo Developments" and one for "[Project Area] Neighborhoods (Single Family Homes)". The first would include links to the different condo projects in that project area, and the second to the different subdivisions in that area.

Regarding creating the subdivision pages, I think we may run into a similar difficulty there in attempting to conform to the "Subdivisions" content template. Again, there is no way, when pulling a list of Subdivisions, to tell from the MLS data which Project Area they are part of. So, I believe it will be necessary to create the Subdivision pages in separate batches, one for each Project Area, so that the individual Project Areas can be properly referenced within the pages. Hopefully this should go fairly quickly once the basic programming is in place.

On the Communities page of the site, yes, we would display Featured Searches for the different areas, but we will also want to include content label widgets for:

So, the order should go:

Pleae let me know if you have any questions.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

My apologies for not confirming this with you before making updates. I am not quite sure if we would be able to restore all pages' meta-tags to their previous state as I updated these pages in the database so we don't have previous version of these pages stored in versions table, but I guess we would be able to restore about 75 to 80% pages' meta-tags.

Thanks

Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Ben,

I have made changes in the site per comment-43. Please note the followings:

1-- Now that we have updated the Home community box to link to previously created pages, the following links in this box would change as these pages were created for different purpose,

Mammoth Condos --> Condos Mammoth Foreclosures --> Foreclosures Mammoth Short Sales --> Short Sales Mammoth Dirt --> Lots / Land Mammoth Homes --> Single Family Homes

Please let me know if I should hard code the links in the Home Community box rather than displaying pages associated with "Homepage Communities Box" content label.

2-- I haven't removed the "Single Family Homes" as the "/mammoth-homes/" links to this page but I have added the "Ski-In / Ski-Out Condos and Homes" in place of "Mammoth Homes".

3-- I have updated following REO saved-searches to list only Foreclosures listings:

4-- I haven't added the "Mammoth Industrial Park" and "Mammoth Lakes Airport" pages as I am slightly confused regarding creating subpage to the "Mammoth Lakes Commercial Properties" (/mammoth-lakes-commercial-real-estate/). The "Mammoth Lakes Commercial Properties" page is assigned to the "Communities" section so, I am not sure it would be possible to create these two pages with filename "/mammoth-lakes-commercial-real-estate/mammoth-industrial-park/" and "/mammoth-lakes-commercial-real-estate/mammoth-lakes-airport-hangers/".

Should I add a new section "Mammoth Lakes Commercial Real Estate" (/mammoth-lakes-commercial-real-estate/) and move the "Mammoth Lakes Commercial Properties" (as default page) to this section and then add the "Mammoth Industrial Park" and "Mammoth Lakes Airport" pages to this section.

5-- I have verified that the 301 redirect links are pointing to correct pages.

Thanks Posted by Shah Vihang(unfuddle username: vihang)

Battler45 commented 4 years ago

Vihang,

Our Remax-Mammoth.com client emailed today to report a problem with the Sitemap and XML Sitemap on the site:

"I am going over the HTML Sitemap in more detail today, and from the note below, it is to update automatically, whenever content is added, changed, or deleted. But it is missing a good portion of the links found throughout the site:

1) Does not include all links under Mammoth Featured Searches 2) No links for Crowley Lake Featured Searches 3) No links for June Lake Featured Searches 4) No Links for North Mono County Featured Searches 5) No Links for South Mono County Featured Searches 6) No links for Mammoth Sales Data or Market Reports 7) No links for Mammoth Crash Pads, Mammoth Luxury Homes, or New Listings

This is not an exhaustive list, but you can see where I am going with this. The sitemap does not include all the links."

Can you please update these pages to make sure that they always pull all pages from all sections on the site? (I realize that if we add new sections in the future, we may need to update the programming on these pages, but for now please set it up so that it will always pull all pages from all existing sections.)

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Vihang,

One more thing on the remax-mammoth.com site -- can you also please remove the drop-down menu below Featured Listings? We don't need a drop-down menu under that navigation item.

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)