meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331950' 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, 45 Avila Street, San Francisco, CA, 94123
ffd_mls_id, 423735186
ffd_salesforce_id, a0E8W00000bc3gPUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 45 Avila Street, San Francisco, CA, 94123
pba__address_pb__c, 45 Avila Street, San Francisco, CA, 94123
agent_only_remarks__c, www.45Avila.com Please contact [email protected] 415-902-9502 for showings.
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kate D Tomassi
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-01T10:48:46.000+0000
days_on_market__c, 79
dom__c, 7
ffd_description_pb, Jewel Box Marina Home on coveted Avila Street. This home features 3 spacious bedrooms & 3 full bathrooms with a large 2 car garage & landscaped backyard. A+ location steps from Chestnut Street. This beautifully remodeled 3 bedroom 3 bath home offers everything the discerning buyer is looking for. Impeccably remodeled in 2001, with luxurious and timeless finishes. The gorgeous chef's kitchen is appointed with the highest quality finishes and appliances. The open concept floor plan is ideal for everyday living and entertaining, with the formal dining room flowing seamlessly into the living room, equipped with gorgeous oak hardwood floors, a wood burning fireplace and amazing natural light. 2 bedrooms and 2 baths are located on the main level. The luxurious primary suite, walk-in closet, and spa-like bath are on the lower level with a fantastic home office and direct access to the lovely rear garden with french doors. The very best of city living, just blocks from the Marina Green, Presidio and fantastic shops and restaurants on Chestnut Street.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:48:23.000+0000
pba__latitude_pb__c, 37.800872
pba__latitude_property__c, 37.800872
laundry_features__c, In Garage;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2023-03-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Monica
pba__listing_agent_lastname__c, Pauli
listing_agent_mls_id__c, 802345
ffd_listingagentname, Monica M Pauli
listing_agent_number__c, 802345
listing_co_agent_mls_id__c, 810756
listing_co_agent_number__c, 1047830
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3395000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.45avila.com
pba__longitude_pb__c, -122.44067
lower_level__c, Full Bath(s),Primary Bedroom
mls_id__c, 423735186
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-05-01
original_price__c, 3395000
overall_days_on_market__c, -81569
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-05-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1532.73
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bc3gPUAQ
room_type__c, Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-05-19
sale_price__c, 3395000
selling_agent_mls_id__c, 807821
selling_agent_number__c, 1027199
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2215
size__c, 2215
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Avila
subdist__c, Marina
ffd_name, 45 Avila Street, San Francisco, CA, 94123
website_property_type__c, Single Family Home
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/530611372-1.jpg