NY Property Records
118-38 197 Street
118-38 197 Street
Queens · Queens County · 11412
02 · Walk-Up AptsSold $590,000 · Jun 2007 ↗
Owner of record
OwnerColsmerk LLC
Assessment · 2025 roll
Land assessed$16,080
Total assessed$60,540
Est. annual tax$8,156 (2027, excl. special districts)
Building
StyleThree Families
Year built1930
Living area2,525 sq ft
Lot
Size0.11 acres (GIS)
Frontage × depth35 × 134 ft
Lot sq ft4,690
Zoning
DistrictR4A
FAR0.54 built · 1.0 max residential · 2.0 max facility
Zoning map19a
Recorded documents · 34
SATISFACTION OF MORTGAGE
Feb 24, 2025
mortgager/borrower Kissi, Emmanuel; Kumi, Mercy A
mortgagee/lender Deutsche Bank National Trust Company; Phh Mortgage Corporation +1
View on ACRIS ↗
DEED
$10
Feb 21, 2025
grantor/seller Kissi, Emmanuel; Kumi, Mercy A +1
grantee/buyer Colsmerk LLC
View on ACRIS ↗
MORTGAGE
$710,000
Feb 21, 2025
mortgagor/borrower Colsmerk LLC
mortgagee/lender Hometown Equity Mortgage, LLC; Mers
View on ACRIS ↗Show all 34
ASSIGNMENT, MORTGAGE
Jul 28, 2011
assignor/old lender Saxon Mortgage Services, Inc., A/K/A Smi Mortgage
assignee/new lender Deutsche Bank National Trust Company
View on ACRIS ↗
DEED
$590,000
Jul 30, 2007
grantor/seller Roberts, Clive
grantee/buyer Kissi, Emanuel; Kumi, Mercy
View on ACRIS ↗
MORTGAGE
$501,500
Jul 30, 2007
mortgagor/borrower Kissi, Emanuel; Kumi, Mercy A
mortgagee/lender Smi Mortgage
View on ACRIS ↗
MORTGAGE AND CONSOLIDATION
$155,000
Oct 30, 2006
mortgagor Roberts, Clive
mortgagee Qside Federal Credit Union
View on ACRIS ↗
MORTGAGE
$105,000
Oct 6, 2006
mortgagor/borrower Roberts, Clive
mortgagee/lender Qside Federal Credit Union
View on ACRIS ↗
SATISFACTION OF MORTGAGE
Oct 6, 2006
mortgager/borrower Roberts, Clive; Roberts, Diana
mortgagee/lender Qside Federal Credit Union
View on ACRIS ↗
DEED
Oct 2, 2006
grantor/seller Roberts, Clive; Roberts, Diana
grantee/buyer Roberts, Clive
View on ACRIS ↗
SATISFACTION OF MORTGAGE
Jun 23, 2003
mortgager/borrower Roberts, Clive; Roberts, Diana
mortgagee/lender Alliance Mortgage Banking Corp
View on ACRIS ↗
MORTGAGE
$27,000
Aug 5, 2002
mortgagor/borrower Roberts, Clive
mortgagee/lender Waterside Frderal Credit Union
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Mar 9, 2001
assignor/old lender First Union Mtge
assignee/new lender Chase Manhattan Mtge
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Feb 8, 2001
assignor/old lender First Union Mortgagecorporation
assignee/new lender Chase Manhattan Mortgage Corporation
View on ACRIS ↗
SATISFACTION OF MORTGAGE
Jun 20, 2000
mortgager/borrower Haltaufderhyde, Rayeal Etal
mortgagee/lender Residential Mortgagebanking Inc.
View on ACRIS ↗
DEED
Jan 28, 2000
grantor/seller Haltaufderhyde, Gwendolyn; Haltaufderhyde, Rayeal
grantee/buyer Roberts, Clive; Roberts, Diana
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Jan 28, 2000
assignor/old lender Alliance Mortgage Banking Corp
assignee/new lender First Union Mortgagecorp
View on ACRIS ↗
MORTGAGE
$240,747
Jan 28, 2000
mortgagor/borrower Roberts, Clive; Roberts, Diana
mortgagee/lender Alliance Mortgage Banking Corp
View on ACRIS ↗
AGREEMENT
Oct 6, 1998
party 1 Roslyn National Mortgage Corporation
party 2 Haltaufderhyde, Gwendolyn; Haltaufderhyde, Rayeal
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Aug 31, 1995
assignor/old lender Residential Mortgagebanking Inc
assignee/new lender Residential First Inc
View on ACRIS ↗
SATISFACTION OF MORTGAGE
Feb 22, 1995
mortgager/borrower Haltaufderhyde, Rayeal Etal
mortgagee/lender Mid-Island Equitiescorporation
View on ACRIS ↗
SATISFACTION OF MORTGAGE
Jun 20, 1994
mortgager/borrower Haltaufderhyde, Rayeal Etal
mortgagee/lender Chemical Bank
View on ACRIS ↗
MORTGAGE
$150,000
Jun 20, 1994
mortgagor/borrower Haltaufderhyde, Gwendolyn; Haltaufderhyde, Rayeal
mortgagee/lender Residential Mortgagebanking Inc
View on ACRIS ↗
SATISFACTION OF MORTGAGE
May 9, 1989
mortgager/borrower Haltaufderhyde,Rayeal
mortgagee/lender Dartmouth Plan,Inc
View on ACRIS ↗
MORTGAGE
$70,000
Apr 19, 1989
mortgagor/borrower Haltaufderhyde, Rayeal; Haltaufderhyde,Gwendolyn
mortgagee/lender Chemical Bank
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Dec 1, 1987
assignor/old lender Richard Gill Company
assignee/new lender Bancplus Mtge Corp
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Apr 12, 1985
assignor/old lender First Fed S&L Assn/Roch; Ninth Fed S&L Assn Fka
assignee/new lender Richard Gill Company
View on ACRIS ↗
MORTGAGE
$12,250
Jun 27, 1984
mortgagor/borrower Haltaufderhyde, Rayeal; Haltaufderhyde,Gwendolyn
mortgagee/lender Dartmouth Plan, Inc.
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Jun 27, 1984
assignor/old lender Dartmouth Plan, Inc
assignee/new lender Citibank, Na
View on ACRIS ↗
ASSIGNMENT, MORTGAGE
Mar 27, 1978
assignor/old lender Mid Island Equities Corp
assignee/new lender Ninth Fed Savs & Loan Assn Of Ny City
View on ACRIS ↗
DEED
Mar 5, 1978
grantor/seller Palmer Dottry; Palmer Gracie
grantee/buyer Gwendolyn Haltaufderhyde; Rayeal Haltaufderhyde
View on ACRIS ↗
MORTGAGE
Mar 5, 1978
mortgagor/borrower Haltaufderhyde Gwendolyn; Haltaufderhyde Rayeal
mortgagee/lender Mid Island Equities Corp
View on ACRIS ↗
MORTGAGE
Jul 26, 1971
mortgagor/borrower Palmer Dottry; Palmer Gracie
mortgagee/lender Jamaica Savings Bank
View on ACRIS ↗DOB violations — total 1 · open 1 · dismissed 0
Gas Piping - LL152
Active
Jan 31, 2025
BIS ↗DOB complaints — total 9 · open 0 · closed 9
Show all 9
HPD violations — total 19 · open 14 · closed 5
I · Order to correct
Closed
Nov 25, 2025
§27-2107 ADM CODE OWNER FAILED TO FILE A VALID REGISTRATION STATEMENT WITH THE DEPARTMENT AS REQUIRED BY ADM CODE §27-2097 AND IS THEREFORE SUBJECT TO CIVIL PEN
HPD ↗
I · Order to correct
Closed
Mar 17, 2022
§27-2107 ADM CODE OWNER FAILED TO FILE A VALID REGISTRATION STATEMENT WITH THE DEPARTMENT AS REQUIRED BY ADM CODE §27-2097 AND IS THEREFORE SUBJECT TO CIVIL PEN
HPD ↗
I · Order to correct
Closed
Apr 22, 2021
§27-2107 ADM CODE OWNER FAILED TO FILE A VALID REGISTRATION STATEMENT WITH THE DEPARTMENT AS REQUIRED BY ADM CODE §27-2097 AND IS THEREFORE SUBJECT TO CIVIL PEN
HPD ↗Show all 19
I · Order to correct
Closed
Nov 8, 2019
§27-2107 ADM CODE OWNER FAILED TO FILE A VALID REGISTRATION STATEMENT WITH THE DEPARTMENT AS REQUIRED BY ADM CODE §27-2097 AND IS THEREFORE SUBJECT TO CIVIL PEN
HPD ↗
I · Order to correct
Closed
Nov 1, 2018
§27-2107 ADM CODE OWNER FAILED TO FILE A VALID REGISTRATION STATEMENT WITH THE DEPARTMENT AS REQUIRED BY ADM CODE §27-2097 AND IS THEREFORE SUBJECT TO CIVIL PEN
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2073 ADM CODE - PROVIDE AN ADEQUATE SUPPLY OF GAS TO THE FIXTURES GAS-RANGE IN THE KITCHEN LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: PROPERLY SECURE THE LOOSE RADIATOR IN THE SOUTHWEST BEDROOM LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPAIR THE BROKEN OR DEFECTIVE PLASTERED SURFACES AND PAINT IN UNIFORM COLOR WALLS AND CEILING IN THE SOUTHWEST BEDROOM LOCATED AT APT 1,
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: PROPERLY REPAIR WITH SIMILAR MATERIAL THE BROKEN OR DEFECTIVE WOOD FLOOR IN THE SOUTHWEST BEDROOM LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2026, 2027 HMC: PROPERLY REPAIR THE SOURCE AND ABATE THE EVIDENCE OF A WATER LEAK CEILING. IN THE KITCHEN LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPAIR THE BROKEN OR DEFECTIVE PLASTERED SURFACES AND PAINT IN UNIFORM COLOR WALLS AND CEILING. IN THE KITCHEN LOCATED AT APT 1, 1st STOR
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: PROPERLY REPAIR WITH SIMILAR MATERIAL THE BROKEN OR DEFECTIVE CERAMIC TILE FLOOR. IN THE BATHROOM LOCATED AT APT 1, 1st STORY
HPD ↗
A · Non-hazardous
Open
Sep 8, 2017
§ 27-2026 ADMIN. CODE: RESET, SO AS TO SECURE A PROPER AND TIGHT CONNECTION, THE WATER CLOSET BOWL .. IN THE BATHROOM LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPAIR THE BROKEN OR DEFECTIVE PLASTERED SURFACES AND PAINT IN UNIFORM COLOR WALLS AND CEILING. IN THE BATHROOM LOCATED AT APT 1, 1st STO
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2026 ADMIN. CODE: REMOVE ALL OBSTRUCTIONS AND REPAIR ALL DEFECTS IN BATHTUB IN THE BATHROOM LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPAIR THE BROKEN OR DEFECTIVE PLASTERED SURFACES AND PAINT IN UNIFORM COLOR EAST WALL. IN THE 3rd LIVING ROOM FROM EAST LOCATED AT APT 1
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2026, 2027 HMC: PROPERLY REPAIR THE SOURCE AND ABATE THE EVIDENCE OF A WATER LEAK CEILING IN THE 2ND ROOM FROM FRONT LOCATED AT APT 1, 1st STORY
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPAIR THE BROKEN OR DEFECTIVE PLASTERED SURFACES AND PAINT IN UNIFORM COLOR CEILING IN THE 2NDROOM FROM FRONT. LOCATED AT APT 1, 1st STO
HPD ↗
B · Hazardous
Open
Sep 8, 2017
§ 27-2005 ADMIN. CODE: REPLACE WITH NEW THE MISSING DOOR BETWEEN FRONT ROOM AND 2NDROOM FROM THE FRONT. LOCATED AT APT 1, 1st STORY
HPD ↗Deed & identifiers
SBL4126210025
SWIS630100
Parcel ID6301004126210025
Who owns 118-38 197 Street?
118-38 197 Street, Queens is owned by Colsmerk LLC per the 2025 NYS assessment roll. It last sold for $590,000 in Jun 2007.
Nearby on 197 Street
Public record, NYS tax roll 2025. Values are the assessor's, not an appraisal. Provided for informational purposes only — accuracy and completeness are not warranted or guaranteed; verify against official sources before relying on it. Disclaimer · Request redaction
Search by name or address · Browse all records