251 Missouri Street #, San Francisco, CA, 94107 - Property Description

_yoast_indexnow_last_ping,1713560298

ffd_listing_title,437 Arkansas Street, San Francisco, CA, 94107

ffd_mls_id,424025452

ffd_salesforce_id,a0EUd000001mgveMAA

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,437 Arkansas Street, San Francisco, CA, 94107

pba__address_pb__c,437 Arkansas Street, San Francisco, CA, 94107

agent_only_remarks__c,Beautiful, spacious split level condo. Great SFH alternative. Easy to show! HOA is pay as you go.

appliances__c,Dishwasher;Built-In Gas Range;Built-In Refrigerator

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1980

pba__city_pb__c,San Francisco

listing_co_agent_name__c,John C Farnham

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T14:46:47.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This sprawling 2200+ square foot 4 bedroom, 2.5 bath view condo with lush private garden lives like a single family and is a great alternative for buyers looking for a home on the coveted North Slope of Potrero Hill. The main level features an open plan living area with West-facing bay windows, spacious and sunny living room, dedicated dining area, updated kitchen and powder room. Completing this level is a private suite that would make ideal guest/extended family/au pair quarters or AirBnB rental space, with dedicated full bath, direct garden access and separate entrance leading to the lobby and street. A dedicated laundry room has built in cabinetry and ample storage space. The upper level features three bedrooms on one floor and luxurious bath with both a soaking tub and walk-in shower. Stairs down from the top floor lead to a bright and airy family room with massive picture windows and dramatic views of downtown and the bay bridge towers. The family room leads out to the rear lush, landscaped yard with mature greenery, two deck areas, and stunning downtown views. One car garage parking.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-04-19T20:47:58.000+0000

pba__latitude_pb__c,37.760726

pba__latitude_property__c,37.760726

laundry_features__c,Inside Area;Washer Included;Dryer Included;Cabinets

listed_date__c,2024-01-24

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Laura

pba__listing_agent_lastname__c,Rogers

listing_agent_mls_id__c,803793

ffd_listingagentname,Laura A Rogers

listing_agent_number__c,803793

listing_co_agent_mls_id__c,802874

listing_co_agent_number__c,802874

listing_co_office_mls_id__c,COMP12

listing_co_office_name__c,Compass

listing_co_office_number__c,28739

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1995000

pba__listingtype__c,Sale

pba__listing_website__c,http://437arkansas.com/mls

pba__longitude_pb__c,-122.397982

mls_id__c,424025452

master_property__c,a0OUd000006CufoMAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-19

open_house_end__c,2024-04-20T15:00:00.000+0000

open_house_start__c,2024-04-20T13:00:00.000+0000

original_price__c,1995000

overall_days_on_market__c,-81923

parking_access__c,Side by Side

parking_features__c,Covered,Enclosed,Garage Facing Front

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,887.85

pba__propertytype__c,Condominium

ListingId,a0EUd000001mgveMAA

room_type__c,Laundry;Living Room;Family Room

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,Active

pba__totalarea_pb__c,2247

size__c,2247

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Arkansas

subdist__c,Potrero Hill

ffd_name,437 Arkansas Street, San Francisco, CA, 94107

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1980

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530763939-1.jpg

_yoast_indexnow_last_ping,1713923918

ffd_listing_title,437 Vermont 439 Street, San Francisco, CA, 94107

ffd_mls_id,424024429

ffd_salesforce_id,a0EUd000001mZm5MAE

num_of_rooms__c,0

of_units__c,3

address2__c,437 Vermont 439 Street, San Francisco, CA, 94107

pba__address_pb__c,437 Vermont 439 Street, San Francisco, CA, 94107

agent_only_remarks__c,For private showings please contact Venus/Kim at 415-329-1210 to schedule an appointment. Buyer to verify sqft to their satisfaction. Escrow opened with Michael Yip at Chicago Title. The lower and upper units are tenant occupied. Both claimed protected.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,6

