meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319113' 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
(
)
)
ffd_listing_title, 251 Harold Avenue, San Francisco, CA, 94112
ffd_mls_id, 422692213
ffd_salesforce_id, a0E8W00000YZBWDUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 251 Harold Avenue, San Francisco, CA, 94112
pba__address_pb__c, 251 Harold Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Offers as they come. For showings outside scheduled open house times, contact listing agent. DO NOT USE SHOWING TIME. Buyers encouraged to research permitted status of cottage to their satisfaction. Pre-escrow opened w/ORTC Mia McDowell, #0219030541-MM, most convenient for sellers to retain. Offer to be presented on SFAR contract, with Pre-Approval Ltr and proof of funds to close. If waiving contingencies, submission of signed disclosures and Buyer's agent AVID with offer encouraged.
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Bungalow
bath_features__c, Shower Stall(s);Tile;Stone
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1929
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-10-05
cooling__c, None
ffd_createddate, 2022-09-07T15:47:34.000+0000
days_on_market__c, 315
dom__c, 29
ffd_description_pb, This charming fully vacant home and cottage has it all. In main house 2 bedrooms, 2 fully renovated baths, lovely updated kitchen with granite counter tops, in-unit laundry and a private work-from-home space or third bedroom. Complementing this lovely home is a well appointed 2 bedroom detached bonus Cottage, with separate entrance, updated kitchen and in-unit laundry. The two detached homes are connected by a tranquil shared garden. Unique opportunity for a family compound or attractive investment property. Great location - steps away from the vibrant Ocean Avenue corridor, Whole Foods, Philz Coffee and Beeps, serving the City's best burgers! Amazing transit access, walking distance to MUNI K line and Balboa BART. Convenient access to 280 Freeway for a speedy commute to the entire Bay Area. Very Walkable 84 Walk Score and an 88 Excellent Transit Score.
district__c, SF District 3
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Wire
fireplace_features__c, Living Room;Brick;Gas Starter
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace;Gas
interior_features__c, Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate, 2023-07-13T17:39:10.000+0000
pba__latitude_pb__c, 37.722519
pba__latitude_property__c, 37.722519
laundry_features__c, Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2022-08-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joel
pba__listing_agent_lastname__c, Luebkeman
listing_agent_mls_id__c, 813145
ffd_listingagentname, Joel A Luebkeman
listing_agent_number__c, 1059666
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1199000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.251harold.com/mls
pba__longitude_pb__c, -122.453404
mls_id__c, 422692213
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Low-Flow Toilet(s);Tile;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-09-07
original_price__c, 1199000
overall_days_on_market__c, -81333
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2022-10-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 639.47
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YZBWDUA5
road_surface_type__c, Asphalt
roof__c, Composition
room_type__c, Bonus Room;Laundry;Kitchen;Studio;Living Room;Dining Room;Possible Guest;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2022-10-27
sale_price__c, 1199000
security_features__c, Smoke Detector;Security Gate
selling_agent_mls_id__c, MLSL5087017
selling_agent_number__c, 981366063
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Rise Homes
pba__status__c, Closed
pba__totalarea_pb__c, 1875
size__c, 1875
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Harold
subdist__c, Ingleside
ffd_name, 251 Harold Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Dual Pane Partial;Window Screens;Weather Stripped
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530524191-1.jpg