ffd_listing_title,200 Judson Avenue, San Francisco, CA, 94112

ffd_mls_id,423908302

ffd_salesforce_id,a0E8W00000dSVFTUA4

num_of_fireplaces__c,0

num_of_rooms__c,7

of_units__c,0

address2__c,200 Judson Avenue, San Francisco, CA, 94112

pba__address_pb__c,200 Judson Avenue, San Francisco, CA, 94112

agent_only_remarks__c,Please call Priscilla 415-589-1266 or Rick Turley 415-577-5538 to schedule a showing. Escrow open with Chicago Title, Ria Tabucao- [email protected] #FWPN-3552300533.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Refrigerator

architectural_style__c,Contemporary;Modern/High Tech

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1926

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Rick A Turley

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-15T01:48:36.000+0000

days_on_market__c,15

dom__c,15

ffd_description_pb,This is the one you've been waiting for!! Nestled in the highly sought-after Sunnyside neighborhood, this stunning single-family home is a true gem! This 3 bed, 2 bath house is nearly brand new, having undergone a complete renovation with all the necessary permits. No detail has been spared in creating a modern and inviting living space. Boasting breathtaking views of the city, the bay, and Mount Diablo. The open top-floor layout provides a spacious and airy ambiance. A primary bedroom suite retreat on the lower level offers privacy and comfort. This fully renovated and reimagined home features ~ a fully remodeled kitchen with quartz counters and Bosch appliances ~ fully remodeled bathrooms ~ new engineered wood floors ~ recessed lighting throughout ~ new windows ~ new interior and exterior doors ~ new plumbing ~ new electrical ~ new roof ~ new landscaping ~ attached single car garage with new door, washer + dryer and EV charger ~ new exterior stucco ~ an expansive backyard, ideal for entertaining. Minutes from major freeways for easy commuting, close proximity to shopping centers and restaurants, nearby parks and green spaces. Don't miss the opportunity to make this exceptional property your new home. Schedule a viewing today and experience the epitome of San Francisco living!

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Fenced

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-30T01:47:22.000+0000

pba__latitude_pb__c,37.7284057

pba__latitude_property__c,37.7284057

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2023-08-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Priscilla

pba__listing_agent_lastname__c,Rodrigues

listing_agent_mls_id__c,814997

ffd_listingagentname,Priscilla Rodrigues

listing_agent_number__c,1069778

listing_co_agent_mls_id__c,800726

listing_co_agent_number__c,800726

listing_co_office_mls_id__c,SANF4

listing_co_office_name__c,Engel & Voelkers San Francisco

listing_co_office_number__c,28140

listing_office_mls_id__c,SANF

listing_office_name__c,Engel & Voelkers San Francisco

listing_office_number__c,25914

pba__listingprice_pb__c,1498000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=g1CsrJKP3Rz&brand=0

pba__longitude_pb__c,-122.4468063

lower_level__c,Bedroom(s),Full Bath(s),Garage

mls_id__c,423908302

master_bathroom_features__c,Low-Flow Toilet(s);Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-14

open_house_end__c,2023-09-30T16:00:00.000+0000

open_house_start__c,2023-09-30T14:00:00.000+0000

original_price__c,1498000

overall_days_on_market__c,-81705

parking_access__c,Independent

parking_features__c,Attached,EV Charging,Garage Door Opener,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,1122.1

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000dSVFTUA4

road_surface_type__c,Paved

roof__c,Shingle

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,1335

size__c,1335

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Judson

subdist__c,Sunnyside

ffd_name,200 Judson Avenue, San Francisco, CA, 94112

view__c,City;City Lights;Bay;Mt Diablo

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1926

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1696039932

ffd_listing_title,207 Flood Avenue, San Francisco, CA, 94112

ffd_mls_id,423904882

ffd_salesforce_id,a0E8W00000cqQgWUAU

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,207 Flood Avenue, San Francisco, CA, 94112

pba__address_pb__c,207 Flood Avenue, San Francisco, CA, 94112

