meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238000' 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, 26 Avila Street, San Francisco, CA, 94123
ffd_mls_id, 422685244
ffd_salesforce_id, a0E8W00000YY8ehUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 26 Avila Street, San Francisco, CA, 94123
pba__address_pb__c, 26 Avila Street, San Francisco, CA, 94123
agent_only_remarks__c, No sign on property. Agent is co-owner. Please contact agent for viewing and alarm code at 415-425-0158. Disclosures available at https://app.disclosures.io/link/26-Avila-Street-sknirkg4. Pre-escrow opened with Sam Saravia at Fidelity National Title, escrow #FSFM-0062200467. Offers due Tuesday 23rd of August at 11AM.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Compactor;Built-In Refrigerator
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s);Bidet;Jetted Tub;Sunken Tub;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-08-11T18:47:15.000+0000
days_on_market__c, 342
dom__c, 12
ffd_description_pb, Three bedroom, three bath home in the Marina, steps from Chestnut Street. The main floor with original crown moulding and designer stain glass windows boasts a living room, dining room, kitchen with eat-in area, two bedrooms, two full baths and a radiant sun room. The upstairs with large master bedroom, seating area and master bath. Expansive garage with laundry, storage, two car parking and access to a quiet yard. Hardwood floors throughout, lots of lights. Walk score of 97, just steps from Chestnut Street's restaurants, stores and bars as well as the Palace of Fine Arts, Marina Green and Presidio.
district__c, SF District 7
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
height_limit__c, Unknown
ffd_lastmodifieddate, 2023-07-13T17:29:42.000+0000
pba__latitude_pb__c, 37.800721
pba__latitude_property__c, 37.800721
laundry_features__c, In Garage;Ground Floor;Washer Included;Dryer Included;Sink
listed_date__c, 2022-07-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Laurent
pba__listing_agent_lastname__c, Martini
listing_agent_mls_id__c, 807947
ffd_listingagentname, Laurent A Martini
listing_agent_number__c, 1029052
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PCIF
listing_office_name__c, Pacific Realty
listing_office_number__c, 1666
pba__listingprice_pb__c, 2800000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.44015
lower_level__c, Garage
mls_id__c, 422685244
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Tile;Bidet;Jetted Tub;Window;Sunken Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-08-11
original_price__c, 2800000
overall_days_on_market__c, -81306
parking_access__c, Tandem
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-08-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YY8ehUAD
road_surface_type__c, Paved
roof__c, Tar/Gravel;Composition;Shingle
room_type__c, Storage;Office;Sun Room;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-09-12
sale_price__c, 2823000
security_features__c, Smoke Detector;Carbon Mon Detector;Security System Leased
selling_agent_mls_id__c, 800625
selling_agent_number__c, 800625
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Avila
subdist__c, Marina
ffd_name, 26 Avila Street, San Francisco, CA, 94123
view__c, San Francisco
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane Partial;Window Screens
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530511419-1.jpg