meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327289' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15721
[post_author] => 4
[post_date] => 2018-11-02 19:54:38
[post_date_gmt] => 2018-11-02 19:54:38
[post_content] => Marilyn Monroe married Joe DiMaggio in the neighborhood. The rest is history. Welcome to a neighborhood as old as San Francisco, with historic Italian roots, fragrant garlic feasts, and plenty of neighborhood haunts frequented by SF movers and martini-shakers. Here's to you, Herb!
[post_title] => North Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:38
[post_modified_gmt] => 2018-11-02 19:54:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15721
[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, 225 Bay Street #203, San Francisco, CA, 94133
ffd_mls_id, 423726172
ffd_salesforce_id, a0E8W00000bFKLzUAO
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 10
address2__c, 225 Bay Street #203, San Francisco, CA, 94133
pba__address_pb__c, 225 Bay Street #203, San Francisco, CA, 94133
agent_only_remarks__c, Transparent Pricing - 225bay203.com Home is virtually staged. Text Sheldon 415-559-9691 for Temp Code to access the front door to intercom for access to building, Supra Lockbox is placed in front of unit door. Disclosures Link here https://app.disclosures.io/link/225-Bay-Street-203-oqishsix Please text with questions - Sheldon 415-559-9691 or Joe 650-255-9527.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Built-In Refrigerator;Free Standing Electric Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1979
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Joe Benvenuto
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-03-09T18:48:46.000+0000
days_on_market__c, 14
dom__c, 13
ffd_description_pb, Welcome to your new home on Bay Street at the base of Telegraph Hill! This centrally located, spacious, stunning corner unit is the perfect place for you to relax and unwind. Enjoy all the upgrades including newer appliances, carpeting, luxury vinyl floors and stainless appliances! The two bedrooms and two bathrooms provide plenty of space for you to find your own haven. Plus, take advantage of the amazing amenities in this well-run building - a common rooftop deck with panoramic hill views, two common courtyard areas & don't forget about that deeded covered parking spot - secure your vehicle while living in style! Come see why this is a great place to call home.
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Vinyl
hoa_fee_includes__c, Common Areas,Homeowners Insurance,Insurance,Maintenance Grounds,Management,Sewer,Trash,Water
pba__hoafees__c, 494
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 225 Bay Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-03-23T02:47:07.000+0000
pba__latitude_pb__c, 37.805646
pba__latitude_property__c, 37.805646
laundry_features__c, Inside Room
listed_date__c, 2023-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sheldon
pba__listing_agent_lastname__c, Rilliet
listing_agent_mls_id__c, 806943
ffd_listingagentname, Sheldon T Rilliet
listing_agent_number__c, 199021669
listing_co_agent_mls_id__c, MLSL154122
listing_co_agent_number__c, 981184386
listing_co_office_mls_id__c, APR-10
listing_co_office_name__c, Compass
listing_co_office_number__c, 981049569
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.225bay203.com
pba__longitude_pb__c, -122.411069
mls_id__c, 423726172
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_property__c, a0O8W00000Hu2fBUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-09
original_price__c, 998000
overall_days_on_market__c, -81516
parking_access__c, Side by Side
parking_features__c, Assigned,Garage Door Opener,Interior Access,Side-by-Side,Size Limited
parking_type__c, On Site - Assigned (Condo 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, 1174.12
pba__propertytype__c, Condominium
ListingId, a0E8W00000bFKLzUAO
road_surface_type__c, Asphalt,Paved
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector
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, 850
size__c, 850
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Bay
subdist__c, North Beach
ffd_name, 225 Bay Street #203, San Francisco, CA, 94133
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1979
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530588697-1.jpg