agent_only_remarks__c,For showings, disclosures, or questions please contact Tori Andrews (650.269.1357, [email protected]). *1 car parking in the garage and driveway can accommodate 2nd car. ** 4th bedroom does not have a closet. ***We have multiple square footage measurements. Buyer is advised to investigate to their own satisfaction. Graphic Artist (2023): 1,700 sqft, Tax Records: 1,403 sqft, MLS (2010, per appraiser): 1,501 sqft.

appliances__c,Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-07T17:46:54.000+0000

days_on_market__c,9

dom__c,9

ffd_description_pb,Nestled in the charming Sunnyside neighborhood, 207 Flood Ave is flooded with incredible natural light through the many windows and skylights and enjoys beautiful hardwood floors throughout. The living room is centered around a fireplace and flows to the spacious dining room, which acts as the heart of the home. The adjacent kitchen is appointed with a gas range, a breakfast area, and direct access to the south-facing deck. Completing the main level are two bedrooms and a full bath. On the lower level are two additional bedrooms, both with direct access out to the garden. The south-facing garden is the perfect retreat with mature landscaping, a flat usable lawn, and patio. The bathroom has been thoughtfully remodeled with a walk-in shower, radiant floor heating, a towel warmer, and skylight. The laundry/mudroom has incredible storage and side-by-side washer/dryer. Ideally located near the restaurants and shops in Glen Park, Bart, Whole Foods, Safeway, Balboa Park, Sunnyside Playground, and easy freeway access.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fencing__c,Fenced

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-16T21:46:00.000+0000

pba__latitude_pb__c,37.7297102

pba__latitude_property__c,37.7297102

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2023-09-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Tori

pba__listing_agent_lastname__c,Andrews

listing_agent_mls_id__c,808858

ffd_listingagentname,Tori Andrews

listing_agent_number__c,1038063

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

pba__listingtype__c,Sale

pba__listing_website__c,http://207flood.com

pba__longitude_pb__c,-122.4445207

mls_id__c,423904882

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-07

open_house_end__c,2023-09-17T13:00:00.000+0000

open_house_start__c,2023-09-17T11:00:00.000+0000

original_price__c,1675000

overall_days_on_market__c,-81698

parking_access__c,Independent

parking_features__c,Attached,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck;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,985.29

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000cqQgWUAU

room_type__c,Office;Laundry

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate

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

size__c,1700

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Flood

subdist__c,Sunnyside

ffd_name,207 Flood Avenue, San Francisco, CA, 94112

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,448 judson Avenue, San Francisco, CA, 94112

ffd_mls_id,423900323

ffd_salesforce_id,a0E8W00000cpetcUAA

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

address2__c,448 judson Avenue, San Francisco, CA, 94112

pba__address_pb__c,448 judson Avenue, San Francisco, CA, 94112

agent_only_remarks__c,Complicated sale. Discuss with Listing Agent before requesting an appointment. Could be a great but you must At have full understanding of the complexities involved. Contact Tim for full disclosure discussion.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1941

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Daniel Curran

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-08-26T02:53:26.000+0000

days_on_market__c,14

dom__c,14

ffd_description_pb,Full-5 Sunnyside Home: 2-Bedrooms, 1 Bath, Living Room, Dining Room, Kitchen. Shared by 2 tenancies (TENANCIES, not just tenants), one on main level and one tenancy at the Garage level. The tenancies share use of the main level Kitchen and Bathroom. Property needs TLC. One car garage parking. Not at all for the faint-of-heart end user, this is a complicated sale which Listing Agent can more fully describe. Subject to tenants rights, full discussion required. This a court-ordered sale. There is no court confirmation required, no overbidding required. Showings are STRICTLY by appointment after full disclosure conversation with Listing Agent. This may be a candidate to park 1031 Exchange money. Consult Listing Agent for all details.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-09-08T00:46:37.000+0000

pba__latitude_pb__c,37.72858

pba__latitude_property__c,37.72858

listed_date__c,2023-08-24

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Tim

pba__listing_agent_lastname__c,Curran

listing_agent_mls_id__c,244894

ffd_listingagentname,Tim Curran

