meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329611' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15725
[post_author] => 4
[post_date] => 2018-11-02 19:54:46
[post_date_gmt] => 2018-11-02 19:54:46
[post_content] => Where Biff met Buffy and they rented their first apartment so they could jog to Crossfit together. Marina Green, yacht clubs, Ft. Mason, and front-row views from the Golden Gate Bridge to Alcatraz and the East Bay. This is as north as San Francisco goes.
[post_title] => Marina
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => marina-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 08:36:17
[post_modified_gmt] => 2024-03-28 15:36:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15725
[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, 3208 Pierce Street #404, San Francisco, CA, 94123
ffd_mls_id, 423724425
ffd_salesforce_id, a0E8W00000bEtNBUA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 16
address2__c, 3208 Pierce Street #404, San Francisco, CA, 94123
pba__address_pb__c, 3208 Pierce Street #404, San Francisco, CA, 94123
agent_only_remarks__c, Call/text Jorge for showings 305.218.7598. Lowest PSF in the Marina! Legal address is 3208 Pierce street and 2298 Lombard street (same APN). Listing agent related to seller. Tax records say 1100 sqft 1 bed plus den. Marketed and lives like 2 bedroom. Disclosures upon request.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 2007
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jorge Hidalgo
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-02T11:48:39.000+0000
days_on_market__c, 244
dom__c, 11
ffd_description_pb, Lowest priced 2 bed in the Marina! Stunning top floor corner condo steps away from Chestnut Street shops. With its split-level floor plan and abundant natural light, this unit offers a modern and airy home suitable for entertaining and relaxation. The open living spaces on the top floor feature high ceilings, wide plank flooring, skylight, half-bath, city views, and partial Golden Gate Bridge views from the balcony. The kitchen features newer appliances with eat-in counter seating while the fireplace adds a cozy touch. Work from the desk or turn the space into a bar, kids play area, pet pen, or pantry. The lower level showcases a large primary suite with additional balcony, custom closets, Hunter Douglas shades, in-unit W/D, and luxurious rain shower. The flexible layout of the second bedroom/den allows for endless lifestyle options. Large private storage room, one-car parking, elevator, and zen shared courtyard complete this retreat in the city bustle. Walkable to Union Street, The Presidio, Fort Mason, and Crissy Field.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room
hoa_fee_includes__c, Common Areas,Elevator,Insurance,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 919
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2298 Lombard Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Wall Furnace;Fireplace(s)
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-11-01T21:47:22.000+0000
pba__latitude_pb__c, 37.799729
pba__latitude_property__c, 37.799729
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-01-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Julianne
pba__listing_agent_lastname__c, Louie
listing_agent_mls_id__c, 808122
ffd_listingagentname, Julianne Louie
listing_agent_number__c, 1031017
listing_co_agent_mls_id__c, 817037
listing_co_agent_number__c, 1075945
listing_co_office_mls_id__c, HELM
listing_co_office_name__c, Helm Real Estate
listing_co_office_number__c, 27303
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 1198000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=L5nfFirHNpG
pba__longitude_pb__c, -122.439132
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 423724425
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001ViSuUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-02
original_price__c, 1198000
overall_days_on_market__c, -81509
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2023-03-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1136.36
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEtNBUA0
sale_date__c, 2023-04-12
sale_price__c, 1250000
selling_agent_mls_id__c, 803502
selling_agent_number__c, 803502
selling_co_agent_mls_id__c, 810769
selling_co_agent_number__c, 1047912
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1100
size__c, 1100
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Pierce
subdist__c, Marina
ffd_name, 3208 Pierce Street #404, San Francisco, CA, 94123
view__c, City;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2007
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530585346-1.jpg
_yoast_indexnow_last_ping, 1698876686