meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349278' 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, 1718845704
ffd_listing_title, 1515 Union Street #PH3, San Francisco, CA, 94123
ffd_mls_id, 423740941
ffd_salesforce_id, a0E8W00000cJ0m8UAC
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 41
address2__c, 1515 Union Street #PH3, San Francisco, CA, 94123
pba__address_pb__c, 1515 Union Street #PH3, 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;Built-In Gas Range;Built-In Gas Oven;Ice Maker;Built-In Refrigerator
architectural_style__c, Contemporary;Modern/High Tech;Traditional
bath_features__c, Marble
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2020
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Andy Ardila
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-06-02T00:49:55.000+0000
days_on_market__c, 384
dom__c, 361
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. All of the care, meticulous detail, and grandeur of Union House San Francisco are accentuated in the Penthouses. The Union House Penthouses are comprised of five distinct San Francisco Penthouse residences, this premier offering at Union House San Francisco. Featuring multiple window exposures, expansive open-plan layouts, and intimate sitting rooms, these homes are a host's dream, perfect for entertaining large groups or smaller parties. Most of our San Francisco Penthouses include private roof terraces, each with stunning views of the Golden Gate Bridge, San Francisco Bay, and the verdant Marin Headlands.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
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,Management,Security,Sewer,Trash,Water
pba__hoafees__c, 1901
pba__hoafrequency_pb__c, Monthly
hoa_name__c, UNION HOUSE OWNERS ASSOCIATION
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-06-20T00:47:12.000+0000
pba__latitude_pb__c, 37.798185
pba__latitude_property__c, 37.798185
laundry_features__c, Laundry Closet;Cabinets
listed_date__c, 2023-06-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Costello
listing_agent_mls_id__c, 810541
ffd_listingagentname, David S Costello
listing_agent_number__c, 1046798
listing_co_agent_mls_id__c, 815676
listing_co_agent_number__c, 1073945
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, 3695000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/Ro9YGFCootw
pba__longitude_pb__c, -122.424301
mls_id__c, 423740941
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Walk-In Closet;Soaking Tub;Marble;Dual Flush Toilet
master_property__c, a0O1I000009s6IUUAY
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-01
open_house_end__c, 2024-06-22T16:00:00.000+0000
open_house_start__c, 2024-06-22T13:00:00.000+0000
original_price__c, 3695000
overall_days_on_market__c, -81600
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Enclosed,Garage Door Opener,Interior Access,Mechanical Lift,Side-by-Side,Size Limited
parking_type__c, On Site - Assigned (Condo Only)
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, 2085.21
pba__propertytype__c, Condominium
ListingId, a0E8W00000cJ0m8UAC
road_surface_type__c, Paved
room_type__c, Office;Kitchen;Living Room;Dining Room;Possible Guest;Other;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, 1772
size__c, 1772
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Union
subdist__c, Cow Hollow
ffd_name, 1515 Union Street #PH3, San Francisco, CA, 94123
view__c, City;City Lights;Bay;San Francisco;Bridges
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/530627185-1.jpg