Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:03:15.780' ,`MLSNumber` = '68476184' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Shijimon Jacob' ,`SellingOfficeName` = 'Everest Realty' ,`Latitude` = '29.481167' ,`Longitude` = '-95.535197' ,`PhotoCount` = '5' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '634987.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Laurel Crest' ,`StreetNumber` = '8807' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation A). CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious walk-in closet downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Game Room upstairs with private Media Room. Covered patio and attached 2-car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7816' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '205067626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:02:47.810' ,`MLSNumber` = '50030419' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Dana Johnson' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.472214' ,`Longitude` = '-95.529360' ,`PhotoCount` = '24' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '693957.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1907' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation B) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious walk-in closet downstairs. Formal Dining Room and Living Room/Study with spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Covered back patio and attached 2-car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8321' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207148889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:02:24.427' ,`MLSNumber` = '80994913' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ced Thomas' ,`SellingOfficeName` = 'Legacy Homes & Properties, LLC' ,`Latitude` = '29.472188' ,`Longitude` = '-95.529335' ,`PhotoCount` = '7' ,`PostalCode` = '77459' ,`RoomCount` = '18' ,`ListPrice` = '748138.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation KP) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 3 car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8882' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207151525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:00:10.770' ,`MLSNumber` = '69898797' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472406' ,`Longitude` = '-95.529437' ,`PhotoCount` = '26' ,`PostalCode` = '77459' ,`RoomCount` = '18' ,`ListPrice` = '714557.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8776' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207159355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:02:04.240' ,`MLSNumber` = '21003956' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ayodeji Bamijoko' ,`SellingOfficeName` = 'Fairdale Realty' ,`Latitude` = '29.472997' ,`Longitude` = '-95.529637' ,`PhotoCount` = '28' ,`PostalCode` = '77459' ,`RoomCount` = '18' ,`ListPrice` = '739000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1927' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation F) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 7 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8508' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207160011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:01:41.840' ,`MLSNumber` = '81754136' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Geron Fuller' ,`SellingOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`Latitude` = '29.473113' ,`Longitude` = '-95.529647' ,`PhotoCount` = '12' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '729587.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1931' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation B) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Elegant double front door entry. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Extended covered patio and attached 2 car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8555' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207181005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:01:09.593' ,`MLSNumber` = '87663627' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ishme Allah' ,`SellingOfficeName` = 'Village Property Advisors' ,`Latitude` = '29.472868' ,`Longitude` = '-95.533988' ,`PhotoCount` = '26' ,`PostalCode` = '77459' ,`RoomCount` = '17' ,`ListPrice` = '743861.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bayou Springs' ,`StreetNumber` = '9015' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 13 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11306' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703333' WHERE `Matrix_Unique_ID` = '207182114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:00:52.233' ,`MLSNumber` = '97318126' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Markeith Spears' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.472868' ,`Longitude` = '-95.533972' ,`PhotoCount` = '14' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '759963.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bayou Springs' ,`StreetNumber` = '9002' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation B) Two Story. 4 bedrooms, 3.5 baths. Elegant double front door entry. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Extended covered patio and attached 2 car garage. When you buy a home in Sienna Plantation, you enjoy an impressive array of amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna and more. You also have immediate access to shopping, dining and professional services. Stop by the Westin Homes model home today to find out more about Sienna!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10295' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '207283687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:06:25.607' ,`MLSNumber` = '25259230' ,`ListAgentFullName` = 'Roxane Richardson' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.758708' ,`Longitude` = '-95.184881' ,`PhotoCount` = '45' ,`PostalCode` = '77364' ,`RoomCount` = '4' ,`ListPrice` = '945000.00' ,`Status` = 'Active' ,`StreetName` = 'West Lake Circle' ,`StreetNumber` = '141' ,`StreetSuffix` = '' ,`City` = 'Point Blank' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There are aspects that you can change about a property, but one thing you cannot change is the LOCATION! There is NOTHING COMPARABLE on LAKE LIVINGSTON or on most all lakes in TEXAS for that matter.This property consists of 3 adjoining lots.OVER 1 ACRE OF WATERFRONT LAND situated longitudinally on the lake instead of transversely,225\'STEEL & CONCRETE BULKHEAD all DEEP WATER. Part of the big, deep WATER VIEW has no land in sight.PUSH THE NEIGHBORS AWAY. There are 13 BEAUTIFUL MATURE LIVE OAKS, & 3 MATURE PECAN TREES on the property.This FANTASTIC WATERFRONT ACRE includes it\'s very own concrete boat launch capable of accommodating large boats.An 8 inch thick concrete retaining wall surrounding the home & parking area secures the house 10\' above the lawn for IMPECCABLE VIEWS, especially from the LARGE COVERED BACK PORCH.This is what awaits you at this location.NATURAL BEAUTY, PEACEFUL SETTING, VIEWS YOU CAN STARE AT ALL DAY, BREATHTAKING SUNSETS, & ONLY ONE LIKE IT ON THE ENTIRE LAKE!!' ,`Acres` = '1.03' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Point Lookout West #1 Block 5 Lots 15-17' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '45000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '286' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Point Lookout West' ,`TaxAmount` = '6450' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '207332386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:19:52.417' ,`MLSNumber` = '54215126' ,`ListAgentFullName` = 'Saira Alvarez' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521048' ,`Longitude` = '-95.441594' ,`PhotoCount` = '9' ,`PostalCode` = '77545' ,`RoomCount` = '3' ,`ListPrice` = '129999.00' ,`Status` = 'Active' ,`StreetName` = 'Renfro Burford' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Road' ,`City` = 'Fresno' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRING ALL OFFERS*SOLD AS-IS:SELLER WILL NOT MAKE ANY REPAIRS* This property has 9000sqft lot, house is 900sqft 2-bed/1 bath currently not in livable condition. Possibly could be renovated. Great opportunity for investors! Mobile homes accepted. No restrictions** All room measurements are approximate and need to be verified independently. Seller has no survey, buyer to purchase a new survey if necessary.\r\n\r\n**Seller is also selling LOT next to it **\r\nParcel ID 6400-00-028-0800-907 Lot Sq Ft 9,525. Legal Description RIDGEWOOD ESTATES, BLOCK 28, LOT 8**' ,`Acres` = '0.2066' ,`Area` = '38' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'RIDGEWOOD ESTATES, BLOCK 28, LOT 2/3 OF 9, PART IN FT BEND C' ,`LotDesciption` = 'Other' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Estates' ,`TaxAmount` = '2397' ,`TaxRate` = '2.7629' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '208197920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:58:45.407' ,`MLSNumber` = '13070669' ,`ListAgentFullName` = 'Khalil Khalil' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771827' ,`Longitude` = '-95.407513' ,`PhotoCount` = '13' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Nett' ,`StreetNumber` = '4611' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this stunning 3- 3.1/2 **Brand new**, **never lived**, **standalone** single family home in the heart of Houston, Modern design inside out, minutes from downtown, memorial park, galleria, memorial mall. Featuring stucco exterior wall, top floor balcony overlooking downtown Houston, tile flooring, Quartz countertop, brand new appliances, Fridge, Oversize oven/range, microwave, washer and dryer, dishwasher. All bedrooms have their own private bathroom. Master bath features Separate frameless shower and standalone tub. please confirm rooms dimension' ,`Acres` = '0.0483' ,`Area` = '16' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 NETT STREET LANDING' ,`LotDesciption` = 'Corner' ,`LotSize` = '2105' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'NETT STREET LANDING' ,`TaxAmount` = '7765' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '208526955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:07:30.690' ,`MLSNumber` = '77169214' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.424813' ,`Longitude` = '-95.312533' ,`PhotoCount` = '45' ,`PostalCode` = '77378' ,`RoomCount` = '8' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Springs' ,`StreetNumber` = '21' ,`StreetSuffix` = 'Trail' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peach Creek Farms is a new custom home development in Willis with 32 beautiful 1-to-6-acre parcels. This luxury Barndominium designed by Our Barndominium Life\'s Stacee Lynn boasts beautiful finishings throughout. Well appointed layout has the primary bedroom on the 1st level, high ceilings in great room/kitchen combo area with 14\'x12\' garage door opening to a show stopping oversized covered patio featuring large outdoor fireplace, outdoor kitchen and tongue and groove wood ceiling. Study with glass door entrance, large upstairs bonus room with full bath, 4 built-in beds and kitchenette, wood beams and rear glass door sliders to back patio and gazebo. Spacious kitchen with massive island and farm sink, shaker kitchen cabinets, painted brick backsplash, large walk in pantry and matte black Z Line appliance package including refrigerator.Mud room with full wall custom built-in for ample storage. It is time to start your new Barndominium life! 24x40 steel frame garage plumber ToBeBuilt.' ,`Acres` = '1' ,`Area` = '64' ,`BuilderName` = 'Hycraft Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PEACH CREEK FARMS, LOT 31, ACRES 1.0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Barndominium' ,`Subdivision` = 'Peach Creek Farms' ,`TaxAmount` = '1175' ,`TaxRate` = '1.9577' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '208539652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:02:58.900' ,`MLSNumber` = '20203414' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '24' ,`PostalCode` = '77378' ,`RoomCount` = '5' ,`ListPrice` = '266790.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Cavern' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view the modern 3 bedroom 2 bath Taft plan has many unique features such as a study, 9\' ceilings throughout, granite kitchen counters, 42\" kitchen cabinets and a gas stove. Stainless Steel Appliances, Luxury vinyl plank flooring, dual sinks in primary bath w/ separate tub and shower. This home is very energy efficient and has CAT 6 internet wiring and Smart Home Options. Cozy community with a grand entrance. The neighborhood is nestled in mature trees. Located right off I-45 North of the Woodlands/Conroe. Call today to for a personal tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '28402' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '208972142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:55:16.700' ,`MLSNumber` = '42702222' ,`ListAgentFullName` = 'Elizabeth Ferrari' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.457100' ,`Longitude` = '-96.070860' ,`PhotoCount` = '28' ,`PostalCode` = '75831' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Commerce' ,`StreetNumber` = '942' ,`StreetSuffix` = 'Street' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENDLESS POSSIBILITIES in this CUTE 2b2b on .646ac approx with detached carport with mini-office or storage area. Zoned residential with approx 240ft of Hwy 79 road frontage making this an excellent home-based business or store-front option. Landscaping in front welcomes visitors and clients alike with plenty of parking. Updated electric, plumbing with tank-less hot water, roof, flooring, paint, fixtures and high eff window screens between 2014-2019. The kitchen has built-ins, coffee nook and pass-through 4-seat counter overlooking the dining area with adjoining living room. Primary has full bath and access to the back patio to enjoy mornings and evenings gazing at the great back yard. Survey required. Additional acreage up to 5ac approx available separately. A portion of the far West corner of the drive-way is in the 100 year flood zone. Seller to retain minerals if owned. Measurements are approx, buyer and agent to verify all data.' ,`Acres` = '0.6457' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MERRILL HEIGHTS BLK 4 LOTS 1-4 & 1/2 OF LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '28127' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Merrill Heights' ,`TaxAmount` = '1292' ,`TaxRate` = '2.2532' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '209171240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:36:46.153' ,`MLSNumber` = '37201889' ,`ListAgentFullName` = 'Kaila Yuille' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802879' ,`Longitude` = '-95.421425' ,`PhotoCount` = '36' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '438000.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '1225' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in this beautiful and spacious free standing 3 bed/3.5 bath home in a gated community in the Heart of Shady Acres! Open concept kitchen and living area with high ceilings, natural light and 8 foot doors throughout. Kitchen with large island and quality granite countertops, SS appliances and tile backsplash. Large primary bedroom and en suite with 2 closets, walk in shower and large soaking tub. Private backyard with green space for pets, added on patio perfect for outdoor dining and entertaining. Blocks away from several neighborhood friendly restaurants, patio/pet friendly bars, walking/biking trails and the Heights HEB!' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Drake Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 LANDING AT NINETEENTH AMEND & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Landing at 19th' ,`TaxAmount` = '9215' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703334' WHERE `Matrix_Unique_ID` = '209301584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:19:27.130' ,`MLSNumber` = '29991283' ,`ListAgentFullName` = 'Saira Alvarez' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577781' ,`Longitude` = '-95.373687' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Birchview' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly renovated home is a 55+ community (ONE RESIDENT MUST BE 55 OR OVER). No residents under age 18. home is nestled in the desirable Countryplace 55+ active adult Pearland Golf Club community with easy access to shopping, medical center and many other Houston metro areas. 24-7 manned security gate. Home sits on a corner cul-de-sac. Overall amenities include carpet and tile floors, ceiling fans. Kitchen with electric stove, dishwasher and dual stainless sink and breakfast area, utility room in the home. Spacious great room space off the Kitchen for the Dining and Family room. Primary and Full bath includes combined tub / shower. Sit and relax with a morning cup of coffee or evening beverage on the back closed patio. Community amenities pool, tennis and more. Golf course available.' ,`Acres` = '0.182' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 6 LOT 16' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '4665' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '209377019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:32:54.173' ,`MLSNumber` = '88018944' ,`ListAgentFullName` = 'Fay Castleberry' ,`ListOfficeName` = 'Trinity County Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.946284' ,`Longitude` = '-95.376820' ,`PhotoCount` = '35' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'W Caroline Street' ,`StreetNumber` = '200' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Very Unique Duplex Style Home has 3 Bedrooms and 2 Baths on the First Floor, a Double front Door Entry, with a Split Living Area, and Built-In Shelving. The Laundry Room is also Located on the First Floor, His/Her Style Closets in the Primary Bedroom and a Private Bathroom. The Second Floor has Central A/C, Livingroom, Kitchen, Bathroom with a Tile Walk-In Shower, Bedroom with Extra Room. This Home has Recent Exterior and Interior Paint, New Flooring (Carpet & Laminate), New Kitchen Cabinets, and New Roof. Call Today For More Details and To Book Your Appointment!' ,`Acres` = '0.26' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRINITY, CITY OF, BLOCK 17 LOT 2 W 25 FT OF, 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Trinity City Of' ,`TaxAmount` = '782' ,`TaxRate` = '2.5001' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '210139132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:01:36.563' ,`MLSNumber` = '61212019' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '19' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '259960.00' ,`Status` = 'Active' ,`StreetName` = 'Ashwood Glade' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view the modern Becket plan featuring 3 bedroom 2 bath home with 9\' ceilings throughout, granite kitchen counters, 42\" kitchen cabinets and a gas stove. Luxury vinyl plank flooring, dual sinks in primary bath w/ extended shower. This home is very energy efficient and has CAT 6 Internet wiring and Smart Home Options. Cozy community with a grand entrance. The neighborhood is nestled in mature trees. Located right off I-45 North of the Woodlands/Conroe. Call today to for a personal tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '05401' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '210283493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:36:12.473' ,`MLSNumber` = '60540341' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.836860' ,`Longitude` = '-95.168575' ,`PhotoCount` = '12' ,`PostalCode` = '77049' ,`RoomCount` = '10' ,`ListPrice` = '374990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fairy Tern' ,`StreetNumber` = '14810' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Make new memories in this amazing Lake Ridge Builders home in Edgewood Village. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, sprinkler system, wrought iron spindles, a direct vent fireplace, a spacious foyer, and a covered patio. The incredible open concept kitchen is equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Located off Hwy 80 and Beltway 8, residents enjoy easy access to Downtown Houston, popular shopping malls, and major business centers. Nearby schools are zoned to Sheldon ISD. Don’t wait any longer – call today for more info!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Village' ,`TaxAmount` = '' ,`TaxRate` = '3.629307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '210395480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:04:37.037' ,`MLSNumber` = '12826941' ,`ListAgentFullName` = 'Jim Sheppard' ,`ListOfficeName` = 'Jim Sheppard ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590721' ,`Longitude` = '-95.236547' ,`PhotoCount` = '40' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Sageyork' ,`StreetNumber` = '10706' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated Kitchen, guest bath and 2 new toilets. Ceramic floor tile throughout! The exterior is brick and cedar and all other wood on this home, and under the eaves, have been replaced with “HardiePlank Fiber Cement Lap Siding”. The roof was replaced on October 2017 with “30 Year Owens Corning Duration Series”. This home has one of the largest front and back yards in the area, perfect for a pool! This home has never flooded.' ,`Acres` = '0.1848' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 14 KIRKWOOD SOUTH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kirkwood South' ,`TaxAmount` = '4707' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '210440507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:02:13.880' ,`MLSNumber` = '18422312' ,`ListAgentFullName` = 'Christopher Newton' ,`ListOfficeName` = 'O\'Hara & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.065973' ,`Longitude` = '-96.201667' ,`PhotoCount` = '41' ,`PostalCode` = '77871' ,`RoomCount` = '7' ,`ListPrice` = '157500.00' ,`Status` = 'Active' ,`StreetName` = 'Warrior' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Lane' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on 4000+ acres, Hilltop Lakes offers owners the best of the country, close to the city. Amenities include: Golf Course, Putt Putt, Disc Golf, Post Office, Restaurant, Swimming Pool, Lakes, Private Airfield, Lodging and Parks, all surrounded by abundant wildlife. 14 Warrior sits on a double lot, just a short walk to the lake. Open floorplan features beautiful tile throughout the kitchen and family area with tons of natural light. 2 bedrooms down and 2 additional bedrooms up adds to the flexibility for a variety of uses. Large Utility Room/1/2 Bathroom could easily be converted to a 2nd full bath, or leave it as is for extra storage. SALE also includes lot #7 adjacent to lot #6 - Please independently verify all home/lot dimensions, neighborhood fees/info and school district information.' ,`Acres` = '0.3058' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 71 BLK 1 LT 6' ,`LotDesciption` = 'Airpark,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '13319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilltop Lakes' ,`TaxAmount` = '1870' ,`TaxRate` = '1.8865' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703335' WHERE `Matrix_Unique_ID` = '210456532' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:34:00.253' ,`MLSNumber` = '21789057' ,`ListAgentFullName` = 'Dionne Randle' ,`ListOfficeName` = 'MOD Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.418627' ,`Longitude` = '-95.626039' ,`PhotoCount` = '46' ,`PostalCode` = '77356' ,`RoomCount` = '14' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterford' ,`StreetNumber` = '150' ,`StreetSuffix` = 'Way' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning lakefront property is in the stellar and highly sought-after Bentwater community! Step inside to soaring vaulted ceilings, a double entry staircase, 9-foot doors, crown molding, hardwood flooring, a custom kitchen that opens to the family room, stainless appliances, a double oven, a walk-in pantry, and a butlers pantry, recessed lighting sets the mood for this luxurious home, oversized laundry area with additional storage. The primary suite has tray ceilings with lighting, and access to the backyard oasis. The primary bath has custom built-ins for extra storage, double sinks, and a huge closet. Vacation in your backyard with the fire pit, the cozy heated pool, and covered patio. 2 Secondary beds with balcony access overlooking the backyard. Upgrades include. Boat dock and lift, jet skis dock and lift, New Roof 2022, Exterior paint 2022, nest thermostat, dishwasher 2021, pool heater 2021, A/C Units 2017 and 2021, gated community, and Masters Golf Membership (fees not incl)' ,`Acres` = '0.2216' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 06, BLOCK 5, LOT 25' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '9652' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Bentwater 06' ,`TaxAmount` = '15509' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '210467054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:23:12.077' ,`MLSNumber` = '38029956' ,`ListAgentFullName` = 'Luis Garza' ,`ListOfficeName` = 'The Horizon Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.384854' ,`Longitude` = '-94.899673' ,`PhotoCount` = '7' ,`PostalCode` = '77590' ,`RoomCount` = '2' ,`ListPrice` = '60000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0594' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 6 E 34.5 FT OF LOT S 14 THRU 16 (14-2) BLK 58' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2587' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '831' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '210945927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:03:17.477' ,`MLSNumber` = '67234764' ,`ListAgentFullName` = 'Reyna Portillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600093' ,`Longitude` = '-95.212687' ,`PhotoCount` = '25' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehollow' ,`StreetNumber` = '11618' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'welcome to 11618 , This home has been beautifully remodeled . Bring your picky buyers and schedule a viewing soon.' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 12 SAGEMONT SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sagemont Sec 03' ,`TaxAmount` = '3773' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '211321873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:44:33.200' ,`MLSNumber` = '50895910' ,`ListAgentFullName` = 'Robert Griffith' ,`ListOfficeName` = 'Circa Real Estate' ,`SellingAgentFullName` = 'Emily Johnson' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.060961' ,`Longitude` = '-95.383845' ,`PhotoCount` = '24' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Farm Hill' ,`StreetNumber` = '23818' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spring Schools! Charming 3/2 home with open floor plan in convenient, established North Spring! Lots of updates: 2017: New roof, re-piping, HVAC duct replacement, new water heater, new furnace, new breaker box, exterior was painted (per previous owner.) 2019: New vinyl wood plank flooring, refurbished cabinets, interior paint, new window blinds (per owner.) Utility/Mud room in-house. Large closets. Detached Garage. So much potential to make this your showplace! Two yards! Courtyard area is perfect for grilling, chilling, or hanging out with friends. Back yard is great for pets, games, or a pool! Add French doors to primary bedroom going out to your pool, hot tub or garden. So many possibilities! Come have a look for yourself, this gem is in a lovely neighborhood with mature trees, nice streets, and large yards. Make your appointment today!' ,`Acres` = '0.1746' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 7 NORTH SPRING SEC 1 U/R & R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7605' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'North Spring Sec 01 U/R & R/P' ,`TaxAmount` = '4318' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '211343312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:00:22.843' ,`MLSNumber` = '88548619' ,`ListAgentFullName` = 'Julian Moreno' ,`ListOfficeName` = 'Acres Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927786' ,`Longitude` = '-95.486587' ,`PhotoCount` = '23' ,`PostalCode` = '77086' ,`RoomCount` = '4' ,`ListPrice` = '234000.00' ,`Status` = 'Active' ,`StreetName` = 'Coralstone' ,`StreetNumber` = '10306' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'She\'s a BEAUTY! Charming property on Coralstone Rd. is ready for its debut before summer ends! This recently renovated home offers 3 bedrooms and 2 baths; the home has been recently painted, had new floors installed, upgraded its kitchen and bathrooms with new cabinets and granite countertops. Offers big yards for your family and guests to enjoy these last couple weeks of summer and years to come. Schedule your private showing today!' ,`Acres` = '0.1515' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 12 NORTHWEST PARK SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Northwest Park Sec 01' ,`TaxAmount` = '3262' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '211358934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:00:44.570' ,`MLSNumber` = '74224050' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '38' ,`PostalCode` = '77378' ,`RoomCount` = '5' ,`ListPrice` = '297990.00' ,`Status` = 'Active' ,`StreetName` = 'Ashwood Glade' ,`StreetNumber` = '131' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1677' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready Hewitt plan featuring 4 bedrooms 2 bathrooms home offers 9\' ceilings throughout, granite kitchen counters, 42\" kitchen cabinets and a gas stove. Luxury vinyl plank flooring, dual sinks in primary bath w/ extended shower. This home is very energy efficient and has CAT 6 Internet wiring and Smart Home Options. Cozy community with a grand entrance. The neighborhood is nestled in mature trees. Located right off I-45 North of the Woodlands/Conroe. Call today to for a personal tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '11301' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '211364299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:00:29.487' ,`MLSNumber` = '49875165' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '38' ,`PostalCode` = '77378' ,`RoomCount` = '5' ,`ListPrice` = '274480.00' ,`Status` = 'Active' ,`StreetName` = 'Ashwood Glade' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1677' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready Hewitt plan featuring 4 bedrooms 2 bathrooms home offers 9\' ceilings throughout, granite kitchen counters, 42\" kitchen cabinets and a gas stove. Luxury vinyl plank flooring, dual sinks in primary bath w/ extended shower. This home is very energy efficient and has CAT 6 Internet wiring and Smart Home Options. Cozy community with a grand entrance. The neighborhood is nestled in mature trees. Located right off I-45 North of the Woodlands/Conroe. Call today to for a personal tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '13301' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703336' WHERE `Matrix_Unique_ID` = '211365352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:59:55.213' ,`MLSNumber` = '43936209' ,`ListAgentFullName` = 'Jacqueline Wallman' ,`ListOfficeName` = 'Texas Homes Realty' ,`SellingAgentFullName` = 'Cecilia Cardenas' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.780224' ,`Longitude` = '-95.791161' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '309900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hurstshire Bend' ,`StreetNumber` = '406' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2673' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to go home located on a quiet street. Beautiful trees in front & back yard. Spacious 4 BR home located in desired lake community. Home features fresh paint throughout. Large Family room with coffered ceilings, crown molding & plenty of natural lighting. Formal dining/flex room includes tile flooring. Kitchen equipped with Breakfast Bar, tile flooring, tile backsplash & Granite Counter Tops. Large primary suite on 1st floor with Huge Walk-In Closet, master bath includes double sinks, separate tub & shower. Oversized Secondary Rooms upstairs as well as Game Room. Brand new A/c condenser to handle the Texas heat. Excellent Katy ISD and Close to Katy Mills Mall! This Home Won\'t Last Long.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 LAKES AT GRAND HARBOR SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WEST MEMORIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Grand Harbor' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211611661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:31:22.370' ,`MLSNumber` = '60933717' ,`ListAgentFullName` = 'Mark Lovfald' ,`ListOfficeName` = 'RE/MAX Space Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.412494' ,`Longitude` = '-95.087351' ,`PhotoCount` = '49' ,`PostalCode` = '77510' ,`RoomCount` = '18' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'AVENUE L' ,`StreetNumber` = '1910' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO THIS GORGEOUS 4/2.5 \"GRACELAND-LIKE\" CUSTOM COLONIAL ESTATE W/ 3/1 IN LAW QUARTERS SITUATED ON 3.5 PLUS UNRESTRICTED ACRES. ONCE YOU ENTER THROUGH THE AUTOMATIC GATE, YOU WILL NOT WANT TO LEAVE! FEATURES INCLUDE DRAMATIC TWO STORY LIVING AREA W/ELEGANT WOOD FLOORS AND BUILT-IN ENTERTAINMENT CABINET*LOTS OF NATURAL LIGHT*SITTING AREA W/CORNER BRICK WBFP & BUILT-IN WINE CABINET*YOUR CHEF WILL FALL IN LOVE THIS ISLAND KITCHEN W/STACKED STONE BACKSPLASH/GRANITE COUNTERS*LOADS OF COUNTER AND CABINET SPACE*RELAX IN THE TILED REAR SUNROOM*IMPRESSIVE PRIMARY SUITE DOWN*SPACIOUS SECONDARY BEDROOMS W/BUILT-INS*WATCH YOUR FAVORITE MOVIES IN THE GAME ROOM W/ACCESS TO UPSTAIRS BACKYARD BALCONY*5 CAR GARAGE W/COVERED PARKING FOR THE CAR COLLECTORS*ENTERTAIN WITH EASE WITH THIS TROPICAL BACKYARD OASIS W/POOL & AMAZING PALAPA*PLAY BALL IN YOUR PERSONAL BASEBALL FIELD TOO! TAKE A SHORT WALK TO THE IN-LAW QUARTERS W/ BLOCK PANELED STUDY*FISH IN YOUR OWN POND W/PIER*EZ ACESS TO MAJOR ROADS*' ,`Acres` = '2.65' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PT OF LOT 78 (78-6) THAMANS 1ST SUB' ,`LotDesciption` = 'Wooded' ,`LotSize` = '115434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Thamans 1st Sub' ,`TaxAmount` = '12741' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211625523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:33:29.740' ,`MLSNumber` = '79864686' ,`ListAgentFullName` = 'Donyel Jack' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740423' ,`Longitude` = '-95.344751' ,`PhotoCount` = '29' ,`PostalCode` = '77003' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Edmundson' ,`StreetNumber` = '1404' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a quaint home with character that is located in the up and coming East Downtown area of Houston known as EaDo! Look no more!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 4 MILLER' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Miller' ,`TaxAmount` = '4914' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211671367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:49:04.133' ,`MLSNumber` = '63655759' ,`ListAgentFullName` = 'Kierra Lawrence' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659150' ,`Longitude` = '-95.369362' ,`PhotoCount` = '3' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Brandon' ,`StreetNumber` = '9138' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a prime location for commuters, minutes away from the Medical Center, Downtown, and Museum district. PRICED TO SELL!!!!! BEST VALUE for this size beautiful home!!!! Close to all the best dining, shopping, and attractions Houston has to offer, plus near major highways like 610, 288, Beltway 8, and 45. Spacious covered patio in the backyard perfect for entertaining and outdoor living, open concept, luxurious finishes, soft close cabinetry, stainless steel appliances, and master bathroom retreat. 2nd-floor living can be converted to a 4th bedroom. Early buyers get to choose cabinet colors and countertops from builder selection.' ,`Acres` = '0.1596' ,`Area` = '3' ,`BuilderName` = 'Epic Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BK 1 JOKIKA LANDING' ,`LotDesciption` = 'Other' ,`LotSize` = '3475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'JOKIKA LANDING' ,`TaxAmount` = '1573' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211720699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:57:58.370' ,`MLSNumber` = '65792527' ,`ListAgentFullName` = 'Kelsey Mccollum' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.287662' ,`Longitude` = '-94.809281' ,`PhotoCount` = '21' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = '40th' ,`StreetNumber` = '1801' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Glorious Victorian home with a BASEMENT in Galveston. This beauty is ready for you to make it home! Minutes from Galveston Seawall and Harborside. This home features, a lovely library open to the cozy den, a large front porch and a dreamy covered wrap around porch in the back. It\'s the perfect retreat. The exterior of the home is freshly painted. You don\'t want to miss out on this 19th Century Home! Call today for your private tour.' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 1/2 OF LOTS 6 & 7 (2006-2) SW BLK' ,`LotDesciption` = 'Corner' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '3890' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211746586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:15:27.257' ,`MLSNumber` = '46665665' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823142' ,`Longitude` = '-95.509150' ,`PhotoCount` = '14' ,`PostalCode` = '77080' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Hollister' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor/Handyman special!! This is the Perfect opportunity to buy ASIS, remodel for resale or for rental or make your own! Buy to fix and live in it or as an investment to rent, either way this is a DEAL!!!' ,`Acres` = '0.2738' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 41 BLK 6 BINGLEWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Binglewood' ,`TaxAmount` = '6799' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211807026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:08:32.327' ,`MLSNumber` = '62833992' ,`ListAgentFullName` = 'Samantha Granato' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054948' ,`Longitude` = '-94.311672' ,`PhotoCount` = '18' ,`PostalCode` = '77713' ,`RoomCount` = '4' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Katherine' ,`StreetNumber` = '525' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This private home in the country offers plenty of space with a nice size yard, tucked away at the end of a dead-end road. Also located in sought after Hardin-Jefferson ISD. This 3 bedroom, 1 bath is the perfect spot to raise a family. Give me a call to schedule a showing or contact your favorite Realtor!! Seller is now offering $1000 in CCA!! MOTIVATED seller!!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '16 17 7 HOMESITE 1' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'CHINA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2062' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663703337' WHERE `Matrix_Unique_ID` = '211846256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:26:21.733' ,`MLSNumber` = '55863045' ,`ListAgentFullName` = 'Denise Martinez' ,`ListOfficeName` = 'Keller Williams Laredo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638578' ,`Longitude` = '-96.061983' ,`PhotoCount` = '17' ,`PostalCode` = '77485' ,`RoomCount` = '5' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Margie' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Street' ,`City` = 'Wallis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property sits on an oversized lot in a quiet neighborhood. Has great potential and space to add square footage to this property. An Investor’s gem! Located 30 minutes away from Katy Mills Mall. Call to schedule your showing today!!!' ,`Acres` = '0.29' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HRANICKY SUB (OUT OF ABST 71) LOT 31' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12810' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '54 - Brazos' ,`SchoolElementary` = 'BRAZOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOS HIGH SCHOOL' ,`SchoolMiddle` = 'BRAZOS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hranicky Sub' ,`TaxAmount` = '1273' ,`TaxRate` = '2.5395' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211858917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:40:46.557' ,`MLSNumber` = '74867043' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.746151' ,`Longitude` = '-95.512334' ,`PhotoCount` = '31' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Simmons' ,`StreetNumber` = '3001' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This pristine 4/2.5 1-story home is priced to sell and won\'t last long! The family room boasts a brick wood burning fireplace, hardwood floors, and an open concept that seamlessly transitions into the breakfast room and kitchen area. The kitchen boasts granite countertops, a gas cooktop, double ovens, breakfast bar and ample cabinetry and counter space. The primary bedroom is oversized and flaunts a private en-suite bath and a vanity area. Additionally, one of the secondary bedrooms features a half bath + built-in shelving. Exterior features include 0.4 acres of cleared and unrestricted land, 2-car detached garage, and partial fencing. Recent upgrades also include a new AC unit, ducts, etc. This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '0.4' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BOBO F (A-74), TRACT 30.1, ACRES .4' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '17424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2864' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211865810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:18:31.580' ,`MLSNumber` = '38930205' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232882' ,`Longitude` = '-95.705483' ,`PhotoCount` = '8' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '298490.00' ,`Status` = 'Active' ,`StreetName` = 'BIRCH SHADOWS COURT' ,`StreetNumber` = '40507' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Open Concept 4 bedroom 1 story home! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/5/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6071' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211865987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:55:00.633' ,`MLSNumber` = '35098150' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'M/I Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904600' ,`Longitude` = '-95.735000' ,`PhotoCount` = '5' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '391990.00' ,`Status` = 'Active' ,`StreetName` = 'Jetty Glen' ,`StreetNumber` = '8506' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This open-concept floorplan showcases a dreamy kitchen with an oversized island, and a walk-in pantry, and opens to the dining room. The secondary bedrooms share access to the hall bathroom and there\'s an added 4th bedroom.\r\n\r\nA massive walk-in closet and sloped ceiling make this owner\'s retreat the perfect oasis to relax and unwind after a long day. The owner\'s suite offers plenty of natural light with a bay window for more square footage to create the perfect reading corner. Bring that spa atmosphere to your private owner\'s bathroom which has both a soaking tub and a separate shower.\r\n\r\nContinue the fun outside with the fully fenced-in backyard and covered patio.\r\n\r\nContact us today to learn more about this amazing home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'M/I Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 4 Section 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6426' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.590968' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211867957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T16:46:39.530' ,`MLSNumber` = '78681541' ,`ListAgentFullName` = 'Tiffany Wells' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194990' ,`Longitude` = '-95.029692' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '501530.00' ,`Status` = 'Active' ,`StreetName` = 'Spyglass Hill' ,`StreetNumber` = '40242' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 1.5 story \"Ballard\" home offers 4 bedrooms, study, 3 baths & gameroom. Grand kitchen with large island, opening up to dining & living area.Samsung Stainless steel appliance, Stainless steel vent hood, 42\" designer cabinets with crown molding.Under counter lighting. Granite countertops throughout. Oil rubbed hardware. Raised panel interior doors. 5\" baseboards. Landscape package offers sod in front, side & backyard. Covered back patio. Finished out painted garage with Wayne Dalton garage door . 16 Steer TRANE HVAC. Low-e windows. Programable thermostat. PEX plumbing. All homes come with 1 year craftsmanship, 2 year mechanical and 10 year structural warranty. Sleek finishes with modern touches. GRAND OAKS RESERVE! A brand new 600+ ACRE MASTER-PLANNED COMMUNITY. State-of-the-art Community Center that will include a Grand Ball Room, Conference Room, Pro Golf Shop, and bistro-style restaurant which will wonderfully compliment the GOLF COURSE, POOL, DOG PARK, and WALKING TRAIL amenities.' ,`Acres` = '0.2106' ,`Area` = '52' ,`BuilderName` = 'Mckinley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 5, BLOCK 1, LOT 3, ACRES .2106' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '9174' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'PINE BURR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '703' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211868456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:05:28.763' ,`MLSNumber` = '14863791' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832673' ,`Longitude` = '-95.855734' ,`PhotoCount` = '24' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '422190.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1533' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely NEW DR Horton home in a GREAT location!!! Spacious open floor plan with high ceilings and open living spaces!! Amazing kitchen island overlooking dining and family room! Perfect for entertaining!! Modern and durable vinyl wood plank flooring throughout! Designer details include dark grey quartz countertops in the kitchen with a white subway tile backsplash and light grey 42\" cabinets with undermount lighting! Also features a beautiful single bowl Farmhouse style sink! Pendant light pre-wire over island and drinking water filtration system by Rinnai. One of the secondary bedrooms offers an en-suite bath for privacy! Owner\'s retreat has 2 separate closets and semi frameless glass shower! Tile to ceiling in all bathrooms! Great outdoor space with Full sod & sprinkler system in the front and back yard! Tankless water heater by Rinnai. Smart Home Technology. 16-SEER AC and insulated double pane windows! Radiant barrier roofing for added energy efficiency! Call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '9/1/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7048' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703338' WHERE `Matrix_Unique_ID` = '211868725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T17:19:30.950' ,`MLSNumber` = '49879250' ,`ListAgentFullName` = 'Michael Flores' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748299' ,`Longitude` = '-95.322177' ,`PhotoCount` = '15' ,`PostalCode` = '77011' ,`RoomCount` = '7' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Adams' ,`StreetNumber` = '224' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '224 N Adams, An incredible opportunity for anyone desiring to be in the heart of the Booming East End. Constructed beautifully up on a hill sits the opportunity of a great fixer upper. Roll up your sleeves and remodel this 1920\'s bungalow for yourself, turn into a duplex, or an vacation rental. \r\nBike or walk to local parks, bars and restaurants that are adding to this culturally rich neighborhood. Imagine hopping on the Harrisburg Hike & Bike Trail or new section Buffalo Bayou Bike trail on Lockwood and be in the Heights in 20 minutes!\r\nWelcome to Segundo Barrio.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 4 ENGEL' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Engel' ,`TaxAmount` = '2440' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703339' WHERE `Matrix_Unique_ID` = '211869407' --> Updated record success