year_build_text__c,1927

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T12:47:50.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Beautiful three unit building in the North Slope of Potrero Hill, with separate entrances, high ceilings and oversized bay windows all throughout, offers incredible views and abundance of natural light. 2 units are occupied. The middle full floor unit will be delivered vacant and has been completely renovated and redesigned for modern luxury w/ sprawling open living room/dining room/kitchen, 3 bedroom, 2 bathroom and sun-drenched office/media room. The unit also features a premier chef's kitchen equipped w/ top-of-the-line SS appliances. Primary bedroom suites feature spa-quality bathroom and walk-in closet. In unit W/D, 1 car garage, basement with ample storage. Perfect for remote work, the middle and top floor units offer a sunroom with incredible skyline views. The lower and upper units are tenant occupied, perfect for a live/rent situation. The ground floor unit is a sunny 1B/1b + bonus room. The top floor unit boast full-floor layouts with sunroom. Rounding out the building is a gorgeous backyard with a large stone tiled patio, lush garden beds & large planters, shade trees, & a natural stone walkway. Boasting a walk score of 97, you'll be steps from everyday essentials like Whole Foods, great dining + more. Convenient access to public transit, Bay Bridge & Highway 101.

district__c,SF District 9

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-24T01:47:28.000+0000

pba__latitude_pb__c,37.764149

pba__latitude_property__c,37.764149

listed_date__c,2024-04-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Venus

pba__listing_agent_lastname__c,Zheng

listing_agent_mls_id__c,812094

ffd_listingagentname,Venus Zheng

listing_agent_number__c,1054840

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,2095000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.404134

mls_id__c,424024429

parkingspaces__c,1

on_market_date__c,2024-04-19

open_house_end__c,2024-04-23T16:00:00.000+0000

open_house_start__c,2024-04-23T14:00:00.000+0000

original_price__c,2095000

overall_days_on_market__c,-81923

parking_features__c,Attached,Garage,Garage Door Opener

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,506.77

pba__propertytype__c,Triplex

ListingId,a0EUd000001mZm5MAE

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,Active

pba__totalarea_pb__c,4134

size__c,4134

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Vermont

subdist__c,Potrero Hill

ffd_name,437 Vermont 439 Street, San Francisco, CA, 94107

view__c,City;Downtown;San Francisco

website_property_type__c,Triplex

pba__yearbuilt_pb__c,1927

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530761575-1.jpg

_yoast_indexnow_last_ping,1713927322

ffd_listing_title,556 Wisconsin Street, San Francisco, CA, 94107

ffd_mls_id,424025205

ffd_salesforce_id,a0EUd000001mPBfMAM

num_of_fireplaces__c,1

num_of_rooms__c,4

of_units__c,87

address2__c,556 Wisconsin Street, San Francisco, CA, 94107

pba__address_pb__c,556 Wisconsin Street, San Francisco, CA, 94107

agent_only_remarks__c,Call agent for instructions to access property. Lockbox will be installed after Weekend, 4/21, open house. Offer date TBD. Disclosures will be ready 4/23. Photos have been photoshopped. The property has personal belongings that will be removed prior to close of escrow.

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1978

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-18T22:47:22.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,Impressive View Home in Victoria Mews looking for a little TLC. 556 Wisconsin offers a country club style living boasting 2 bedrooms, 2 bathrooms, and a fantastic deck that overlooks the swimming pool, the tennis courts, and commands gorgeous views of the city! The living room is filled with natural light and has a wood burning fireplace. The dining room is set above an oasis garden providing lots of natural light and privacy to enjoy the gentle sound of the creak below- with direct access to deck perfect for a cozy night together or to entertain friends and family. The primary bedroom has a private bathroom, walk-in closet, and patio area. The guest bedroom offers direct access to the patio area. Amenities included a life safety system and front door video. This is a first-floor unit with no steps, straight shot from the building door to the front. The HOA includes a swimming pool, tennis courts, gym, clubhouse, ground maintenance, building Insurance, water, and garbage. The property includes 1 parking space and a storage room. This is a great opportunity to remodel and make your own or fix and flip. Great Potrero Hill location near Whole Foods, UCSF, I-280 & 101

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Wood Burning

