meta_query='key:subdist__c;value:West Portal|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375395' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15138
[post_author] => 4
[post_date] => 2018-10-31 23:34:48
[post_date_gmt] => 2018-10-31 23:34:48
[post_content] => Stroll down West Portal Avenue -- the heart of this charming west-side neighborhood -- and you might feel like you’ve stepped back in time. Many shops and restaurants have been in operation for decades. The houses are spacious and many are detached from their neighbors, but you’ll feel welcome and at home.
[post_title] => West Portal
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => west-portal
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:01:44
[post_modified_gmt] => 2024-03-19 20:01:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15138
[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, 1713236228
ffd_listing_title, 270 Claremont Boulevard, San Francisco, CA, 94127
ffd_mls_id, 424020923
ffd_salesforce_id, a0EUd000001f2i2MAA
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 270 Claremont Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 270 Claremont Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, As Is Probate Sale w/out warranties expressed or implied. No Death in property, Sale subject to the Notice of Proposed Action, Buyer shall pay transfer tax and costs to bring property into compliance with water/energy/smoke/carb ordinances. Escrow opened with Gerrie at Chicago. Disclosures at disclosures.io. Rooms down are not warranted.
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-04-10
ffd_createddate, 2024-04-05T16:47:19.000+0000
days_on_market__c, 10
dom__c, 10
ffd_description_pb, Location, Location, Location! Just around the corner from the bustling West Portal business district, this partially detached 6 room, 2-bedroom, 1-bath, 1400+ sqft home is perfectly situated. Boasting a formal dining room, a spacious living room, a cozy breakfast nook, a practical galley kitchen, and a generously sized pantry, and bonus rooms down this residence offers a comfortable layout. Situated conveniently near the Light Rail Station and West Portal's popular shops and restaurants, the location couldn't be more ideal. As you explore further, you'll discover bonus rooms, a laundry area, Storage areas, and an additional bath behind and alongside the garage. With a bit of vision and some elbow grease, this hidden gem has the potential to become the talk of the neighborhood. Don't miss the opportunity to transform this property into your dream home.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-16T02:47:08.000+0000
pba__latitude_pb__c, 37.741181
pba__latitude_property__c, 37.741181
laundry_features__c, In Basement
listed_date__c, 2024-04-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pat
pba__listing_agent_lastname__c, Rock
listing_agent_mls_id__c, 804454
ffd_listingagentname, Pat Rock
listing_agent_number__c, 166014012
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1348000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.465068
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 424020923
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-05
original_price__c, 1348000
overall_days_on_market__c, -81909
parking_access__c, Tandem
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 960.11
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001f2i2MAA
room_type__c, Storage;Laundry;Dining Room;Family Room;Other
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 1404
size__c, 1404
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Claremont
subdist__c, West Portal
ffd_name, 270 Claremont Boulevard, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530754856-1.jpg
