meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215075' 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, 619 Holloway Avenue #4, San Francisco, CA, 94112
ffd_mls_id, 506878
ffd_salesforce_id, a0E1I00000THoEjUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 42
address2__c, 619 Holloway Avenue #4, San Francisco, CA, 94112
pba__address_pb__c, 619 Holloway Avenue #4, San Francisco, CA, 94112
agent_only_remarks__c, This is a regular sale. This condo is a City Second Property through the Mayor's Office of Housing and Community Development. The City has a first rights of refusal period of 45-days after approval of a market rate ratified Purchase Agreement. Buyer is not obligated to use the City Second Loan Program and there are no income restrictions should they not participate in the program. No cost to buyer and no resale restrictions, but this process will lengthen the COE. Please contact listing agent for details and/or questions. Sale of condo excludes the bathroom bidet on the 2nd floor. Email PEAD, then call/text listing agent to schedule private showing as condo is owner occupied. Listing agent IS NOT related to seller.
appliances__c, Gas Range;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1985
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-10-26
ffd_createddate, 2020-09-25T10:49:14.000+0000
days_on_market__c, 1027
dom__c, 136
ffd_description_pb, Convenient location with a City Walk Score: 90. Walking distance to restaurants, businesses, gyms, Target, Whole Foods, and City College on Ocean Avenue. This two-level townhome style condo has 2 bedrooms, 2 full bathrooms, with high ceilings in the open living and dining area accompanied by a wood burning fireplace. Remodeled kitchen, bathrooms, bamboo flooring throughout, and rear patio area with a 1-car attached garage. The City and County of SF holds the right of first refusal. City Second Loan Program is available for qualified buyers on a first come, first served basis. Visit https://sfmohcd.org/current-listings-city-second-program for application and program information.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 2
external_listing__c, 1
pba__floor__c, 2
pba__floortype_pb__c, Bamboo;Tile
hoa_dues__c, 330
hoa_fee_includes__c, Management,Maintenance Exterior,Maintenance Grounds,Water
pba__hoafees__c, 330
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Holloway Terrace Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:35:42.000+0000
pba__latitude_pb__c, 37.721376
pba__latitude_property__c, 37.721376
laundry_appliances__c, Washer/Dryer,In Garage
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-09-24
pba__listing_agent_email__c, mequan@sbcglobal.net
pba__listing_agent_firstname__c, Martin
pba__listing_agent_lastname__c, Quan
listing_agent_mls_id__c, 804116
ffd_listingagentname, Martin E Quan
listing_agent_number__c, 166013571
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, USCI
listing_office_name__c, U S Continental Investment Realty
listing_office_number__c, 2165
pba__listingprice_pb__c, 850000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=FQhGF2RbPe6&mls=1
pba__longitude_pb__c, -122.459712
pba__lotsize_pb__c, 0
mls_id__c, 506878
main_level__c, Full Bath(s);Bedroom(s)
master_property__c, a0O1I00000AnFBhUAN
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-25
original_price__c, 850000
overall_days_on_market__c, 187
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Private,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-02-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 652.6
pba__propertytype__c, Condominium
id, a0E1I00000THoEjUAL
roof__c, Tile
sale_date__c, 2021-02-17
sale_price__c, 827500
selling_agent_mls_id__c, 803830
selling_agent_number__c, 166013092
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Estate Revolution
pba__status__c, Closed
pba__totalarea_pb__c, 1268
size__c, 1268
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Holloway
subdist__c, Ingleside
ffd_name, 619 Holloway Avenue #4, San Francisco, CA, 94112
transportation__c, 2 Blocks
unit_number__c, 4
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1985
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371004-1.jpg
ListingId, a0E1I00000THoEjUAL