meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222381' 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] => 2024-03-19 12:57:22
[post_modified_gmt] => 2024-03-19 19:57:22
[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, 749 Guerrero Street, San Francisco, CA, 94110
ffd_mls_id, 421615724
ffd_salesforce_id, a0E8W00000V2gE6UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 749 Guerrero Street, San Francisco, CA, 94110
pba__address_pb__c, 749 Guerrero Street, San Francisco, CA, 94110
agent_only_remarks__c, https://app.disclosures.io/link/749-Guerrero-Street-yi1915m7 Tax record notes 1575 square feet.
appliances__c, Dishwasher;Insulated Water Heater;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Ice Maker;Plumbed For Ice Maker
architectural_style__c, Arts & Crafts;Bungalow
bath_features__c, Tub;Tile;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1909
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Liz A Kraus
pba__contingentdate__c, 2022-01-26
ffd_createddate, 2022-01-01T11:49:19.000+0000
days_on_market__c, 564
dom__c, 27
ffd_description_pb, REDUCED BELOW 2015 PRICE! Give-away priced Guerrero street single-family house 1 block from Dolores Park w/expansion potential. 3 Levels of space. Formal entry w/period staircase to the upper floor, front living room with fireplace & bay window, spacious formal dining room with entry from foyer and kitchen. The kitchen features a new floor, new white quartz counters, a new sink with disposal, a new stainless refrigerator, dishwasher, gas range. The breakfast room has French doors which open to the deck and yard. There is also a laundry room and half bath. Upstairs, three spacious bedrooms include a two-part big bedroom and a park view bedroom with his and her closets. Gorgeous full hall bath with soaking tub, skylights, pedestal sink, and more. The lower level has a large basement ideal for expansion with its own possible entry for an ADU. Outdoor deck, fully fenced rear yard, side service entrance, gated front porch, new front paint, just refinished hardwood floor
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-02-18T11:49:16.000+0000
pba__latitude_pb__c, 37.7592136
pba__latitude_property__c, 37.7592136
laundry_features__c, Inside Room;In Kitchen;Inside Area;Ground Floor;Washer Included;Dryer Included;Gas Hook-Up
listed_date__c, 2021-12-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bill
pba__listing_agent_lastname__c, Harkins
listing_agent_mls_id__c, 806230
ffd_listingagentname, Bill Harkins
listing_agent_number__c, 166016578
listing_co_agent_mls_id__c, 810548
listing_co_agent_number__c, 1046867
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, HARK
listing_office_name__c, Bill Harkins Brokerage, Inc.
listing_office_number__c, 23361
pba__listingprice_pb__c, 1600000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/XN4H5vPp8Lw
pba__longitude_pb__c, -122.4233462
lower_level__c, Retreat,Street Entrance
mls_id__c, 421615724
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-01-01
original_price__c, 1695000
overall_days_on_market__c, 89
patio_and_porch_features__c, Back Porch;Uncovered Deck;Uncovered Patio;Front Porch
pba__pendingdate__c, 2022-01-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-17T15:56:42.000+0000
price_per_square_foot__c, 987.62
pba__propertytype__c, Single Family Residence
id, a0E8W00000V2gE6UAJ
road_surface_type__c, Paved
room_type__c, Storage;Bonus Room;Laundry;Kitchen;Living Room;Baths Other;Dining Room
sale_date__c, 2022-02-17
sale_price__c, 1595000
security_features__c, Unguarded Gate
selling_agent_mls_id__c, MLSL154689
selling_agent_number__c, 981184906
selling_co_agent_mls_id__c, MLSL5084885
selling_co_agent_number__c, 981354648
selling_co_office_mls_id__c, APR-3
selling_co_office_name__c, Compass
selling_co_office_number__c, 981047629
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1615
size__c, 1615
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Guerrero
subdist__c, Mission Dolores
ffd_name, 749 Guerrero Street, San Francisco, CA, 94110
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530372883-1.jpg
ListingId, a0E8W00000V2gE6UAJ