245 Ewing Terrace, San Francisco, CA, 94118 - Property Description

_yoast_indexnow_last_ping,1714993058

ffd_listing_title,148 Blake Street #3, San Francisco, CA, 94118

ffd_mls_id,424028212

ffd_salesforce_id,a0EUd000001u2WPMAY

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,3

address2__c,148 Blake Street #3, San Francisco, CA, 94118

pba__address_pb__c,148 Blake Street #3, San Francisco, CA, 94118

agent_only_remarks__c,Tax record is incorrect. Floor plan drafter measured 1515 sqft + 290 sqft of private terrace and balcony. Easy to show. Email [email protected] for lockbox showing instructions. Offer/s welcome this Wednesday the 8th at noon.

appliances__c,Dishwasher;Hood Over Range;Free Standing Refrigerator

architectural_style__c,Modern/High Tech

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1982

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-02T13:46:31.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Stunning modern penthouse in an impressive 3-unit building in desirable Lone Mountain. Meticulously renovated in 2024, this top-floor condo offers incredible scale, a pragmatic floor plan and clean-line finishes. Open living and dining room flows seamlessly to a modern kitchen with induction cooktop, quartz countertops and custom cabinetry. Three light-filled bedrooms including an oversized primary bedroom with ensuite bathroom. Two modern bathrooms with designer fixtures. Beautiful wood floors, in-unit laundry, brand-new windows, updated electrical and plumbing. A huge private terrace, a shared garden, spacious garage parking and abundant storage. Steps to wonderful neighborhood amenities: world-class parks, restaurants and the coming-soon Whole Foods. Move right in and enjoy the best of city living.

district__c,SF District 1

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Homeowners Insurance,Trash

pba__hoafees__c,300

pba__hoafrequency_pb__c,Monthly

hoa_name__c,148 Blake St Condominiums

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-05-06T10:47:18.000+0000

pba__latitude_pb__c,37.781278

pba__latitude_property__c,37.781278

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2024-04-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,C.M.

pba__listing_agent_lastname__c,Foo

listing_agent_mls_id__c,804711

ffd_listingagentname,C.M. Foo

listing_agent_number__c,166014367

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.450661

mls_id__c,424028212

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom

master_property__c,a0OUd000003zglSMAQ

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-05-02

open_house_end__c,2024-05-07T13:00:00.000+0000

open_house_start__c,2024-05-07T11:00:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-81936

parking_access__c,Side by Side

parking_features__c,24'+ Deep Garage,Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side

