meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221499' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70652
[post_author] => 4
[post_date] => 2018-11-30 20:30:25
[post_date_gmt] => 2018-11-30 20:30:25
[post_content] => A thin sliver of streets as north as you can be on the west side of town without being in the Presidio. Compared to the Richmond, you'll generally find larger homes on shorter streets with select homes opening up to back-door Presidio access. West Clay is an exclusive enclave of special homes within a special neighborhood.
[post_title] => Lake Street
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lake-street
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 13:15:32
[post_modified_gmt] => 2024-04-09 20:15:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70652
[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, 127 2nd Avenue, San Francisco, CA, 94118
ffd_mls_id, 421591392
ffd_salesforce_id, a0E8W00000V0jMCUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 12
of_units__c, 0
address2__c, 127 2nd Avenue, San Francisco, CA, 94118
pba__address_pb__c, 127 2nd Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Virtually Tour at https://MajesticFun127.com Schedule a private showing by emailing [email protected] View Disclosures: https://app.disclosures.io/link/127-2nd-Avenue-6vee0tvt For more information, contact Wendy Storch at 415.519.6091. 1 Car Garage will fit small vehicle (smart car or mini. currently used as gym/play room). The driveway can fit 3 additional small/medium size vehicles.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-10-11T10:49:46.000+0000
days_on_market__c, 646
dom__c, 21
ffd_description_pb, Everything is generous about this airy, expansive, & substantially revised Victorian. Masterfully conceived to contain all the elements of a life well-lived, a true SF classic. Set on an extra large lot, possessed of impressive stature & down to earth comfort & ease. With beautifully articulated detailing intact, the exquisite customization results in 3 levels of living, open to deck & deep lush garden. Formal entry, parlor & dining give way to the great room & spectacular kitchen, designed for casual, all-inclusive modern livability. Thoughtfully organized to accommodate family gatherings, study, play & large-scale entertaining all w/ a wall of gorgeous windows inviting in glorious light. 4 beds & 2 baths up, an impressive suite, w/marble clad, sky-lit bath creating a sense of spa-like calm. Media room, 5th bed suite, laundry, & storage at garden level anchor the home. Garage for small car, 3-car gated PKG in drive. Sublime walkability to world class nature, shopping & dining.
district__c, SF District 1
driveway_sidewalks__c, Gated,Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Other
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T16:04:11.000+0000
pba__latitude_pb__c, 37.786289
pba__latitude_property__c, 37.786289
laundry_features__c, Washer Included;Dryer Included;Sink
listed_date__c, 2021-10-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy M Storch
listing_agent_number__c, 803139
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, 5850000
pba__listingtype__c, Sale
pba__listing_website__c, https://MajesticFun127.com
pba__longitude_pb__c, -122.460692
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 421591392
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2021-10-11
original_price__c, 5850000
overall_days_on_market__c, 83
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Garage Facing Front,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2021-11-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1407.59
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0jMCUAZ
road_surface_type__c, Asphalt
room_type__c, Storage;Office;Bonus Room;Laundry;Living Room;Master Bathroom;Dining Room;Attic;Master Bedroom;Media Room
sale_date__c, 2021-11-30
sale_price__c, 5750000
selling_agent_mls_id__c, A317561
selling_agent_number__c, 981090870
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, 4085
size__c, 4085
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 2nd
subdist__c, Lake Street
ffd_name, 127 2nd Avenue, San Francisco, CA, 94118
view__c, City;City Lights
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530337946-1.jpg
ListingId, a0E8W00000V0jMCUAZ