meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='380864' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, and it's also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1721869904
ffd_listing_title, 351 Louisburg Street, San Francisco, CA, 94112
ffd_mls_id, 424042411
ffd_salesforce_id, a0EUd000002KkIWMA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 351 Louisburg Street, San Francisco, CA, 94112
pba__address_pb__c, 351 Louisburg Street, San Francisco, CA, 94112
agent_only_remarks__c, Price reduction to transparent pricing... Rare Single Family Residence with 2 ADUs. Ground floor ADU is a 2bd/1ba unit with 1 tenant at $2,100/mo (Limited showing during open house only). The 2nd floor unit is vacant 3 bd/2ba. The 3rd floor ADU is vacant 2bd/2ba. Supra lockbox for the 2 vacant units. Please DO NOT Disturb the tenant on the ground floor. Notice of Special Restriction: Owner must occupy one of the units. Buyer to verify sq ft for the building. Please email/text Bill Mar at 415-203-2363 for showing or questions. Pre-Escrow opened with Chicago Title / Nancy Chan. Sellers would appreciate the escrow stays with Chicago Title. Please kindly submit an offer via Homelight (DisclosureIO) Disclosures:https://app.disclosures.io/link/351-Louisburg-Street-mf227xot
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 7
year_build_text__c, 2010
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bill Mar
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-17T18:46:49.000+0000
days_on_market__c, 37
dom__c, 37
ffd_description_pb, Single Family Home built in 2010, with 3 full floor flats and stunning panoramic views! Whether you're seeking a spacious primary residence, an income-generating investment, or live in one and rent out the others - the possibilities are endless with this flexible home. Entertain guests on the rooftop patio with stunning city and mountain views, or enjoy the BBQ in the backyard while relishing the ocean views. Convenience meets comfort with exceptional schools (Lick Wilmerding HS), grocery shopping (Whole Foods), and effortless rental opportunities (City College of San Francisco) all accessible in just minutes. Commuting is a breeze with easy access to HWY 101/280 and public transportation (MUNI & BART stations). Embrace the quintessential San Francisco lifestyle with the best of city living at your doorstep. Don't miss the opportunity to make this exceptional residence your own in this highly desired neighborhood of Ingleside.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-07-25T00:48:30.000+0000
pba__latitude_pb__c, 37.7186785
pba__latitude_property__c, 37.7186785
listed_date__c, 2024-03-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Susie
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 814242
ffd_listingagentname, Susie Lee
listing_agent_number__c, 1065352
listing_co_agent_mls_id__c, 803381
listing_co_agent_number__c, 803381
listing_co_office_mls_id__c, COMP31
listing_co_office_name__c, Compass
listing_co_office_number__c, 27894
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 1698000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4510696
lower_level__c, Bedroom(s),Full Bath(s),Garage,Kitchen
mls_id__c, 424042411
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-06-17
open_house_end__c, 2024-07-28T16:00:00.000+0000
open_house_start__c, 2024-07-28T14:00:00.000+0000
original_price__c, 1750000
overall_days_on_market__c, -81982
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 549.16
price_reduced__c, 1
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002KkIWMA0
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 3092
size__c, 3092
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Louisburg
subdist__c, Ingleside
ffd_name, 351 Louisburg Street, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2010
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530796127-1.jpg