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, 1710471319
ffd_listing_title, 1515 Union Street #6E, San Francisco, CA, 94123
ffd_mls_id, 424001440
ffd_salesforce_id, a0EUd000000m912MAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 41
address2__c, 1515 Union Street #6E, San Francisco, CA, 94123
pba__address_pb__c, 1515 Union Street #6E, San Francisco, CA, 94123
agent_only_remarks__c, Showings are by appointment only. Please contact listing agent: Andy Ardila at 415-608-1003 or David Costello at 415-828-8122. If you prefer, email: [email protected] or visit www.unionhousesf.com
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator;Plumbed For Ice Maker
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Marble
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2020
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David S Costello
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-01-10T01:46:18.000+0000
days_on_market__c, 65
dom__c, 65
ffd_description_pb, Newly constructed in 2020, Union House is located in one of San Francisco's most coveted neighbors: Pacific Heights. This upscale 7-story building combines contemporary styling, generously proportioned floor plans with high ceilings, and extraordinary finishes of the highest quality. This distinctive light filled 3 bedroom, 3 bath home includes everything a discerning buyer would expect from a luxury residential development: European wide-plank oak flooring, large closets, chef's kitchen with large island, white quartz countertops and backsplashes, and high end appliances including a Meile 5-burner gas cook-top, stove, dishwasher & refrigerator. The principal bedroom includes an en-suite oversized bathroom with a spa like shower, double sinks w/quartz countertops, and a free standing soaking tub. The second bedroom includes a spacious closet, a bathroom with a glass enclosed shower, and sink with quartz walls, floors and countertop. One of the most desirable units in the building, Unit 6E includes a spacious private patio with direct views of the Golden Gate Bridge and The Place of Fine Arts. Amenities include a doorman, a warmly designed guest reception area with a gas fireplace, and a roof deck w/Barbecue.
district__c, SF District 7
driveway_sidewalks__c, Gated,Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Marble;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Gas,Insurance on Structure,Maintenance Exterior,Management,Roof,Security,Sewer,Trash,Water
1515 Union Street #6E, San Francisco, CA, 94123 - Property Description
Newly constructed in 2020, Union House is located in one of San Francisco's most coveted neighbors: Pacific Heights. This upscale 7-story building combines contemporary styling, generously proportioned floor plans with high ceilings, and extraordinary finishes of the highest quality. This distinctive light filled 3 bedroom, 3 bath home includes everything a discerning buyer would expect from a luxury residential development: European wide-plank oak flooring, large closets, chef's kitchen with large island, white quartz countertops and backsplashes, and high end appliances including a Meile 5-burner gas cook-top, stove, dishwasher & refrigerator. The principal bedroom includes an en-suite oversized bathroom with a spa like shower, double sinks w/quartz countertops, and a free standing soaking tub. The second bedroom includes a spacious closet, a bathroom with a glass enclosed shower, and sink with quartz walls, floors and countertop. One of the most desirable units in the building, Unit 6E includes a spacious private patio with direct views of the Golden Gate Bridge and The Place of Fine Arts. Amenities include a doorman, a warmly designed guest reception area with a gas fireplace, and a roof deck w/Barbecue.
