meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='371392' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 1735680333
ffd_listing_title, 1534 Alabama 1536 Street, San Francisco, CA, 94110
ffd_mls_id, 423910521
ffd_salesforce_id, a0E8W00000dTtXcUAK
num_of_rooms__c, 8
of_units__c, 2
address2__c, 1534 Alabama 1536 Street, San Francisco, CA, 94110
pba__address_pb__c, 1534 Alabama 1536 Street, San Francisco, CA, 94110
agent_only_remarks__c, Lower unit 1536 is tenant-occupied and requires a minimum of 24 hours notice for showing. Unit 1536 will be only shown during the weekdays. Prefer Tuesday 11-3pm, Wednesday1-3pm, Thursday 10-3Pm, Friday 10-5pm. An unwarranted room and bathroom without kitchen and closet in the garage level is renting out (For storage purpose according to the owner) for $850/month and requiers 48 hours notice for showing. Upper unit 1534 is vacant. Please call/Text Jing Liang to arrange @ 415-713-1283 for showing. Disclosures package is ready upon request. Buyers are advised to do thier own investigation and measurement to verify the living space. Seller has the right to accept and /or reject any and all offers. Please call Jing Liang at (415)713 1283 with questions regarding offers. Offers should include a pre-approval, proof of funds and fully signed disclosures. Prefer Escrow with Janet Lee at Fidelity Title Company on Ocean Ave, SF. Property is back to the market, no fault for the building. Review Offer as come as receive. Thanks for showing!
appliances__c, Gas Water Heater;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Nina Liang
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-09-28T10:53:56.000+0000
days_on_market__c, 460
dom__c, 87
ffd_description_pb, Welcome to an exceptional two-unit building nestled within the heart of Bernal Heights, where modern comforts meet outdoor serenity. Each unit showcases a thoughtfully designed layout, featuring two inviting bedrooms, a well-appointed bathroom, a cozy living room with a fireplace and newly installed bay windows framing natural lights, a spacious kitchen and a dedicated office space. As an added highlight, enter into the spacious flat garden backyard adorned with tress, garden boxes, and outdoor enjoyment. A tandem parking in the garage with a high ceiling and plenty of storage space for the expanding option. Indulge in the city's charm while unwinding with Bernal Hill views visible from the rear of the property; With separate entrances for each unit, privacy and autonomy are seamlessly integrated into this home's design. Easy venture out to Precita Park, Mission, and enjoy a host of nearby cafes, restaurants and markets. Easy access to the Highway 101/280 interchange as well as close to Bart and Caltrain stations. Whether a comfortable home or a savvy reselling opportunity, this property has it all. Upper unit #1534 is vacant; The tenant-occupied lower unit #1536 currently rented for $3,500/month. Don't miss this opportunity to own a prime of San Francisco real Estate.
district__c, SF District 9
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Laminate;Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Natural Gas;Fireplace Insert;Separate
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-02-02T01:49:10.000+0000
pba__latitude_pb__c, 37.747768
pba__latitude_property__c, 37.747768
laundry_features__c, In Common Area;Washer/Dryer Owned
listed_date__c, 2023-08-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jing
pba__listing_agent_lastname__c, Liang
listing_agent_mls_id__c, 811038
ffd_listingagentname, Jing Liang
listing_agent_number__c, 1049405
listing_co_agent_mls_id__c, MLSL5079184
listing_co_agent_number__c, 981336204
listing_co_office_mls_id__c, NTERO-8
listing_co_office_name__c, Intero Real Estate Services
listing_co_office_number__c, 981045461
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 1480000
pba__listingtype__c, Sale
pba__listing_website__c, https://virtualtourcafe.com/mls/3184823
pba__longitude_pb__c, -122.410771
mls_id__c, 423910521
parkingspaces__c, 1
on_market_date__c, 2023-09-28
original_price__c, 1425000
overall_days_on_market__c, -81719
parking_features__c, Attached,Tandem Garage
patio_and_porch_features__c, Uncovered Deck;Varies by Unit
pba__pendingdate__c, 2023-12-24
price_per_square_foot__c, 613.64
pba__propertytype__c, Duplex
ListingId, a0E8W00000dTtXcUAK
roof__c, Tar/Gravel
sale_date__c, 2024-01-31
sale_price__c, 1350000
security_features__c, Smoke Detector;Fire Extinguisher;Secured Access;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 811038
selling_agent_number__c, 1049405
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2200
size__c, 2200
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Alabama
subdist__c, Bernal Heights
ffd_name, 1534 Alabama 1536 Street, San Francisco, CA, 94110
view__c, City;City Lights;Hills
website_property_type__c, Duplex
window_features__c, Dual Pane Full;Bay Window(s);Window Screens;Varies by Unit
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530679186-1.jpg