Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:58:51
[post_modified_gmt] => 2024-04-09 17:58:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1725706430
ffd_listing_title, 2254 Union 2258A Street, San Francisco, CA, 94123
ffd_mls_id, 424056269
ffd_salesforce_id, a0EUd0000031esvMAA
num_of_rooms__c, 16
of_units__c, 4
address2__c, 2254 Union 2258A Street, San Francisco, CA, 94123
pba__address_pb__c, 2254 Union 2258A Street, San Francisco, CA, 94123
agent_only_remarks__c, Please allow at least 24-48 hours to see tenant occupied units. Call or text listing agent with any questions 415-269-6321 or for Offering Memo.
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-04T14:46:33.000+0000
days_on_market__c, 3
dom__c, 3
ffd_description_pb, Incredible opportunity to own a trophy investment property on Union Street in the heart of Cow Hollow. This well-maintained, mixed-use building offers ground floor commercial space with two residential flats above, as well as a detached one-bedroom cottage. The two full-floor flats offer classic Edwardian details, each with two bedrooms, one bathroom, high ceilings, in-unit laundry, hardwood floors and views from the upper unit. A beautiful garden separates the front building and the cottage. The charming one bedroom cottage includes an updated kitchen, bathroom, living room and full basement with laundry and spacious storage area. The cottage will be delivered vacant and would make a lovely pied-a-terre for an owner-user or attractive rental unit for investors. This prime Union Street location is close to both the residential and commercial corridors of the highly desirable Cow Hollow district. Easy access to the Golden Gate Bridge, the Presidio, Fillmore Street, Chestnut Street, shops, restaurants and grocery stores.
2254 Union 2258A Street, San Francisco, CA, 94123 - Property Description
Incredible opportunity to own a trophy investment property on Union Street in the heart of Cow Hollow. This well-maintained, mixed-use building offers ground floor commercial space with two residential flats above, as well as a detached one-bedroom cottage. The two full-floor flats offer classic Edwardian details, each with two bedrooms, one bathroom, high ceilings, in-unit laundry, hardwood floors and views from the upper unit. A beautiful garden separates the front building and the cottage. The charming one bedroom cottage includes an updated kitchen, bathroom, living room and full basement with laundry and spacious storage area. The cottage will be delivered vacant and would make a lovely pied-a-terre for an owner-user or attractive rental unit for investors. This prime Union Street location is close to both the residential and commercial corridors of the highly desirable Cow Hollow district. Easy access to the Golden Gate Bridge, the Presidio, Fillmore Street, Chestnut Street, shops, restaurants and grocery stores.