parking_type__c,On Site - Assigned (Condo Only);On Site - Mapped (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,986.8

pba__propertytype__c,Condominium

ListingId,a0EUd000001u2WPMAY

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

size__c,1515

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Blake

subdist__c,Lone Mountain

ffd_name,148 Blake Street #3, San Francisco, CA, 94118

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1982

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714769925

ffd_listing_title,672 Arguello Boulevard, San Francisco, CA, 94118

ffd_mls_id,424009691

ffd_salesforce_id,a0EUd000001rkk5MAA

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,0

address2__c,672 Arguello Boulevard, San Francisco, CA, 94118

pba__address_pb__c,672 Arguello Boulevard, San Francisco, CA, 94118

agent_only_remarks__c,Easy to show. Call/Text Maria 415 699 8008.

pba__fullbathrooms_pb__c,6

pba__bedrooms_pb__c,5

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-29T13:46:38.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Situated between verdant expanses of Golden Gate Park and The Presidio, (near Rossi Swimming Pool/Tennis Courts/Playground), this smartly designed modern home checks all the boxes. Reimagined and rebuilt in 2010 with 6.5 bathrooms, 5 bedrooms/offices with ensuite baths, elevator to all levels, spacious public rooms for hosting guests, two plus car parking, east and west view decks and an east facing garden. Owned solar, radiant heat, open floor plan, custom finishes, two fireplaces, a separate entrance studio and a spa soaking tub deliver an unparalleled living experience in San Francisco. This location's amenities promise endless entertainment and delight. Vibrant Clement Street farmers market, bars, restaurants and shops. Convenient multiple public transportation options nearby make urban commuting a breeze, with equally easy access to the North and South Bay and Bay Area airports.

district__c,SF District 1

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Piped;Gas Starter

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-05-03T20:47:49.000+0000

pba__latitude_pb__c,37.7776599

pba__latitude_property__c,37.7776599

listed_date__c,2024-01-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Maria

pba__listing_agent_lastname__c,Marchetti

listing_agent_mls_id__c,806601

ffd_listingagentname,Maria Marchetti

listing_agent_number__c,166017283

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,3960000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4582873

mls_id__c,424009691

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-29

open_house_end__c,2024-05-05T15:00:00.000+0000

open_house_start__c,2024-05-05T13:00:00.000+0000

original_price__c,3960000

overall_days_on_market__c,-81933

parking_access__c,Side by Side

parking_features__c,Attached,Garage Door Opener,Interior Access,Side-by-Side

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001rkk5MAA

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

size__c,4554

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Arguello

subdist__c,Lone Mountain

ffd_name,672 Arguello Boulevard, San Francisco, CA, 94118

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714215610

ffd_listing_title,2580 McAllister Street, San Francisco, CA, 94118

ffd_mls_id,424026402

ffd_salesforce_id,a0EUd000001oQoLMAU

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,2580 McAllister Street, San Francisco, CA, 94118

pba__address_pb__c,2580 McAllister Street, San Francisco, CA, 94118

agent_only_remarks__c,Can't find what your client is looking for? Help them create it!! Call for plans, bids and disclosures. Disclosures should be ready by Monday, April 29th. Please email Ed Deleski at [email protected] and Jean-Paul Samaha at [email protected] to request disclosures. thank you

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,5

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Edward R Deleski

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-23T00:48:06.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,Fantastic opportunity to customize and finish your new home, already well underway on its way to completion. Offered with plans, permits and bids by a licensed contractor to complete a 4,076 sq.ft. single family home with 5-bedrooms, 5.5-bathrooms and 1-car garage. Most finishes and appliances have been specified and bid - use the owner's designs or custom design a luxurious home to your liking. A finish package can be made available upon request. This is a premier Lone Mountain location a block from Golden Gate Park, and steps to Inner Richmond commercial centers, restaurants, cafes, stores and access to area freeways.

district__c,SF District 1

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-04-27T10:46:58.000+0000

pba__latitude_pb__c,37.775743

pba__latitude_property__c,37.775743

listed_date__c,2024-04-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jean-Paul

pba__listing_agent_lastname__c,Samaha

listing_agent_mls_id__c,804997

ffd_listingagentname,Jean-Paul Samaha

listing_agent_number__c,166014752

listing_co_agent_mls_id__c,807512

listing_co_agent_number__c,1020319

listing_co_office_mls_id__c,VANG02

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,166013449

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,2795000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.2580mcallister.com

pba__longitude_pb__c,-122.454606

mls_id__c,424026402

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-22

original_price__c,2795000

overall_days_on_market__c,-81926

parking_access__c,Independent

parking_features__c,Attached,Enclosed

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001oQoLMAU

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

size__c,4076

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,McAllister

subdist__c,Lone Mountain

ffd_name,2580 McAllister Street, San Francisco, CA, 94118

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715079524

ffd_listing_title,574 Arguello 576 Boulevard, San Francisco, CA, 94118

ffd_mls_id,424024898

ffd_salesforce_id,a0EUd000001o63FMAQ

num_of_rooms__c,10

of_units__c,2

address2__c,574 Arguello 576 Boulevard, San Francisco, CA, 94118

pba__address_pb__c,574 Arguello 576 Boulevard, San Francisco, CA, 94118

agent_only_remarks__c,Email [email protected] for showing requests, no Showing Time requests. Escrow opened with Mark Adams of WFG, and seller requests it stays there. Multiple square foot measurements, and buyer to satisfy themselves. Total building sqft measured at 4,905. Buyer should test parking to their satisfaction. Please use most current SFAR Purchase Contract, allow 24 hours to respond, include fully executed disclosure package, and 1 business day for the initial deposit.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1938

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-22T18:48:03.000+0000

days_on_market__c,18

dom__c,15

ffd_description_pb,This amazing vacant 2-unit building showcases grand scale, amazing natural light, gorgeous period detail, and is located on a premier block of Lone Mountain, just steps from Rossi Park, Golden Gate Park, and bustling Clement Street. This distinctive property offers two exquisite full floor flats featuring 2 bedrooms, 1 bathroom, an expansive living room perfect for entertaining, formal dining room, and gracious chef's kitchen. There is also a large 3+ car garage, multiple storage rooms with expansion potential, and a lush landscaped shared backyard. This property offers an excellent opportunity for a family compound, an owner user with rental income, or an investment building with strong income, perfectly located in a highly coveted neighborhood location.

district__c,SF District 1

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Fireplace(s);Natural Gas

interior_features__c,Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2024-05-07T10:47:47.000+0000

pba__latitude_pb__c,37.779873

pba__latitude_property__c,37.779873

laundry_features__c,Washer/Dryer Hookups

listed_date__c,2024-04-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Greg

pba__listing_agent_lastname__c,Fulford

listing_agent_mls_id__c,804156

ffd_listingagentname,Greg Fulford

listing_agent_number__c,166013627

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,2895000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.574Arguello.com

pba__longitude_pb__c,-122.45843

mls_id__c,424024898

parkingspaces__c,3

on_market_date__c,2024-04-19

open_house_end__c,2024-05-07T13:00:00.000+0000

open_house_start__c,2024-05-07T11:00:00.000+0000

original_price__c,2895000

overall_days_on_market__c,-81923

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,893.52

pba__propertytype__c,Duplex

ListingId,a0EUd000001o63FMAQ

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

size__c,3240

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Arguello

subdist__c,Lone Mountain

ffd_name,574 Arguello 576 Boulevard, San Francisco, CA, 94118

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1938

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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