meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340722' 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] => 2023-10-31 09:33:26
[post_modified_gmt] => 2023-10-31 16:33:26
[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
(
)
)
_yoast_indexnow_last_ping, 1701922593
ffd_listing_title, 253 Lee 255 Avenue, San Francisco, CA, 94112
ffd_mls_id, 423918329
ffd_salesforce_id, a0E8W00000dwZ0VUAU
num_of_rooms__c, 9
of_units__c, 3
address2__c, 253 Lee 255 Avenue, San Francisco, CA, 94112
pba__address_pb__c, 253 Lee 255 Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Bonus unit on the third floor may be unwarranted, no representation, or guarantee is made. Easy to show with Supra eKey, call Seller's agent for instructions. The Seller is willing to carry a first loan with 30% down.
appliances__c, Dishwasher;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, A-Frame
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-10-24T21:48:18.000+0000
days_on_market__c, 44
dom__c, 44
ffd_description_pb, This is a great opportunity that you wouldn't want to miss! We have two recently renovated units available, both of which have spacious 2 bedrooms and 1 bathroom. The open layout seamlessly connects the living, dining, and kitchen areas, creating a comfortable living space. The kitchens have been upgraded with new cabinets, granite countertops, and modern stainless steel appliances. You'll also have the convenience of an in-unit washer and dryer hookup, making laundry a breeze. The units feature easy-to-maintain laminate floors, ensuring a hassle-free living experience. In addition to the two units, there is also a bonus unit on the third floor with 1 bedroom and 1 bathroom, and it has its own private entrance. Located near Ocean Avenue, this property offers easy access to a variety of amenities. You'll be close to restaurants, shops, cafes, public transportation, San Francisco City College, and more. It's a great location that offers convenience and a vibrant community. Don't miss out on the opportunity to live in a well-appointed, upgraded space in this fantastic location. Contact us now to schedule a viewing and secure your spot in this amazing property.
district__c, SF District 3
electric__c, 220 Volts
external_listing__c, 1
pba__floortype_pb__c, Laminate;Tile
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-12-07T03:48:19.000+0000
pba__latitude_pb__c, 37.72286
pba__latitude_property__c, 37.72286
laundry_features__c, Washer/Dryer Hookups;In Each Unit
listed_date__c, 2023-10-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nancy
pba__listing_agent_lastname__c, Ruiz
listing_agent_mls_id__c, 223826
ffd_listingagentname, Nancy L Ruiz
listing_agent_number__c, 223826
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF4
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 28140
pba__listingprice_pb__c, 1594000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.454427
mls_id__c, 423918329
parkingspaces__c, 0
on_market_date__c, 2023-10-23
original_price__c, 1725000
overall_days_on_market__c, -81744
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 699.12
pba__propertytype__c, Duplex
ListingId, a0E8W00000dwZ0VUAU
roof__c, Shingle
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2280
size__c, 2280
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Lee
subdist__c, Ingleside
ffd_name, 253 Lee 255 Avenue, San Francisco, CA, 94112
website_property_type__c, Duplex
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530696531-1.jpg