meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209472' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70658
[post_author] => 4
[post_date] => 2018-11-30 20:30:32
[post_date_gmt] => 2018-11-30 20:30:32
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors to the north, 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 Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-30 20:30:32
[post_modified_gmt] => 2018-11-30 20:30:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70658
[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, 651 Palmetto Avenue, San Francisco, CA, 94132
ffd_mls_id, 491443
ffd_salesforce_id, a0E1I00000ITqZnUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 651 Palmetto Avenue, San Francisco, CA, 94132
pba__address_pb__c, 651 Palmetto Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Just reduced from $799,000 to $730.000. We were back and forth with a higher offer, but WE need there to be NO Inspection contingency and No loan contingency....See and download the 8 Disclosure packs, findable in the upper right corner of the Listing under Additional Documents.: Open Sunday, 11 17 2019, 1 to 4pm. Offers any time.
appliances__c, Gas Water Heater;Gas Range;Disposal;Refrigerator;Freestanding Range;Hood Over Range
architectural_style__c, Rustic
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2019-10-14T20:49:43.000+0000
days_on_market__c, 1102
dom__c, 33
ffd_description_pb, 1900 vintage, 828 square foot, detached home, witth 20 foot setback from sidewalk... Updated kitchen and bathroom. Inlaid hardwood floor in dining room and living room.....two car deep, single wide garage, with laundry area included. Large room to the left of the garage... not legal,,, ..Arched windows in living room and dining room/ The second bedroom is smaller than usual, and is directly off the kitchen., as is the main bedroom. ..The bathroom is between the two bedrooms.... The front yard is planted with shrubs.... The onramp from Alemany boulevard to IS 280 soithbound, runs behind the backyard, at an elevated level,, and makes the backyard a bit shorter than it otherwise would be......Junipero Serra Boulevard, northbound....is 1.5 blocks west of 651 Palmetto, and creates a bit of background noise.,... when standing on the sidewalk..... This block of Palmetto is ONE WAY, westbound.... so NO traffic comes onto it from Junipero Serra boulevard. ...
district__c, SF District 3
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Carpet;Vinyl;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-12T15:25:13.000+0000
pba__latitude_pb__c, 37.7104674
pba__latitude_property__c, 37.7104674
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2019-10-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Barry
listing_agent_mls_id__c, 175733
ffd_listingagentname, Jack E Barry
listing_agent_number__c, 175733
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARJ
listing_office_name__c, Barry, REALTORS', J.
listing_office_number__c, 674
pba__listingprice_pb__c, 730000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4701798
pba__lotsize_pb__c, 0.05
lower_level__c, Family Room
mls_id__c, 491443
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 3100
parkingspaces__c, 1
on_market_date__c, 2019-10-14
original_price__c, 799000
overall_days_on_market__c, 63
parking__c, Detached,Auto Door
parking_access__c, Independent
parking_features__c, Detached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2019-11-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 875.6
pba__propertytype__c, Single Family Residence
id, a0E1I00000ITqZnUAL
roof__c, Composition
sale_date__c, 2020-02-04
sale_price__c, 725000
selling_agent_mls_id__c, 666666
selling_agent_name__c, Non Member Sales
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, first natiional realty
pba__status__c, Closed
pba__totalarea_pb__c, 828
size__c, 828
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Palmetto
subdist__c, Ingleside Heights
ffd_name, 651 Palmetto Avenue, San Francisco, CA, 94132
transportation__c, 1 Block
view__c, Garden/Greenbelt;Partial
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/357224-1.jpg
ListingId, a0E1I00000ITqZnUAL