meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='321371' 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, 1747 Chestnut Street, San Francisco, CA, 94123
ffd_mls_id, 422695275
ffd_salesforce_id, a0E8W00000ZLpNnUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 10
of_units__c, 0
address2__c, 1747 Chestnut Street, San Francisco, CA, 94123
pba__address_pb__c, 1747 Chestnut Street, San Francisco, CA, 94123
agent_only_remarks__c, Classified as 3 houses on lot by SFAR. Call Jeffrey Silver 415-531-6905 or Michael Halpren 650-430-4568 for private showings (48 Magnolia) Cottage is tenant occupied. Tenant is protected and pays $800/M. Cottage can be seen subject to Offer. Buyer to investigate 3R reports. Escrow with Michael Schmidt FAT. https://app.disclosures.io/link/1747-Chestnut-Street-pv5oo6np Offer Date: November 1st, by 1Pm.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Cottage;Mid-Century
bath_features__c, Tile;Jetted Tub
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1952
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-11-01
ffd_createddate, 2022-10-24T18:52:37.000+0000
days_on_market__c, 285
dom__c, 15
ffd_description_pb, Prime Marina Location overlooking Moscone Park! Built in 1952, this Marina Compound Oasis is centrally located near shopping, restaurants, and parks. Within biking distance to the Palace of Fine Arts, Crissy Field and the Marina Greens. 1747 Chestnut St is 2 units. Upper Unit has views of the Golden Gate Bridge and Moscone Park from the primary bedroom and living room. The large roof deck adjacent to primary bedroom has eastern city views. Lower Unit was used as an office and has no address. It can be considered a studio 1 bedroom, 1 bathroom, two closets and kitchenette. The lot also has a 1 bed / 1 bath original cottage built in 1947 with its own entrance at 48 Magnolia St. A large courtyard with Palm and Magnolia trees separates the two dwellings. Come tour this must see property!!
district__c, SF District 7
driveway_sidewalks__c, Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:46:36.000+0000
pba__latitude_pb__c, 37.8012026
pba__latitude_property__c, 37.8012026
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2022-08-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Silver
listing_agent_mls_id__c, 808301
ffd_listingagentname, Jeffrey A Silver
listing_agent_number__c, 1033217
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2999000
pba__listingtype__c, Sale
pba__listing_website__c, http://1747chestnutst.com
pba__longitude_pb__c, -122.4320916
lower_level__c, Bedroom(s),Full Bath(s),Garage,Kitchen,Street Entrance
mls_id__c, 422695275
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Bidet;Closet;Window;Sauna
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-10-07
original_price__c, 2999000
overall_days_on_market__c, -81363
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2022-11-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 975.88
pba__propertytype__c, 3+ Houses on Lot
ListingId, a0E8W00000ZLpNnUAL
roof__c, Composition
room_type__c, Storage;Office;Kitchen;Living Room;Guest Quarters;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-12-23
sale_price__c, 3520000
selling_agent_mls_id__c, 811367
selling_agent_number__c, 1051154
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3607
size__c, 3607
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Chestnut
subdist__c, Marina
ffd_name, 1747 Chestnut Street, San Francisco, CA, 94123
view__c, City Lights;Garden/Greenbelt;Bay;San Francisco;Golden Gate Bridge
website_property_type__c, 3+ Houses on Lot
pba__yearbuilt_pb__c, 1952
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530529807-1.jpg