meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212218' 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, 130 Alhambra Street, San Francisco, CA, 94123
ffd_mls_id, 497966
ffd_salesforce_id, a0E1I00000SlgRMUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 130 Alhambra Street, San Francisco, CA, 94123
pba__address_pb__c, 130 Alhambra Street, San Francisco, CA, 94123
agent_only_remarks__c, www.130Alhambra.com | COVID-19 showings are private & virtual with signed PEAD, preapproval letter and/or proof of funds | For Qs & Disclosures contact Yelena (415) 860-0130 [email protected] | Offers on SFAR purchase contract | Finished&unfinished tot sqft per graphic artist 2,755. Buyer to verify sqft & bedrm count | Pre-sale escrow opened w/Mary Ann Bunnell at Lawyers Title Company. Escrow FLNP-0261900205.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;ENERGY STAR Qualified Appliances;Double Oven
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Low-Flow Toilet(s);Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Elena Yanchur
pba__contingentdate__c, 2020-06-22
ffd_createddate, 2020-05-15T10:46:15.000+0000
days_on_market__c, 1160
dom__c, 42
ffd_description_pb, Exquisitely Renovated SFH in the Heart of the Marina District. This stunning 4BD/2BA home lives on a beautiful tree-lined street, next to the Marina Green, Palace of Fine Arts, Chestnut, Lombard, Fillmore and Union Streets. The home's flexible floorplan includes a Spacious LivRm w/wood-burning fireplace, Formal DinRm, Gourmet Kitchen w/Bar Seating, Brand New Deck, Two Full Bathrooms, Large Family Room w/separate entrance & direct access to a Landscaped Garden w/sprinkler system, roses and lemon trees. Home is loaded with new high end designer finishes and appliances, brand new windows, brand new door hardware, custom lighting, refinished original hardwood floors, manicured backyard w/controlled sprinkler system, Nest thermostat & security camera, Schlage keyless entry, new tankless water heater, washer&dryer, lots of storage space. Per Walkscore site, 130 Alhambra location is the Lowest Crime Area, is Walker's and Biker's Paradise and is blessed with Excellent Transit.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:22:21.000+0000
pba__latitude_pb__c, 37.80230317
pba__latitude_property__c, 37.80230317
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-02-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yelena
pba__listing_agent_lastname__c, Laudati
listing_agent_mls_id__c, 809117
ffd_listingagentname, Yelena Laudati
listing_agent_number__c, 1040477
listing_co_agent_mls_id__c, 812662
listing_co_agent_number__c, 1057680
listing_co_office_mls_id__c, COMP4
listing_co_office_name__c, Compass
listing_co_office_number__c, 27592
listing_office_mls_id__c, COMP4
listing_office_name__c, Compass
listing_office_number__c, 27592
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.130alhambra.com/
pba__longitude_pb__c, -122.43863883
pba__lotsize_pb__c, 0.06
lower_level__c, Family Room,Full Bath(s),Master Bedroom
mls_id__c, 497966
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-15
original_price__c, 2995000
overall_days_on_market__c, 108
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1202.13
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlgRMUAZ
room_type__c, Storage;Wine Cellar
sale_date__c, 2020-07-09
sale_price__c, 2825000
selling_agent_mls_id__c, 807487
selling_agent_name__c, John L. Townsend
selling_agent_number__c, 1019637
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, 2350
size__c, 2350
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Alhambra
subdist__c, Marina
ffd_name, 130 Alhambra Street, San Francisco, CA, 94123
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362965-1.jpg
ListingId, a0E1I00000SlgRMUAZ