Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/643224/284-Elmwood-St/Mountain-View/https://www.londonproperties.com/images/props/fresno/full/643224.jpgLondon Properties Mountain View Real Estate | 284 Elmwood St
This exceptional multi-family property in Mountain View presents an outstanding investment opportunity in the heart of Silicon Valley. With multiple units spanning 3,600 square feet, this fully occupied residence generates steady rental income while offering tremendous development potential on its spacious corner lot.The property's prime location puts residents within walking distance of downtown Mountain View, making daily errands a breeze. Tech professionals will appreciate the proximity to major technology companies, while families benefit from nearby Mountain View Academy and convenient access to the Mountain View Transit Center, just a few blocks away. The Caltrain station ensures seamless connectivity throughout the Bay Area.Each dwelling unit has been thoughtfully maintained, creating comfortable living spaces that tenants love to call home. The multiple units provide flexibility for investors seeking consistent cash flow or those considering future development opportunities. The generous lot size offers potential for expansion or enhancement, subject to local planning requirements.Whether you're an experienced investor looking to expand your portfolio or someone seeking development potential in one of California's most sought-after markets, this multi-family gem delivers both immediate returns and long-term growth prospects. The combination of location, income potential, and development possibilities makes this a rare find in today's competitive market.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE `StreetName` = 'fghdfhgdfghdfghdfhgdfghfghfdg' LIMIT 1
0
Courtesy of Greg Haley, Universal Realty Services, Inc. - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 13 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.