pba__floortype_pb__c,Carpet

hoa_fee_includes__c,Common Areas,Insurance on Structure,Maintenance Grounds,Pool,Trash,Water

pba__hoafees__c,996

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Victoria Mews

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Baseboard

ffd_lastmodifieddate,2024-04-24T02:46:37.000+0000

pba__latitude_pb__c,37.7604526

pba__latitude_property__c,37.7604526

listed_date__c,2024-04-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Nick

pba__listing_agent_lastname__c,Johnson

listing_agent_mls_id__c,804026

ffd_listingagentname,Nick Johnson

listing_agent_number__c,166013436

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,795000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.3994126

mls_id__c,424025205

master_property__c,a0OUd000006BVhuMAG

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-18

open_house_end__c,2024-04-23T16:00:00.000+0000

open_house_start__c,2024-04-23T14:00:00.000+0000

original_price__c,795000

overall_days_on_market__c,-81922

parking_access__c,Side by Side

parking_features__c,Covered

parking_type__c,On Site - Mapped (Condo Only)

patio_and_porch_features__c,Uncovered Patio

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,676.6

pba__propertytype__c,Condominium

ListingId,a0EUd000001mPBfMAM

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,Active

pba__totalarea_pb__c,1175

size__c,1175

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Wisconsin

subdist__c,Potrero Hill

ffd_name,556 Wisconsin Street, San Francisco, CA, 94107

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1978

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530763544-1.jpg

_yoast_indexnow_last_ping,1713524391

ffd_listing_title,748 San Bruno Avenue, San Francisco, CA, 94107

ffd_mls_id,424025448

ffd_salesforce_id,a0EUd000001mNt2MAE

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

address2__c,748 San Bruno Avenue, San Francisco, CA, 94107

pba__address_pb__c,748 San Bruno Avenue, San Francisco, CA, 94107

agent_only_remarks__c,This is a fixer due to a fire. Showing by appointment only, during the day Monday through Friday, by appointment. Escrow has been opened with old Republic. Seller retains the right to accept, reject or counter all or any offers. Jerry 415-786-3088 or Kim 1-510-384-1632

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1900

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Alex Kim

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-18T21:47:37.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Contractors, dream on the North Slope of Potrero Hill. Originally, the home was a two bedroom one bath with spectacular viewsample space on the lower level with an extra large lot. Community garden, 25 feet away, a half a block from McKinley Square.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-19T10:49:09.000+0000

pba__latitude_pb__c,37.7600525

pba__latitude_property__c,37.7600525

listed_date__c,2024-04-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jerry

pba__listing_agent_lastname__c,Stynes

listing_agent_mls_id__c,803922

ffd_listingagentname,Jerry Stynes

listing_agent_number__c,166013286

listing_co_agent_mls_id__c,EB149623

listing_co_agent_number__c,981310221

listing_co_office_mls_id__c,14683

listing_co_office_name__c,KW Advisors

listing_co_office_number__c,981065492

listing_office_mls_id__c,KWADVSF

listing_office_name__c,KW Advisors

listing_office_number__c,28861

pba__listingprice_pb__c,800000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4053237

mls_id__c,424025448

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-18

original_price__c,800000

overall_days_on_market__c,-81922

parking_access__c,Independent

parking_features__c,Garage Facing Front

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,1012.66

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001mNt2MAE

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,Active

pba__totalarea_pb__c,790

size__c,790

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,San Bruno

subdist__c,Potrero Hill

ffd_name,748 San Bruno Avenue, San Francisco, CA, 94107

view__c,City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Golden Gate Bridge;Sutro Tower;Bridges

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530763538-1.jpg