meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337306' 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] => 2023-10-31 10:47:20
[post_modified_gmt] => 2023-10-31 17:47:20
[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, 3239 Webster Street, San Francisco, CA, 94123
ffd_mls_id, 423900075
ffd_salesforce_id, a0E8W00000cq4NKUAY
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3239 Webster Street, San Francisco, CA, 94123
pba__address_pb__c, 3239 Webster Street, San Francisco, CA, 94123
agent_only_remarks__c, **Showing Sunday, 9/10, from 11:00AM - 1:00PM** Also, easy to show by appointment. Note, there is no sign on property. Extraordinary home and garden. Call or email Pattie for showings or questions: 415-309-7836 or [email protected]. Presale escrow open with Kevin Thompson, First American Title.
appliances__c, Disposal;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Marina;French
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1935
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Ceiling Fan(s)
ffd_createddate, 2023-08-31T10:47:55.000+0000
days_on_market__c, 50
dom__c, 50
ffd_description_pb, Nestled just steps from Chestnut Street, this captivating 3BR/3.5BA residence stands as one of the Marina's most elegant homes with an extraordinary park-like garden, a true oasis in the city. The home's ornate French-inspired facade gracefully opens into an expansive floor plan, centered around a peaceful atrium, elegant living room with Palladian windows and fireplace, and the formal dining room. Extensive enhancements have elevated the home's refined livability, including the gourmet's kitchen, upgraded electrical system, refreshed bathrooms, a reconfigured three-car garage, and the addition of a fully equipped kitchenette downstairs-perfect for entertaining and guests. The interior has been thoughtfully refined with white oak flooring, custom interior doors, widened doorways, tailored closet spaces, fresh lighting, and enhanced landscaping, among other improvements. Three spacious bedrooms include the beautiful primary suite with custom walk-in closet, luxurious bath, and walk-out deck overlooking the garden. The lower level unfolds into a living area/media room with direct garden access, kitchenette, office space, inviting guest suite, laundry room. The rear garden is enchanting, useful and park-like, with patio space, a flat lawn, walking path, and a romantic pergola.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Other
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s);Wet Bar
ffd_lastmodifieddate, 2023-10-21T01:47:08.000+0000
pba__latitude_pb__c, 37.8006368
pba__latitude_property__c, 37.8006368
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patricia
pba__listing_agent_lastname__c, Lawton
listing_agent_mls_id__c, 800774
ffd_listingagentname, Patricia A Lawton
listing_agent_number__c, 800774
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 4375000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4347842
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 423900075
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-08-31
open_house_end__c, 2023-10-22T16:30:00.000+0000
open_house_start__c, 2023-10-22T15:30:00.000+0000
original_price__c, 4375000
overall_days_on_market__c, -81691
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
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, 1608.46
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cq4NKUAY
roof__c, Composition;Flat
room_type__c, Office;Kitchen;Atrium;Living Room;Dining Room;Family Room;Other;Media Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 2720
size__c, 2720
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Webster
subdist__c, Marina
ffd_name, 3239 Webster Street, San Francisco, CA, 94123
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1935
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530660222-1.jpg
_yoast_indexnow_last_ping, 1697854182