meta_query='key:subdist__c;value:West Portal|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220028' 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
(
)
)
ffd_listing_title, 227 Vicente Street, San Francisco, CA, 94127
ffd_mls_id, 421573028
ffd_salesforce_id, a0E1I00000UV487UAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 227 Vicente Street, San Francisco, CA, 94127
pba__address_pb__c, 227 Vicente Street, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Thursday 7/22 by 12:00 Noon. Please stipulate that buyer's initial deposit will be in escrow within ONE business day and ONLY use the SFAR Purchase Contract. Escrow opened with First American Title, Liz Paglinawan 650-245-6799. Do NOT Send Text Messages. Please send email to [email protected] for ALL showing requests as we are not using Showing Time. Buyer's agents must provide pre-approval letter or POF before viewing the home and all visitors must wear masks. 3D Tour available on the MLS, just click on visual media.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Refrigerator
architectural_style__c, Traditional;Mediterranean
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-15T15:46:54.000+0000
days_on_market__c, 734
dom__c, 7
ffd_description_pb, Storybook Mission-style home nestled on wonderful tree-lined block, just steps to West Portal Village! Charming garden entrance w/two-sided brick staircase leads to notable arched doorway & into impressive foyer w/huge skylight & coat closet. Exquisite formal living rm w/dining area boasts fireplace w/gorgeous mantel, plaster moldings, two arched windows & hardwood floors. Magnificent gourmet kitchen showcases all stainless steel appliances incl Bosch gas range & Sub-Zero refrigerator, custom cabinets w/pull-out drawers, Carrara quartz counters & breakfast area. This floor incl's 2 large bedrooms w/classic French doors & big closets, sitting rm & terrific remodeled full bath w/soaking tub & sep walk-in shower. Lower level features a comfortable family rm w/access to the yard, 3rd bedroom/office w/private entrance, stunning remodeled bath w/dual vanity sink & walk-in shower, huge laundry rm, wine rm. Wrap-around landscaped backyard w/tradesman's entrance, patio & mature plants & trees!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
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-25T15:57:27.000+0000
pba__latitude_pb__c, 37.739775
pba__latitude_property__c, 37.739775
laundry_features__c, Inside Room;Washer Included;Dryer Included;Cabinets
listed_date__c, 2021-07-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Herrera II
listing_agent_mls_id__c, 404547
ffd_listingagentname, Andrew Herrera II
listing_agent_number__c, 404547
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.AndrewHerrera.com
pba__longitude_pb__c, -122.468809
lower_level__c, Family Room,Full Bath(s),Street Entrance
mls_id__c, 421573028
main_level__c, Master Bedroom;Bedroom(s);Living Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-15
original_price__c, 1995000
overall_days_on_market__c, 184
parking_access__c, Independent
parking_features__c, Attached,Covered,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2021-07-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1024.41
pba__propertytype__c, Single Family Residence
id, a0E1I00000UV487UAD
roof__c, Foam
room_type__c, Sun Room;Laundry;Kitchen;Living Room;Master Bathroom;Baths Other;Dining Room;Family Room;Master Bedroom;Wine Storage Area
sale_date__c, 2021-08-12
sale_price__c, 2350000
selling_agent_mls_id__c, 802219
selling_agent_number__c, 802219
selling_co_agent_mls_id__c, 813425
selling_co_agent_number__c, 1061208
selling_co_office_mls_id__c, CGL06
selling_co_office_name__c, Corcoran Global Living
selling_co_office_number__c, 28275
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2294
size__c, 2294
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vicente
subdist__c, West Portal
ffd_name, 227 Vicente Street, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530283532-1.jpg
ListingId, a0E1I00000UV487UAD