meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336941' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15110
[post_author] => 4
[post_date] => 2018-10-31 19:36:27
[post_date_gmt] => 2018-10-31 19:36:27
[post_content] => Not quite the Mission, not quite the Castro, Mission Dolores is a bustling, centrally located neighborhood with some iconic San Francisco attractions. The crown jewels of the neighborhood are Dolores Park and Mission Dolores, the oldest Spanish Mission church in San Francisco. Sun worshippers flock to Dolores Park on warm and cool days alike, and the church welcomes worshippers for regular services.
[post_title] => Mission Dolores
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-dolores
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 09:06:17
[post_modified_gmt] => 2023-06-23 16:06:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15110
[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, 3573 19th Street, San Francisco, CA, 94110
ffd_mls_id, 423900200
ffd_salesforce_id, a0E8W00000cpesVUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3573 19th Street, San Francisco, CA, 94110
pba__address_pb__c, 3573 19th Street, San Francisco, CA, 94110
agent_only_remarks__c, Vacant, go show. Current owner did not live in the unit and will not guarantee condition of the appliances. As-Is and owner reserves right to refuse sale. Recommend fireplace inspection for functionality. This is a 2 unit condo and all decisions are made between the 2 owners. Please review CC&R. Subject unit has the right to build-out the roof and has deeded access to the garage. Disclosures: https://app.disclosures.io/link/3573-19th-Street-5cj1piit
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s);Tile;Bidet
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-08-26T02:50:49.000+0000
days_on_market__c, 17
dom__c, 17
ffd_description_pb, 3573 19th Street is a top floor condo with deeded garage, located in the Mission Dolores district. It is situated in a 2-unit building that was originally built in 1912 and converted into a residential condominium in 2011. This condo features 2 bedrooms and 1 bathroom, with a parlor that has a bay window and fireplace that could potentially be converted into a third bedroom. The kitchen is equipped with custom cabinets, modern counters, and high-end appliances such as a Viking range oven and Bosch dishwasher. There is also a separate laundry room. According to previous appraisal measurements, the unit spans approximately 1,330 square feet and boasts hardwood floors throughout the rooms and hallways, providing ample natural light. Additionally, there is a bonus partitioned office on the ground floor, a landscaped backyard, one-car garage parking, and extra storage space. The unit also has the rights to build-out the roof, as granted in the recorded CC&R (Covenants, Conditions, and Restrictions).
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, None
fireplace_features__c, See Remarks
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance,Maintenance Grounds,Management,Trash,Other
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3573-3575 19th Street Homeassociation
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Other;Fireplace(s)
height_limit__c, Unknown
ffd_lastmodifieddate, 2023-09-09T10:46:57.000+0000
pba__latitude_pb__c, 37.75982
pba__latitude_property__c, 37.75982
laundry_features__c, Inside Area;Washer Included;Dryer Included;Cabinets
listed_date__c, 2023-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Angela
pba__listing_agent_lastname__c, Ma
listing_agent_mls_id__c, 808649
ffd_listingagentname, Angela Ma
listing_agent_number__c, 1037429
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AMPM
listing_office_name__c, Angela Ma, Broker
listing_office_number__c, 25739
pba__listingprice_pb__c, 1390000
pba__listingtype__c, Sale
pba__listing_website__c, https://spotlight-photography.aryeo.com/sites/3573-19th-st-san-francisco-ca-94110-5774797/branded
pba__longitude_pb__c, -122.42305
mls_id__c, 423900200
master_property__c, a0O8W00000KSEtTUAX
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-23
open_house_end__c, 2023-09-16T14:00:00.000+0000
open_house_start__c, 2023-09-16T12:00:00.000+0000
original_price__c, 1390000
overall_days_on_market__c, -81683
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front,Private
parking_type__c, Other
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, 1045.11
pba__propertytype__c, Condominium
ListingId, a0E8W00000cpesVUAQ
road_surface_type__c, Paved
roof__c, Tar/Gravel
room_type__c, Kitchen;Living Room;Baths Other;Other
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Extinguisher;Carbon Mon Detector;Double Strapped Water Heater
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, 1330
size__c, 1330
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 19th
subdist__c, Mission Dolores
ffd_name, 3573 19th Street, San Francisco, CA, 94110
view__c, City;Park
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530660634-1.jpg