meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338815' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15723
[post_author] => 4
[post_date] => 2018-11-02 19:54:42
[post_date_gmt] => 2018-11-02 19:54:42
[post_content] => Where palatial estates actually are palatial estates. Le Petit Trianon, to name just one. Notable homes by notable San Francisco architects like Bernard Maybeck, Ernest Coxhead, Julia Morgan, William F. Knowles, and Willis Polk. Walk north to the Presidio & Golden Gate National Recreation Area. Shop a few blocks south in Laurel Village. Life is good.
[post_title] => Presidio Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => presidio-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-07 14:15:37
[post_modified_gmt] => 2024-03-07 22:15:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15723
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 3456 Sacramento Street #2, San Francisco, CA, 94118
ffd_mls_id, 423749062
ffd_salesforce_id, a0E8W00000cpeqyUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 5
address2__c, 3456 Sacramento Street #2, San Francisco, CA, 94118
pba__address_pb__c, 3456 Sacramento Street #2, San Francisco, CA, 94118
agent_only_remarks__c, Three homes for sale including (2) three bedroom TIC residences and (1) two level, four bedroom condominium penthouse residence with private elevator. Buyer to verify SQFT. Call agents for showings.
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Andrew J Warren
pba__contingentdate__c, 2023-09-14
cooling__c, None
ffd_createddate, 2023-08-26T02:48:56.000+0000
days_on_market__c, 28
dom__c, 23
ffd_description_pb, Welcome to the prestigious neighborhood of Presidio Heights, where luxury meets convenience. We are delighted to present our (two) newly built three-bedroom, two-bathroom tenancy-in-common residences, designed to offer the utmost comfort, style, and sophistication. Nestled in the heart of one of the most sought-after locations in the city, this is an opportunity to experience a truly exceptional living experience. These residences feature open floor plans seamlessly combining the living, dining, and kitchen areas, creating a wonderful setting for entertaining guests or spending quality time with family. The abundance of natural light floods the space, enhancing the warm and inviting atmosphere.
district__c, SF District 7
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood;See Remarks
pba__hoafees__c, 485
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-09-21T00:46:52.000+0000
pba__latitude_pb__c, 37.78811
pba__latitude_property__c, 37.78811
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2023-06-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_mls_id__c, 807776
listing_co_agent_number__c, 1025907
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1469000
pba__listingtype__c, Sale
pba__listing_website__c, https://presidiomodern.com
pba__longitude_pb__c, -122.44958
mls_id__c, 423749062
master_bathroom_features__c, Double Sinks
monthly_parking_fees__c, 350
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-23
original_price__c, 1469000
overall_days_on_market__c, -81683
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site - Lease Available (Condo Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-09-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-20T10:57:55.000+0000
price_per_square_foot__c, 1373.39
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000cpeqyUAA
room_type__c, Kitchen;Living Room;Guest Quarters;Family Room;Primary Bathroom
sale_date__c, 2023-09-20
sale_price__c, 1600000
selling_agent_mls_id__c, 802876
selling_agent_number__c, 802876
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Jackson Fuller Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1165
size__c, 1165
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sacramento
subdist__c, Presidio Heights
ffd_name, 3456 Sacramento Street #2, San Francisco, CA, 94118
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530632705-1.jpg