post

vFlyer Offers Single Property Sites

By: NikNik · Posted on August 20, 2007 · 7 Comments
Or, “custom and vanity domains” as Oliver Muoto prefers. Earlier this month, vFlyer launched their single property site solution, Domain Plus. If you are already using vFlyer to create your listing flyers for syndication, then you may want to consider upgrading your subscription with Domain Plus. If you are not a current vFlyer subscriber, I urge you to check out this valuable real estate marketing tool.

With Domain Plus, you can search for and then purchase the domain name for your vFlyer listing ad or gallery. For example, a listing at 1731 Chanson Place in GA, would have the domain: http://www.1731chansonplace.com/. (Thanks Brad) Now you can spotlight your listings on the Web by giving them their own URL. Show your clients just how dedicated you are to featuring their listing in a variety of mediums…single property sites being one of them. This is a great feature to highlight in your prelisting presentation as well.

vFlyer can save you more time than ever now by giving you an additional marketing option with minimal set up time. Even the best multi-taskers will appreciate the ability to create listing ads, distribute them to leading online marketplaces, and purchase custom domains all in one visit to vFlyer.

vFlyer is offering competitive pricing for their single property sites. You do need to sign up for an annual subscription to take advantage of Domain Plus. For example, a vFlyer starter subscription has an annual fee of $99.50 a year, monthly fee of $9.95 and each domain name can be purchased for $9.95 each. (Total cost $149.25) Also, the more you purchase the more you get. vFlyer is currently promoting their “FREE Domain Name Offer” until August 31st. Anyone who signs up or upgrades to an annual subscription will get one or more free domain names, as well as 2 months free service.

BTW-vFlyer is not the only one is town offering these bundled services. RealBird provides a similar tool with their Listing Publisher. Both are great offerings depending on your specific Website wants.

post

11 Powerful Excel Formulas to Clean Your Real Estate Database

By: Reggie · Posted on August 17, 2007 · 7 Comments

