meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='334757' 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] => 2024-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[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, 75 Caselli Avenue, San Francisco, CA, 94114
ffd_mls_id, 423739518
ffd_salesforce_id, a0E8W00000awfHGUAY
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 75 Caselli Avenue, San Francisco, CA, 94114
pba__address_pb__c, 75 Caselli Avenue, San Francisco, CA, 94114
agent_only_remarks__c, Text Listing Agent Mark Anthony Venegas with Desert Sotheby's International Realty at 415.955.7968 for a private showing. Buyers will have to pay and do their own inspections. Seller will not be provided any type of credits. Again, Seller Selling As Is. Seller is expecting a strong offer, no contingencies and a fast closing. Pre escrow has been opened with Mary Ann Bunnell, DOMA Title of California (formerly known as North American Title Company), 689 Portola Drive, San Francisco, CA 94127. Please reach out with any questions relative to title or escrow matters at [email protected] Click here for disclosures: https://app.disclosures.io/link/75-Caselli-Avenue-r4z84tav
appliances__c, Microwave;Disposal;Free Standing Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Ice Maker
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1918
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Eduardo Campos
pba__contingentdate__c, 2023-06-08
cooling__c, None
ffd_createddate, 2023-05-25T20:48:53.000+0000
days_on_market__c, 55
dom__c, 15
ffd_description_pb, One of the most sought-after neighborhoods-Eureka Valley! 75 Caselli Ave home has not been on the market for over 50 years! Built 1918. This is an amazing property to create your dream home and or move in ready. Located on an exclusive tree lined street. These types of homes rarely come on the market, so this is a great opportunity for a buyer. Moments from the heart of it all but situated just far enough away to give a wonderful sense of serenity. Walking distance to the Castro and Noe Neighborhoods. Kite Hill Park is around the corner. Beautiful views from both levels of the home. First floor consists of living room, dining room, informal dining area, back patio for outdoor living and large backyard. One car garage that fits a mid-size BMW 3 Series. Second level consists of 4 large bedrooms and one bath. The back bedroom that is currently staged as an office can be the second bathroom with city approvals. Seller is Selling "As Is". Seller is expecting a strong offer with no contingencies and a 30-day close. Buyers will need to do their own home and termite inspections. Selling Agents can provide a list of vendors for the inspections. Visit: https://75caselliavenue1801297.f8re.com/Website/Index
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Decorative Only;Brick
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Fireplace Insert
ffd_lastmodifieddate, 2023-07-13T19:30:25.000+0000
pba__latitude_pb__c, 37.7595684
pba__latitude_property__c, 37.7595684
laundry_features__c, In Basement
listed_date__c, 2023-05-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Venegas
listing_agent_mls_id__c, 808359
ffd_listingagentname, Mark A Venegas
listing_agent_number__c, 1033957
listing_co_agent_mls_id__c, 816698
listing_co_agent_number__c, 1075648
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, DSIR01
listing_office_name__c, Desert Sotheby's International Realty
listing_office_number__c, 28958
pba__listingprice_pb__c, 2300000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/830889097
pba__longitude_pb__c, -122.440647
lower_level__c, Garage
mls_id__c, 423739518
main_level__c, Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub w/Shower Over;Tile;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-25
original_price__c, 2300000
overall_days_on_market__c, -81593
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-07-11T12:16:14.000+0000
price_per_square_foot__c, 1189.19
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000awfHGUAY
room_type__c, Storage;Kitchen;Living Room;Dining Room;Possible Guest;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2023-07-11
sale_price__c, 2200000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 802874
selling_agent_number__c, 802874
selling_co_agent_mls_id__c, 803793
selling_co_agent_number__c, 803793
selling_co_office_mls_id__c, COMP12
selling_co_office_name__c, Compass
selling_co_office_number__c, 28739
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1850
size__c, 1850
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Caselli
subdist__c, The Castro - Dolores Heights
ffd_name, 75 Caselli Avenue, San Francisco, CA, 94114
view__c, City
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1918
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530613859-1.jpg