meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217946' 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, 142 Brighton Avenue, San Francisco, CA, 94112
ffd_mls_id, 421533115
ffd_salesforce_id, a0E1I00000TyAzSUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 142 Brighton Avenue, San Francisco, CA, 94112
pba__address_pb__c, 142 Brighton Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Probate Sale, not subject to court confirmation. Offers as they come. Property sold in AS IS present physical condition. Agents are advised to inform their buyers. All inspections are advised. Information provided deemed reliable, but not warranted by either Administrator nor Agent. Administrator & Attorney reserves the right to accept or reject any offers.
appliances__c, Free Standing Gas Oven
architectural_style__c, A-Frame
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-16
cooling__c, Central
ffd_createddate, 2021-04-12T10:47:45.000+0000
days_on_market__c, 828
dom__c, 43
ffd_description_pb, Large house, contractors special, lots of potential for creative buyer. Sits on 2896 sq ft. of deep level lot, and 1440 Sq ft., living area, comprising of 4 Rooms upper level, lower level - Eat in Kitchen, bath, large foyer and a family room. Can be a good project with benefits. Good location 142 Brighton Avenue off Ocean Avenue, with cross Street Holloway Avenue. Blocks from your neighborhood Wholefoods, Other Markets, City College of SF, Library, Target Store, transportation, freeway and much more. Administrator very motivated.
district__c, SF District 3
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
height_limit__c, Unknown
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:48:21.000+0000
pba__latitude_pb__c, 37.7208357
pba__latitude_property__c, 37.7208357
laundry_features__c, Cabinets
listed_date__c, 2021-03-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, McGary
listing_agent_mls_id__c, 900297
ffd_listingagentname, John H McGary
listing_agent_number__c, 900297
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RESE
listing_office_name__c, J. M. Real Estate Services
listing_office_number__c, 1831
pba__listingprice_pb__c, 882000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4549299
lower_level__c, Dining Room,Full Bath(s),Kitchen,Living Room,Street Entrance
mls_id__c, 421533115
master_bathroom_features__c, Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-04-12
original_price__c, 882000
overall_days_on_market__c, 110
parking_features__c, No Garage
pba__pendingdate__c, 2021-05-31
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 612.5
pba__propertytype__c, Single Family Residence
id, a0E1I00000TyAzSUAV
road_surface_type__c, Asphalt
sale_date__c, 2021-05-31
sale_price__c, 882000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Richardson
pba__status__c, Closed
pba__totalarea_pb__c, 1440
size__c, 1440
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Brighton
subdist__c, Ingleside
ffd_name, 142 Brighton Avenue, San Francisco, CA, 94112
view__c, City Lights
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530208392-1.jpg
ListingId, a0E1I00000TyAzSUAV