Have you ever had the need to reformat a column of data in Excel? Possibly changing how the names read for a mailing list, or reformatting an address. If so you know that the right formulas can save you a great amount of time and frustration. I have 11 powerful excel formulas that will surely help out. Bring the power of Excel’s technology to your desktop.

  1. To extract the first name of a cell: type the following formula in B1 (Results: John)
    =LEFT(A1,FIND(” “,A1))
  2. To extract all of the text after the first word: type the following formula in B2 (Results: L. Smith)
    =MID(A2,FIND(” “,A2,1)+1,LEN(A2))
  3. To extract the last word in a cell: type the following formula in B3 (Results: Smith)
    =RIGHT(A3,FIND(” “,A3))
  4. To change the cell to all lowercase: type the following formula in B4 (Results: john smith)
    =LOWER(A4)
  5. To change the cell to title case: type the following formula in B5 type the following formula (Results: John Smith)
    =PROPER(A5)
  6. Change the cell to upper case: type the following formula in B6 (Results: JOHN SMITH)
    =UPPER(A6)


  1. Takes everything to the left of the comma: type the following formula in B1 (Results: Anytown)
    =LEFT(A1,FIND(“,”,A1)-1)
  2. Takes two characters after the comma. A perfect formula to extract state from the cell: type the following formula in C1 (Results: CA)
    =MID(A1,FIND(“,”,A1)+2,2)
  3. Take the last 5 characters of the cell. If you have zip +4 change the 5 to 10: In cell D1 type the following formula (Results: 99999)
    =RIGHT(A1,5)


  1. This formula will join two cells with a space in between: In cell C1 type the following formula (Results: John Smith)
    =A1&” “&B1
  2. Say you have first owner name and second owner name in the next column. You may only have second owner names for half of the list. With the standard concatenate function, you will have an “&” after each name whether or not there was a 2nd owner name. With my formula it will only add the “&” if there is a 2nd owner name. So this works conditionally checking for text in the 2nd cell. : In cell C1 type the following formula (Results: John & Amy)
    =MID(IF(ISTEXT(A2),”"&A2,”")&IF(ISTEXT(B2),” & “&B2,”"),1,100)

To use the formula to populate the entire column you will need to use the “Fill” command. For that see the following graphic:


Once you have finished cleaning and scrubbing your data, you still have one more thing to do. You need to keep the column of data you just created, but remove the formula that was used to generate it.

Begin by highlighting the column of data you just created… column “B”. Right mouse click on the column heading and choose “Copy”. Then right click on the same column heading “B” and select “Paste Special” then select “As Values” and click “OK”.

post

RSS Feeds: Double the Fun with the Common Feeds List

By: NikNik · Posted on August 13, 2007 · 2 Comments


Technology for Real Estate Feed

Now when you build your subscription list of RSS Feeds in Internet Explorer 7, you can access the same list within Microsoft Office Outlook 2007. Access your important real estate information (like Real Estate Tech Tips from MyTechOpinion) in both places by sharing one RSS Feeds subscription list via the Common Feeds List in Microsoft Windows. The Common Feeds List is used by programs such as Office Outlook 2007 and Internet Explorer 7 as a common location for RSS Feeds information. So, when you add an RSS Feed to any program that uses the Common Feeds List, that RSS Feed is available in all programs automatically. If an RSS Feed is deleted from the Common Feeds List, it will also be removed from Office Outlook 2007. You can change your current settings within the Advanced Options dialog box to begin this synchronization within Explorer and Outlook (see directions below). If you have not started a RSS Feed subscription list you will be prompted to synchronize by a dialog box with the first RSS Feed you choose to add.

Synchronize my Outlook RSS Feed subscriptions with the Common Feeds List

  1. On the Tools menu, click Options.

  2. On the Other tab, under General, click Advanced Options.

  3. Under General settings, select the Sync RSS Feeds to the Common Feed List check box.

Stop synchronizing my Outlook RSS Feed subscriptions with the Common Feeds List

  1. On the Tools menu, click Options.

  2. On the Other tab, under General, click Advanced Options.

  3. Under General settings, clear the Sync RSS Feeds to the Common Feed List check box.
post

The Future of Mobile Real Estate Technology Is Upon Us

By: Chad A. Johnson · Posted on August 12, 2007 · 5 Comments

While advances in computer hardware seem to appear everyday, it is infrequent that any such advancements truly mean anything to the mobile real estate agent. For the most part, real estate technology applications don’t require much processing power. This means that most real estate agents won’t see any noticeable difference in the use of a brand-new, cutting-edge laptop and one that is a year or 2 old.

Although I did say that it is infrequent that a significant technology advancement is introduced, we are on the verge of 2 such advancements. In fact, these 2 changes in laptop technology are so revolutionary that they are bound to influence the purchases of the mobile real estate agent for years to come.

Solid State Drives (SSD)
Any computer technician will tell you that laptop hard drives are prone to failure, much more so than desktop hard drives. This can be attributed to the bumps and bruises experienced from being a mobile device. No matter how careful you are with your laptop, your hard drive has most likely been knocked around a bit.

Hard drives are also one of the biggest drains on laptop batteries. The process of spinning the hard drive platters sucks a large amount of power.

Solid state drives solve both of these problems. By using flash memory (like thumbdrives, digitial cameras and small MP3 players), solid state drives are able to perform the same tasks as a traditional hard drive, but with no moving parts. No spinning platters means that energy consumption is reduced greatly and the durability of the drives is improved.

Toshiba is about to release the world’s very first laptop with a solid state drive. The Portege R500-S5003 will include a 64GB solid state drive. Upon its release, The Portege R500, with its solid state drive, 7mm thick DVD-RW drive and LED screen, will be the most advanced ultraportable to date.

LED Displays
A discussion on laptop battery life is not complete without talking about the power usage of the display. There is a reason that energy comsumption profiles on laptops dim the display when running off of battery. The display is one of the largest users of battery power of any laptop component.

The newly introduced use of LED lights in laptop displays instead of the traditional cold cathode fluorescent light is drastically changing the way we look at laptop screens. LED produces a brighter, whiter light than fluorescent while consuming far less power. LED lights are also smaller, making screens using them about half as thick as other screens.

LED screens are partly responsible for the recent promotion of ultra-thin laptops. My favorite of these new breed of computer is Dell’s XPS M1330. This 13.1”, media-intensive laptop could be the best blend of business mobility and personal life functionality all housed in a machine that stands barely over 1 inch tall.

Keep these 2 new technologies in mind when you purchase your next laptop computer. The LED screens are becoming quite prevalent, by the end of the year all laptop manufacturers should have an LED option or model.

The solid state drives may take a bit longer to become mainstream. You will start to see them in high-end, ultraportable machines. A hybrid drive (a traditional hard drive with flash memory onboard) may become more popular with manufacturers until the cost of solid state drives comes down and their capacity goes up.

Related Articles:

post

SpotIt Brings Community Interaction to your Real Estate Website

By: NikNik · Posted on August 10, 2007 · 12 Comments

Do you want an easy and quick way to enhance the content and value of your real estate website? Well, SpotIt—a new solution offered by OnBoard, may have just what you need. SpotIt is a “plug and play” Web 2.0 solution that allows consumers who visit your website to vote on their favorite local “spots”. Instantly turn your real estate website into a social networking community by giving visitors the opportunity to create their own categories and vote on them such as “Best Date Spot” or “Best Neighborhood for Kids”. SpotIt utilizes OnBoard’s huge store of community, amenity and school information and brings it to you via the SpotIt API or hosted page templates. SpotIt’s easy integration will give your real estate website a more significant presence on the web, as well as increase traffic. This fabulous community tool combines pinpoint mapping and local opinions to give your website visitors “real” information regarding hot spots in their area. Now your real estate website can promote you as a local expert and facilitate the community dialogue that will get you noticed! Check it out!

post

RealBird’s New Features and New Business Model

By: Reggie · Posted on August 9, 2007 · 1 Comment

RealBird has reworked their business model for you real estate agents, and will now be offering their RealBird Listing Publisher technology for free—without advertising. RealBird’s Listing Publisher has some great value propositions and is one of 7 great ways to syndicate your listing. To start, Listing Publisher will allow you to create an unrestricted amount of property websites. Since we know that enhanced content online helps sell the home, start by uploading an unlimited amount of property photos. Also use their powerful HTML editor to embed any multimedia content such as a video tour of the home, panoramic slide show or podcasts.

According to NAR, approximately 70% of buyers want to know more about the community they are buying in, so you’ll want to use the rich-text editors to include community and neighborhood information. Potential buyers will also see a “ValPak” icon to the map providing local coupons to enhance their experience. The Listing Publisher will also cross market your listings on each custom site you’ve created. You will also want to include these listings on your personal website. Simply grab their ‘Just Listed” widget to display your listings in the side bar of your website or blog. Or maybe it’s GeoRSS mapping widget you’re looking for. This widget will provide your website visitors local street maps, amazing 40 degree angle “bird’s eye” views (HOT technology) with local points of interest overlay.

Once your site is built, easily publish your listing site to a domain of your choice. Now it’s time to syndicate your listing for maximum exposure. RealBird can help you get the word out to Google Base, Trulia, Edgeio, Lycos Classifieds, Oodle, Local.com, Vast, and RealBird’s own SearchOnMaps.com. You can also grab the code to post on tools like Craigslist, Backpage, Kijiji, Facebook etc.

post

Real Estate Backup Technology – Part 2

By: Chad A. Johnson · Posted on August 6, 2007 · 1 Comment

Hopefully, Part 1 of this series really got you thinking about the necessity of data backup. Possibly, you have since registered for Carbonite and now have a backup procedure in place. For those seeking a backup solution that does not rely on a separate company, let’s look at a different solution.

Probably the most popular backup solution of the past couple of years is that of the external hard drive. Through the use of traditional internal hard drives nestled in USB enabled enclosures, these devices provide huge storage capacities with relatively fast data transfer rates. Best of all, the cost per gigabyte of storage is cheap (less than $0.50 in many cases).

What has made external hard drives such great backup devices has very little to do with the hardware, though. It is the bundled software that really makes for the backup solution. Without a backup program, it is up to the operator to transfer files to the hard drive. That can be a tedious task and is never continued with the regularity that it should.

External hard drives with bundled backup software make regular data backups effortless. After a simple installation and configuration process, there is no additional work required by the user. Most programs can be configured to backup the entire computer system or select folders. They are also great for incremental backups. This entails a large initial backup, followed by subsequent small backups that cover only new and modified files.

Here are a few external hard drive products that include bundled software for a complete backup solution:

Western Digital My Book Pro – This product has clearly become the most popular external hard drive recently. There are actually 3 different models of the My Book: Essential, Premium and Pro. The Essential has no backup software included and the Premium relies on a Western Digital-branded program. The Pro version worth the extra expense due to the fact that it is bundled with EMC’s Retrospect Express, an industry leader in backup applications. This device has one very unique feature in that it turns itself on and off automatically with the connected computer system. The My Book Pro can connect using USB 2.0, Firewire 400 and mainly for Mac users, blazing fast Firewire 800.

Seagate FreeAgent Pro – Seagate is a late comer to the external hard drive field. Coincidentally, their first product hit the market shortly after they purchased Maxtor (a pioneer in the external hard drive game). Seagate differentiates itself through storage capacity and connectivity. Seagate offers a 750 GB external drive that uses only one hard drive. While other devices using Hitachi’s new 1TB drive are surely on the way, the 750GB is the largest external drive that doesn’t use a RAID configuration. While I use a RAID configuration on my system, I like simplicity when it comes to my backup solution. As for connectivity, the Seagate offers not only the usual USB 2.0 connection, but also incorporates an eSATA port. An eSATA is the same type of port as those already connecting internal hard drives in newer systems. This connects is the very fastest available, but will require an additional PCI card to be installed for most systems as eSATA ports are very uncommon (well worth the extra effort).

Western Digital My Book World – For those with multiple computers to backup, a drive network enabled drive may be for you. The My Book World is virtually the same drive as the My Book Pro, but with a gigabyte Ethernet port. Plug this into a network port, install the EMC Retrospect Express software on each computer and all of your systems are now covered. As an added bonus, the My Book World allows for remote access to files from any Internet connected computer (hence, the name World). Check out this demo for more information on remote access using the Western Digital My Book World.

When purchasing an external drive, buy the largest capacity that you can afford. Most backup software allows for versions of files to be stored. This is a very valuable feature, but it can create backup data bloat. Get a drive with capacity that is larger than your computer’s current storage capacity to allow yourself room to grow.

One last caveat to using an external drive as a backup solution, you will still need to implement some form of offsite backup to protect against fire and theft. I use an external drive for weekly backups and burn data to DVD on a quarterly basis for offsite storage in a safe deposit box. This does add a bit of extra work 4 times a year, but the added protection is worth it.

post

Know any real estate bloggers?

By: NikNik · Posted on August 3, 2007 · 9 Comments

Well, we sure do now! The MyTechOpinion team made their way across the bay to take part in the Inman Bloggers Connect festivities and conference. The usual suspects were present (Reggie, Chad, & myself). But in hopes of turning my business partner (and virgin blogger) onto blogging, I brought along my collaborator in crime, Sarah.

We arrived at the Beers & Bloggers party at the Thirsty Bear in San Francisco to find the shindig in full swing. There wasn’t much room to really work the crowd, so we corralled ourselves into a little corner up front and considered ourselves greeters. At any rate, it turned out to be a great spot, as Louis Cammarosano from HomeGain was the first to connect with us. As we suspected, Joe and Rudy from Sellsius, were a kick in the pants…literally!!! We enjoyed a few “small world” realizations as Trulia’s Jamie Glenn and I appreciated our hometown charm gone wild, and Pat Kitano and Sarah initiated a high school reunion for 2!

Joe and Rudy offered us a ride on the BlogTour bus to the Trulia party at John Colins …but we passed after they said Sarah could drive. After arriving safely (via Bill the taxi man), things turned dangerously hot upstairs with condo kings Tony from CondoDomain and Adam from Condo.com. Canada was well represented with pro bloggers Stephen and Mike of Ubertor, and Sara and Sheldon of The Edmonton Real Estate Blog. A special thanks to Stephen, as his out of town insistence on after party hot spot, The Clift, proved to be one memorable evening.

As for the conference the following day, we found Mary McKnight’s advice and tips to be on point. So I’m sure you’ll be seeing a lot more questions for post titles here in the future. Overall, it was great experience for enthusiastic real estate bloggers of any level. Sarah (our virgin blogger) came away with enough helpful information and inspiration to want to jump into the blogosphere with both feet! I’m sure she’ll have a few friends along the way to support her.
See more photos here.