listing_agent_number__c,244894

listing_co_agent_mls_id__c,810706

listing_co_agent_number__c,1047498

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP3

listing_office_name__c,Compass

listing_office_number__c,27342

pba__listingprice_pb__c,828000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.45196

mls_id__c,423900323

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2023-08-24

open_house_end__c,2023-09-09T14:00:00.000+0000

open_house_start__c,2023-09-09T13:00:00.000+0000

original_price__c,828000

overall_days_on_market__c,-81684

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

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000cpetcUAA

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

size__c,1441

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,judson

subdist__c,Sunnyside

ffd_name,448 judson Avenue, San Francisco, CA, 94112

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1941

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,467 Melrose Avenue, San Francisco, CA, 94127

ffd_mls_id,423900021

ffd_salesforce_id,a0E8W00000cpetWUAQ

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,0

address2__c,467 Melrose Avenue, San Francisco, CA, 94127

pba__address_pb__c,467 Melrose Avenue, San Francisco, CA, 94127

agent_only_remarks__c,Seller Reserves the Right to Accept, Reject, or Counter any Offer.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Double Oven;Gas Cook Top

architectural_style__c,Traditional

bath_features__c,Tub w/Shower Over;Shower Stall(s);Granite;Steam

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,4

year_build_text__c,1941

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-08-26T02:53:26.000+0000

days_on_market__c,33

dom__c,33

ffd_description_pb,Spectacular Multi-Level WOW! Home with 4 Bedrooms, 5 Bathrooms including a fabulous Primary Suite with Private Deck. Remodeled Gorgeous, Open Kitchen. Media Room and Additional Room for Office/Exercise Space. Large Yard. Sweeping Views South from the Bay to the Ocean. Fantastic Home for Entertaining. Incredible Price Per Sq Ft! Mid point between West Portal and Glen Park and close to the Ocean Ave Commercial Disctrict allowing access to many Restaurants and Services in these desirable strips. Easy access to 280, 101 West Portal Muni and Glen Park Bart. Please Note: Floorplan Graphic Artist in 2018 showed 3374 Sq. Ft. Floorplan Graphic Artist from 2023 shows 3362 Sq. Ft. A must visit the inside of this property, This is the Home of your Dreams!

district__c,SF District 4

entry_level__c,0

exterior_features__c,Balcony;Entry Gate;Wet Bar

external_listing__c,1

fencing__c,Back Yard;Fenced

fireplace_features__c,Living Room;Dining Room

pba__floortype_pb__c,Granite;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Gas

interior_features__c,Formal Entry;Skylight(s)

ffd_lastmodifieddate,2023-09-28T02:46:57.000+0000

pba__latitude_pb__c,37.73356

pba__latitude_property__c,37.73356

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2023-06-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Debbie

pba__listing_agent_lastname__c,Herzfeld

listing_agent_mls_id__c,115218

ffd_listingagentname,Debbie J Herzfeld

listing_agent_number__c,115218

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP7

listing_office_name__c,Compass

listing_office_number__c,28751

pba__listingprice_pb__c,2350000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.45242

lower_level__c,Bedroom(s),Full Bath(s),Living Room,Retreat

mls_id__c,423900021

main_level__c,Full Bath(s);Kitchen;Garage;Dining Room

master_bathroom_features__c,Shower Stall(s);Jetted Tub;Granite;Multiple Shower Heads;Steam

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-08-25

open_house_end__c,2023-10-01T16:00:00.000+0000

open_house_start__c,2023-10-01T14:00:00.000+0000

original_price__c,2495000

overall_days_on_market__c,-81685

parking_access__c,Tandem

parking_features__c,Attached,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2023-09-27T13:27:11.000+0000

price_per_square_foot__c,783.33

price_reduced__c,1

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000cpetWUAQ

room_type__c,Office;Living Room;Dining Room;Media Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate

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

size__c,3000

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Melrose

subdist__c,Sunnyside

ffd_name,467 Melrose Avenue, San Francisco, CA, 94127

view__c,Ocean;City Lights;Bay;Hills

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1941

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

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