meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234840' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:49
[post_modified_gmt] => 2018-11-02 19:54:49
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[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, 2724 Lyon Street, San Francisco, CA, 94123
ffd_mls_id, 422624746
ffd_salesforce_id, a0E8W00000VtlYrUAJ
num_of_fireplaces__c, 3
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2724 Lyon Street, San Francisco, CA, 94123
pba__address_pb__c, 2724 Lyon Street, San Francisco, CA, 94123
agent_only_remarks__c, Special Preview 3/4/2022 3:00 - 4:30. Closing up at 4:30 so pls plan accordingly. Showings by Appt. only. No open houses. No lockbox. Pls text Janet for showings and include your name: 415-265-5994, or email: [email protected] Pls Visit: www.2724Lyon.com for more information.
appliances__c, Dishwasher;Disposal;Built-In Gas Oven;Wine Refrigerator;Double Oven;Built-In Refrigerator;Gas Cook Top
bath_features__c, Shower Stall(s);Double Sinks;Skylight/Solar Tube;Stone
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-03-08T19:45:42.000+0000
days_on_market__c, 427
dom__c, 7
ffd_description_pb, Rare Offering! Perfectly positioned at the Presidio's eastern edge, this light-filled 4BD/3.5BA home features bay, Presidio, or garden views from all principal rooms. The floor plan flows indoors to outdoors making it ideal for entertaining and everyday living. The main level features a lovely living room with Presidio views, formal dining room, powder room, and a chef's kitchen open to the bay-view family room with adjacent deck ideal for al fresco dining. The 2nd level has 3 bedrooms and 2 baths including the luxurious master suite with fireplace, sitting area, and bay views. The lower level has a 4th bedroom/family room/media room with a wet bar and an en suite bath. The mud room is entered directly from the garage. The lower level opens to a large deck with a beautifully landscaped, extra-deep southeast garden. 2-car garage, workshop with sink, wine cellar, and multiple storage closets complete this home.
district__c, SF District 7
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Family Room;Primary Bedroom
pba__floortype_pb__c, Carpet;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;MultiUnits
interior_features__c, Skylight(s);Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2023-05-04T10:48:55.000+0000
pba__latitude_pb__c, 37.7960768
pba__latitude_property__c, 37.7960768
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-03-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Janet
pba__listing_agent_lastname__c, Schindler
listing_agent_mls_id__c, 192072
ffd_listingagentname, Janet F Schindler
listing_agent_number__c, 192072
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, 6900000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/684064456
pba__longitude_pb__c, -122.4466794
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 422624746
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub;Double Sinks;Soaking Tub;Stone;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-03-03
original_price__c, 6900000
overall_days_on_market__c, -81145
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-03-10
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
id, a0E8W00000VtlYrUAJ
room_type__c, Storage;Kitchen;Living Room;Dining Room;Family Room;Possible Guest;Workshop;Wine Storage Area;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-03-18
sale_price__c, 7500000
security_features__c, Security Gate
selling_agent_mls_id__c, 804067
selling_agent_number__c, 166013500
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, 3
pba__street_pb__c, Lyon
subdist__c, Cow Hollow
ffd_name, 2724 Lyon Street, San Francisco, CA, 94123
view__c, Park;Garden/Greenbelt;Bay
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530412371-1.jpg
ListingId, a0E8W00000VtlYrUAJ