meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349277' posts_per_page=4 post_type=property
bool(false)
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, 1710471289
ffd_listing_title, 1515 Union Street #5F, San Francisco, CA, 94123
ffd_mls_id, 422710140
ffd_salesforce_id, a0E8W00000a6kZfUAI
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 41
address2__c, 1515 Union Street #5F, San Francisco, CA, 94123
pba__address_pb__c, 1515 Union Street #5F, 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] www.unionhousesf.com
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Ice Maker;Self/Cont Clean Oven;Built-In Refrigerator
architectural_style__c, Contemporary;Modern/High Tech;Traditional
bath_features__c, Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
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, 2023-01-07T20:46:28.000+0000
days_on_market__c, 432
dom__c, 409
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 1 bedroom, 1 bathroom home includes everything a discerning buyer would expect from a luxury residential development: European wide-plank oak flooring, large closets, chef's kitchen with white quartz countertops and backsplashes, and high end appliances including Miele 4-burner gas cook-top, stove, dishwasher & refrigerator. Oversized picture frame windows look out to panoramic city views of iconic Russian Hill. Amenities include a doorman, a beautifully appointed lobby, and a warmly designed guest reception area with a gas fireplace. Residents also have access to an expansive outdoor communal rooftop lounge and barbecue area which offers stunning direct views of the Golden Gate Bridge and the Palace of Fine Arts - wonderful for entertaining.
district__c, SF District 7
driveway_sidewalks__c, Gated,Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
exterior_features__c, BBQ Built-In;Fire Pit
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,Maintenance Grounds,Sewer,Trash,Water
pba__hoafees__c, 1230
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Union House Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-03-15T02:46:30.000+0000
pba__latitude_pb__c, 37.798185
pba__latitude_property__c, 37.798185
laundry_features__c, Inside Room;Hookups Only
listed_date__c, 2023-01-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andres
pba__listing_agent_lastname__c, Ardila
listing_agent_mls_id__c, 815676
ffd_listingagentname, Andy Ardila
listing_agent_number__c, 1073945
listing_co_agent_mls_id__c, 810541
listing_co_agent_number__c, 1046798
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=QXqibV792iE&mls=1
pba__longitude_pb__c, -122.424301
mls_id__c, 422710140
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Marble;Dual Flush Toilet
master_property__c, a0O1I000009s6IUUAY
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-01-07
open_house_end__c, 2024-03-16T15:00:00.000+0000
open_house_start__c, 2024-03-16T13:00:00.000+0000
original_price__c, 1195000
overall_days_on_market__c, -81455
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1398.47
pba__propertytype__c, Condominium
ListingId, a0E8W00000a6kZfUAI
road_surface_type__c, Paved
room_type__c, Kitchen;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 783
size__c, 783
pba__state_pb__c, CA
stories__c, 8
pba__street_pb__c, Union
subdist__c, Cow Hollow
ffd_name, 1515 Union Street #5F, San Francisco, CA, 94123
view__c, City;City Lights;San Francisco;Hills
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2020
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530566876-1.jpg