meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330475' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 06:03:10
[post_modified_gmt] => 2022-12-05 14:03:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 4334 19th Street, San Francisco, CA, 94114
ffd_mls_id, 423729308
ffd_salesforce_id, a0E8W00000bbqkuUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 4334 19th Street, San Francisco, CA, 94114
pba__address_pb__c, 4334 19th Street, San Francisco, CA, 94114
agent_only_remarks__c, Pre-Escrow opened with Bethe Battalio @ Fidelity National Title, FSFM-0062300234. Contact Mike for showings. Disclosures can be found at the following link: https://app.disclosures.io/link/4334-19th-Street-39gbam83
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Victorian;Traditional
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-27T00:48:58.000+0000
days_on_market__c, 64
dom__c, 57
ffd_description_pb, Nestled in the Castro neighborhood, this 4-bedroom, 2-bathroom home sprawls 2,248 square feet with a fantastic backyard and exceptional curb appeal. Built in 1905 the interiors showcase a convergence of timeless original charm with modern upgrades. Natural light pours into the living room, which features a gas fireplace, hardwood floors, and charming pocket doors that lead to the dining room with a built-in bar, stained glass accents, and French doors to the back deck. The beautifully upgraded kitchen is outfitted with high-end Viking stainless steel appliances including a wine fridge, a Sub-Zero refrigerator, Calacatta marble countertops, Waterworks finishes, and ample storage. Upstairs, retreat to privacy with 3 spacious bedrooms with plenty of closet space and a gorgeous bathroom with marble accents, dual sinks, and an expansive walk-in shower. The home's lower level offers a full bathroom, laundry, storage, a 1- car garage, and a bedroom with backyard access that could also be a media or recreation room. Relax in your private backyard sanctuary with magnificent trees, landscaping, green space, and a patio with a fire pit. With a 99 Walk Score enjoy restaurants, bars, shopping, groceries, public transportation, and parks in moments.
district__c, SF District 5
electric__c, 220 Volts,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s);Natural Gas;Fireplace Insert
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-05-27T00:48:10.000+0000
pba__latitude_pb__c, 37.7592437
pba__latitude_property__c, 37.7592437
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink
listed_date__c, 2023-03-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Annunziata
listing_agent_mls_id__c, 809778
ffd_listingagentname, Mike L Annunziata
listing_agent_number__c, 1043256
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, NORTH-PT
listing_office_name__c, North Point Real Estate
listing_office_number__c, 27699
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, https://4334-19th-street.com/
pba__longitude_pb__c, -122.4378833
lower_level__c, Bedroom(s),Family Room
mls_id__c, 423729308
main_level__c, Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Double Sinks;Marble
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-24
open_house_end__c, 2023-05-28T15:00:00.000+0000
open_house_start__c, 2023-05-28T13:00:00.000+0000
original_price__c, 3200000
overall_days_on_market__c, -81531
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Front Porch
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, 1332.3
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbqkuUAA
room_type__c, Living Room;Attic;Primary Bathroom
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, 2248
size__c, 2248
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, The Castro - Dolores Heights
ffd_name, 4334 19th Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings;Dual Pane Partial
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530594998-1.jpg