227 Garfield Street, San Francisco, CA, 94132 - Property Description

_yoast_indexnow_last_ping,1728349037

ffd_listing_title,633 Shields Street, San Francisco, CA, 94132

ffd_mls_id,424067420

ffd_salesforce_id,a0EUd000003DieJMAS

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,633 Shields Street, San Francisco, CA, 94132

pba__address_pb__c,633 Shields Street, San Francisco, CA, 94132

agent_only_remarks__c,Graphic artist measured 1,563 sq. ft. Great price for this special, turnkey house featuring a magical zen garden with a koi pond, view deck, spacious garage, and stunning views. Easy to show. Call Eva at 415-902-8743 or James at 415-987-7787 for showings.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1945

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Eva Stoyanov

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-27T19:48:54.000+0000

days_on_market__c,10

dom__c,10

ffd_description_pb,Special 3 bedroom house with stunning views of the Ocean, hills, golf courses, and Marin Headlands, a 2 car garage, and a magical, zen garden with a koi pond and impressive shed in a desirable Merced Heights location. The chef's kitchen is well-appointed and has a Bertazzoni gas range. It flows into the large living room and dining area that feature great views. 2 nice-sized bedrooms offer views as well and lead to the walk-out view deck. The bedroom suite on the lower level opens up to the backyard. It is a thoughtfully-designed oasis with a serene fountain and pond, lush bamboo, mature plants, outdoor sink, and extraordinary shed. The remarkable garden has numerous features such as the replica of a Xi'an terracotta warrior. The beautiful entryway has a unique water feature. A spacious garage with high ceilings offers storage space and an oversized sink. Near restaurants and cafes on Ocean Ave., Whole Foods, Stonestown, and H Mart. A couple blocks to Merced Heights Playground, Brooks Park, and Ortega Elementary School, a National Blue Ribbon School in 2023. Easy access to 280, 19th Ave., MUNI streetcars, and BART. Short drive to Lake Merced, Fort Funston, and Ocean Beach. This home has been cared for and enjoyed by the owners for 21 years. Artistry and craftsmanship throughout.

district__c,SF District 3

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-10-08T00:47:40.000+0000

pba__latitude_pb__c,37.7177535

pba__latitude_property__c,37.7177535

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-09-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,James

pba__listing_agent_lastname__c,Shinbori

listing_agent_mls_id__c,806892

ffd_listingagentname,James M Shinbori

listing_agent_number__c,166017811

listing_co_agent_mls_id__c,803709

listing_co_agent_number__c,803709

listing_co_office_mls_id__c,COMP90

listing_co_office_name__c,Compass

listing_co_office_number__c,29048

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,1199000

pba__listingtype__c,Sale

pba__listing_website__c,https://thesfteam.com/properties/633-shields-st

pba__longitude_pb__c,-122.4686377

mls_id__c,424067420

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-27

open_house_end__c,2024-10-08T15:00:00.000+0000

open_house_start__c,2024-10-08T13:00:00.000+0000

original_price__c,1199000

overall_days_on_market__c,-82084

parking_access__c,Tandem

parking_features__c,Attached,Interior Access,Tandem Garage

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003DieJMAS

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

size__c,1266

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Shields

subdist__c,Merced Heights

ffd_name,633 Shields Street, San Francisco, CA, 94132

view__c,Ocean;Golf Course;Hills

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1945

pba__postalcode_pb__c,94132

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726278740

ffd_listing_title,519 Orizaba Avenue, San Francisco, CA, 94132

ffd_mls_id,423908536

ffd_salesforce_id,a0EUd0000027XvoMAE

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,519 Orizaba Avenue, San Francisco, CA, 94132

pba__address_pb__c,519 Orizaba Avenue, San Francisco, CA, 94132

agent_only_remarks__c,24 HR Notice For Showings-Call or text listing agent--Greg Polchow: 415-846-9542. Pre-Escrow opened with Kevin Thompson at First Amercian Title. https://app.disclosures.io/link/519-Orizaba-Avenue-xf2az0t7

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1963

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-24T10:48:13.000+0000

days_on_market__c,367

dom__c,89

ffd_description_pb,Perched on top of a hill overlooking the Pacific Ocean, this contemporary Merced Heights home in original condtion backs up to open space on a quiet street with no-thru-traffic. Sweeping panoramic views stretch northward to the Marin Headlands and beyond and include views of much of the city. This tunnel entrance home features ample living space on the main floor, including three bedrooms and two baths, an eat in-kitchen, an open living room with fireplace, and an attached dining area with Pacific Ocean views. The feshly painted and newly carpeted lower level offers additional living space that includes a large family room and upgraded bathroom with separate entrance off inner entry. This house sits on a full lot with rear garden and garage with laundry and interior access. A great opportunity to add your own personal touches.

district__c,SF District 3

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fencing__c,Back Yard;Fenced

fireplace_features__c,Living Room;Brick

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-09-14T01:47:16.000+0000

pba__latitude_pb__c,37.71831

pba__latitude_property__c,37.71831

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2023-05-23

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gregory

pba__listing_agent_lastname__c,Polchow

listing_agent_mls_id__c,807087

ffd_listingagentname,Greg R Polchow

listing_agent_number__c,166018203

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB3

listing_office_name__c,Sotheby's International Realty Inc

listing_office_number__c,28227

pba__listingprice_pb__c,1795000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=2F3cHxTGn32&brand=0&mls=1&

pba__longitude_pb__c,-122.46292

lower_level__c,Family Room,Garage,Partial Bath(s)

mls_id__c,423908536

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

on_market_date__c,2023-09-12

open_house_end__c,2024-09-15T16:00:00.000+0000

open_house_start__c,2024-09-15T13:00:00.000+0000

original_price__c,1205000

overall_days_on_market__c,-81703

parking_access__c,Independent

parking_features__c,Attached,Covered,Garage Facing Front,Interior Access

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000027XvoMAE

road_surface_type__c,Asphalt

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

size__c,1828

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Orizaba

subdist__c,Merced Heights

ffd_name,519 Orizaba Avenue, San Francisco, CA, 94132

view__c,Ocean;City;Panoramic;San Francisco

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1963

pba__postalcode_pb__c,94132

ffd_media,Array

ffd_media_tags,Array

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